If the Authorization relevant Characteristic has a variable which is “input ready”, the end users will get a “no_user_authoriztion” error for the fist execution of the Dashboards. this is due to the design that for all the input ready prompts from BEx if no input is done, they are understood by BW as *.
Since is it also not possible to define a default value for the prompt which is customized to each user, it is difficult to avoid this authorization error.
It is a work around, but may lead to wrong data when exceptional aggregation is defined.
Step 1: define the authorization variable as ” not input ready”.
for the first execution of the Dashboards, only the authorized data will be read from BW –> Error is avoided.
Step 2: Use a Combo Box as selector in the Dashboards.
basically, it is a “local” filter in the excel. the green part is mapped from Query Browser for the Query result. Use the Combo Box to filter the rows and put the filtered data to the blue part.
In this sample, Calendar year is also an prompt from BEx Query. We cannot just define the Airline as a filter in dashboards. if one prompt is defined in the dashboards, and the other one is from BEx, Dashboards will concern if there is dependency between them. As Dashboards is not that super smart, it will just allow we to use only one prompt. This is also the reason that I have to use Combo Box here( you can also use other selectors).
The blue part is now ready for the charts or tables as the output of dashboards.
An ugly sample I did:
If you have any better ideas, please let me know.