Skip to Content
0
Former Member
Oct 21, 2005 at 08:05 AM

Please Help on this BeX Report Requirements

18 Views

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