Hi Experts,
For Dashboards I can use two types of prompts: BEx and BO query prompts.
1. If the bex query has existing prompts, while adding this query to the dashboard, I am forced to enter values (incase of mandatory variables).
Lets assume my bex query has one mandatory prompt for company code. When i add this query to the dashboard using query browser, it asks me to enter a value for this prompt. Say i enter cc1. The query then executes and i get results in the dashboard. When i now execute this dashboard from the BI launchpad, it does not ask prompt me to enter a value for company code, it directly takes cc1 as the entered value and displays results. Is this the expected behaviour? If so, how can the user change the prompt value at runtime?
2. Lets assume my infocube has the following data
Company Code Plant Amount CC1 PP1 10 CC1 PP2 20 CC2 PP2 30Now if I have a bex prompt on company code, and i enter cc2 while adding the query at dashboard design time (like i did in point 1).
I also add a bo query level prompt in the query panel for Plant. Also i add a query selector for plant in the dashboard.
At runtime, the bex prompt considers cc2 for compnay code and returns only row 3. If I check the query prompt selector of plant, it shows only one value to choose from: PP2. Does this mean that the bo level prompt only takes the list of values from the result set returned by bex?
Please share your inputs.
Thanks,
Suraj