we have an issue for specific users in our Xcelisus/Business Objects Dashboards Solution.
Some users have their authorization limited to the variable Organisational Unit which is also used as a Filter Prompt in the Dashboard.
For those users the following happens:
They execute the Dashboard
Filters are loading their values
Error "USER_NOT_AUTHORIZED" appears.
The user clicks OK and then selects any value in the LOV of the Organisational Unit.
The Dashboard works fine.
The issue is thus apparently that Dashboard is not able to fetch the default values based on the user authorization but instead "trys" to show all OrgUnits to the Users which of course leads to "no authorization"
When executing the underlying query in the Web the prompt shows the default value in the "Organisational Unit" per default:
Would the user remove that value, he would also get the error "no authorization" of course.
Is there any way to prepopulate and pass the values to the filter prompt in Xcelisus?
I read somewhere else that Support Pack 07 for BI 4.0 is supposed to fix that - any experience on that?
Thank you for your help!