Very urgent - Regarding variables on Multicube.

[Former Member]

Hi Experts

I created a multicube using two basic cubes(one for R/3 data and another one for CRM Data).

In my reports i want to put 2 variables for CRM(Debit memo date) and R/3 (Billing Date).

when i execute the report without entering any values for both the dates i am getting the values from both the cubes.

If i enter the dates in selection condition for both the variables i am not getting the values.

If I enter one variable value and viceversa i am getting the values from the respective cube.

so why i am not getting the valuse by entering values for both the varibales in selection.

Thanks

Shiva

[Former Member]

Hi,

Both dates are based on 0CALDAY. Looks like you give different selections for 0CALDAY and the system doesn't understand which one to use. Try to give the same dates for both variables. Will it bring any data?

Which selections have you tried already?

Best regards,

Eugene

Message was edited by: Eugene Khusainov

[Former Member]

Hi,

I hope, you are using these variables (on Debit memo date and on Billing Date)either in the filter area or in Rows area.

If so, instead of taking there, use them in the restriction of KF.

Kindly mention the columns(kfs) in the query ,If you have still doubts.

With rgds,

Anil Kumar Sharma .P