Using Multiple Variables in Query

[Former Member]

Hi,

I know that it is possible to use multiple variables in BEx, but i am really struggling to get mine working as should. My scenario is that i am using a keydate for which i have created 2 customer exit variables, one to calculate the current week, one to calculate the previous week and one that derives the month from the input date to display the planned values.

In my query i'm having planned & actual values based on 0VTYPE. When it is related to Actual values i call the 2 customer exit variables that then calculates the weeks based on the posting date and then displays the data accordingly. This is working perfectly. When i utilize the planned values with the variable that is based on 0CALMONTH, then the values are coming through as 0 although they do exist on the cube.

Could anyone please help me with some code to solve this or maybe with some guidance on how to accomplish the using of these 3 different variables based on the key date input?

Hoping to hear from you soon.

Thank you in advance,

Casper

[Former Member · Accepted solution]

Hi,

Can you give detailed explanation of your Keyfigures:

KeyFig1

Restricted to CHAR_XYZ

Filtered to VAR_1

VAR_1 = VAREXIT calculating ....

KeyFig2...

....

that would help greatly to fix your issue...

Olivier.

[Former Member · Accepted solution]

Thanks guys for all your responses. I have assigned points. We fixed the problem by using a replacement path variable.

If you are interested in the solution, send me your e-mail address and i'll forward the solution to you.

Regads,

Casper

[Former Member]

Send me your mail address then i will forward the solution.

[Former Member]

I have the Problem but in the WEb Template as a Jump Target with Two different Variables. In The Target Screen only the value for one of the variables is displayed how do i go about this?