Want to pass multiple values from query prompt to a Xcelsius placed combo box

[Former Member]

Dear Gurus:

I am having a prompt on my dimension e.g. X, the dimensions having two options X1 and X2 coming from BW.

Now I have placed a combo for prompt and written x1 and x2 in the source cells of combo using insertion type row. Working fine. But my requirement is also to show third option as total i.e. x1 and x2 sum as I am using in list prompt.  What should I do if I want to see x1 and x2 total through combo box.

In addition it is working fine at query level but when I placed the prompt at combo using Xcelsius the third option total factor not working.

I will appreciate your suggestions.

Regards:

Jawad

[former_member182541 · Accepted solution]

Are you talking about the list of values for the dimensions, like Plant A and Plant B and you want the option of "ALL", is that you looking for ? In this case you can pass the empty cell and you can get the overall sum values for the Plant.

[Former Member · Accepted solution]

HI suman:

You are spot on. Thats what I want.Plant A and Plant B sum as total as third option through combo.

But kindly elaborate your answer as I am not getting it.

Thanks.

[former_member182541 · Accepted solution]

Call the plant master for the list of values and add "ALL" text in top of the values and pass the empty cell to the prompts. Please check the below thread, which have already explained in detail on this.

Hope this helps!!!

[sriramvijay_ravidoss]

Hi,

What is the connectivity?

-Sriram