First Report refresh: failed

76 Views

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