First Report refresh: failed

[Former Member]

Hi Experts,

we have a strange issue with a report, BPC NW 10.

This report expands the Base Level of a dimension on Row Axis. In Report Editor no member of this dimension is selected, only the option Base Level.

The report works fine with an admin user.

Then I try to open it when I'm logged in with a user with a security restriction on the dimension epanded and something strange happens:

The first time I refresh the report nothing happens, the "Process in progress" icon appears for a few seconds but no member/data are retrieved.

After that, when I refresh again, the reports correctly retrieve only the members the user has access right.

Is it normal? How can I avoid this strange behaviour?

Furthermore: I'd like to have no member on the template when I save it. I know there's the "Clear data when saving template" option, is there something similar for the rows members?

Thanks for your valuabel assistance.

Best regards

Michele

[Former Member]

Hi Michele,

You can create the template as Raju has described. Create the template with some dummy member which doesn't have any data.

Once the template is opened, the user needs to refresh the template to see his relevant members. This will work fine.

But what I dont understand is that your first refresh is not working fine. Can you please check the log, before refreshing it the second time.

[Former Member]

Hi Nilanjan, Hi Raju,

we are currently on SP12 patch 4, it should be the latest EPM Add-in version available.

I've already tried what Raju described, so I set the context in order to have dummy data. I also enabled the option Remove Empty Rows.

So no data is retrieved and the row axis is hidden. Anyway I still have an hidden first row (with no data but valid header) with a random member of the dimension I expand.

The problem is that the second user I log with has no access to this member, that's why I believe the first refresh fails.

Here is the complete log:

"

2012-10-09 09:06:31,269|ERROR|ReportManagement|FPMXLClient.ReportManagement.DynamicReport.Load|TEST_USER2|||||1|bytes = 0#

2012-10-09 09:06:32,390|ERROR|FPMXLClient|FPMXLClient.ReportManagement.SheetReport.ScanMemberAtCell|TEST_USER2|||||1|Invalid member : [FUNCTIONAL_AREA].[PARENTH1].[FA_XCWCC]#

2012-10-09 09:06:36,510|ERROR|EVFunctions|FPMXLClient.TechnicalCategory.GetResult|TEST_USER2|||||1|Invalid member : FA_XCWCC - CMC-Content Coord.#

2012-10-09 09:06:36,573|ERROR|EVFunctions|FPMXLClient.TechnicalCategory.GetResult|TEST_USER2|||||1|Invalid member : #

2012-10-09 09:06:36,797|ERROR|EVFunctions|FPMXLClient.TechnicalCategory.GetResult|TEST_USER2|||||1|Invalid member : #

2012-10-09 09:06:36,826|ERROR|EVFunctions|FPMXLClient.TechnicalCategory.GetResult|TEST_USER2|||||1|Invalid member : #

2012-10-09 09:06:36,846|ERROR|EVFunctions|FPMXLClient.TechnicalCategory.GetResult|TEST_USER2|||||1|Invalid member : #

2012-10-09 09:06:36,970|ERROR|FPMXLClient|FPMXLClient.ReportManagement.SheetReport.ScanMemberAtCell|TEST_USER2|||||1|Invalid member : [FUNCTIONAL_AREA].[PARENTH1].[FA_XCWCC]#

2012-10-09 09:06:44,598|ERROR|EVFunctions|FPMXLClient.TechnicalCategory.GetResult|TEST_USER2|||||1|Invalid member : #

2012-10-09 09:06:44,625|ERROR|EVFunctions|FPMXLClient.TechnicalCategory.GetResult|TEST_USER2|||||1|Invalid member : #

2012-10-09 09:06:44,651|ERROR|EVFunctions|FPMXLClient.TechnicalCategory.GetResult|TEST_USER2|||||1|Invalid member : #

2012-10-09 09:06:44,670|ERROR|EVFunctions|FPMXLClient.TechnicalCategory.GetResult|TEST_USER2|||||1|Invalid member : #

2012-10-09 09:07:26,006|ERROR|ReportManagement|FPMXLClient.ReportManagement.DynamicReport.Load|TEST_USER2|||||1|bytes = 0#

2012-10-09 09:07:26,829|ERROR|FPMXLClient|FPMXLClient.ReportManagement.SheetReport.ScanMemberAtCell|TEST_USER2|||||1|Invalid member : [FUNCTIONAL_AREA].[PARENTH1].[FA_XCWCC]#

2012-10-09 09:07:29,384|ERROR|EVFunctions|FPMXLClient.TechnicalCategory.GetResult|TEST_USER2|||||1|Invalid member : FA_XCWCC - CMC-Content Coord.#"

[Former Member]

Hi Michele,

That explains the reason. Due to restricted access, this is happening.

[Former Member]

Hi Nilanjan,

thanks.

So isn't there any solution to avoid this member in the firs row?

The annoing part of the issue is that when the first refresh fails, it also changes the structure of the report: I have a couple of blank columns to separate actual from planning values, but these blank columns are removed during the first refresh.

Note that I have enabled the Keep all empty columns and that the report works fine for user with no restricted access.

Thanks for your attention.

Best regards

Michele

[Former Member]

Hi Michele,

You can try using dimension override function. This function should display all the members of the dimension. So, when a user opens the report and refreshes it, he will be able to see all the member to which he has access.

Hope this helps.

[Former Member]

Hi Nilanjan,

Ok thanks I'll try that.

I'd like to ask you also why I keep getting this error:

2012-10-09 09:58:38,069|ERROR|EVFunctions|FPMXLClient.TechnicalCategory.GetResult|MGL|||||1|Invalid member : #

I get it also with a full access right user.

Thanks for your attention

Best regards

Michele

[Former Member]

Hi Michele,

Please check the time of this log (the first column of the log). Is it the same as your report refresh time? If no, then this is the information for some previous execution.

Hope this helps.

[Former Member]

Hi Nilanjan,

I've already checked, it's related to the report refresh but I don't know what's the meaning of this log.

Thanks for your attention.

Best regards

Michele

[Former Member]

Hi Michele,

Its correct that its related to the report refresh. But is it related to the latest refresh? You can figure this out by refreshing your template now, and see the log whether you get any message for the current time or not.

The log says that there is some # member defined in your template, and its not recognizable by the system.

Hope this helps.

[Former Member]

Hi Nilanjan,

yes it's related to the latest refresh. If I refresh again the report I get another equal log.

I dont' understand which may be the cause, why the member is not recognizable.

I tried also with EPMDimensionOverride as suggested, agai the report works fine only with full access user.

The problem is that whenever I save the template there is alway a row with a member that is not accessed by the second user I log with.

Do you have other suggestions?

Thanks for your valuable assistance.

Best regards

Michele

[Former Member]

Hi Michele,

It would be hard to suggest anything without the seeing the template structure.

[former_member190501]

Hi,

Can you try in latest EPM Add-in SP.

If my understanding is correct, you want to save report with no rows:

Select Remove Empty and Zero values of rows from Sheet Options. Run report for dummy member which is not having any data and save report.

Hope it helps...

regards,

Raju