Skip to Content
0
Former Member
Jan 12, 2008 at 04:30 PM

Using Multiple Variables in Query

8 Views

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