Need help in xcelsius dashboard query browser prompt
execution.
We are building dashboard on bex query.
Below is our requirement.
- Using
query browser option create one query in dashboard and some prompts like
customer , equipment and func loc etc.
- Prompts
should receive input from outside of xcelsius , so we are using flash variables
for this. This input data should be compounded with source id like A1/
- For
eg: for input 100023, prompt need A1/100023. So concatenating A1/ internally.
- When
user enters all 3 prompts , dashboard is working fine.
- If
user don’t enter any of the prompt among three, dashboard is not working and
showing anything. We have already set all these prompts as optional .
- When
prompt is directly pointed to blank cell it is executing. But if we write
formula like below dashboard is not
working properly.
=IF(ISBLANK(V2),"",Y4)
Here V2 is input cell receiving
input from outside.
Y4 is A1/100023
Any help.