two of our users get the following error message, when opening two specific reports:
First Report: Cannot find Dimension Scenario.
Second Report: Error executing query: the member null doesn't exist in this application.
Other users can access these reports, and the same users where the problem occurs can access other reports in the same folder.
I set the same rights for me, but i can access the reports without problems.
Somebody encountered the same problem before?
The first place to look at when you have errors like this is security. If you are using filters then check whether those users have correct filters.
Another check is to see whether there is a POV limit.
Hello i found this thread before but it does not help.
I setup a new User in native directory and gave him ALL rights and roles.
The error occured again for the new user.
I found the manageuserpov.cmd tool and exported the pov, changed it to the same like the admin account where the report works and imported the .xml.
There are no errors when importing, but if i export again the pov is still the same like before the import.
Do i have to restart something to take effect?
I had the same issue a few weeks ago... not sure how it happened but it was related only with my username.
In order to fix it:
1. I created a report which does not require to select the scenario in advance. Try to use the default data-grid that you get when you first create a report for example.
2. When the user runs the report, try to see if he can see the dimension. Do not use the missing dimension on rows or columns. If he can see the dimension, ask him to select one scenario. This will solve the issue.
3. If he cannot see the dimension, try to change the layout of the report.