Hi experts,
I have a cube which has the following key figures:
1) Plant %
2) History
These are the chars:
1) 0CALDAY, 0CALMONTH, 0CALWEEK
2) MATERIAL
3) PLANT
I need to have report that looks like this
PLANT A PLANT B PLANT C
History <the user should be able to select the time
horizon for this row>
Plant % <the data here should be for 0CALDAY = today
always>
Now, any ideas on how can i show the rows in report with two different time ranges? (i.e History horizon should be selectable by user, Plant % horizon = today). I believe the history requirement is easy to solve. I am just confused on how can i fix the range for the plant % and have the user able to select the range for history.
I am new to BeX. Any ideas for this one is trully appreciated?
Thank you and Best Regards,
Emmanuel