Skip to Content
0
Former Member
Oct 22, 2012 at 12:00 PM

Need help in xcelsius dashboard query browser prompt execution

35 Views

Need help in xcelsius dashboard query browser prompt
execution.

We are building dashboard on bex query.

Below is our requirement.

  1. Using
    query browser option create one query in dashboard and some prompts like
    customer , equipment and func loc etc.
  2. 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/
  3. For
    eg: for input 100023, prompt need A1/100023. So concatenating A1/ internally.
  4. When
    user enters all 3 prompts , dashboard is working fine.
  5. 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 .
  6. 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.