on 07-05-2005 9:42 PM
Hi Guys,
I have a reporting requirement, where I need to diplay the month-wise report of the number of orders for a particular year. I have an infoobject of "date of order". Is there a way of designing a structure in the BEx report where on the user entry on the year, we can have the 12 months in the structure.
Thanks,
Doniv
You would be doing this in the cube and not the query .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
1) First of all in your cube's update rule , make sure that 'date of roder' is mapped to 0calday.And The fields ocalmonth,...etc are being filled by automatically.
2) In query you have to define 12 selections(columns).
3) Make a filter on Ocalyear with variable (user entry)
4) Each selection includes 'no of orders ' key figure and it is restricted to 0Calnonth variable .
5) In user exit calculate the value for 0calmonth(single ,mandatory) from the value of user entered year (by 0calyear) .Here you will calculate first month of year.
6) In selections use offset values 1 ,2.--,+11 respectively.
With rgds,
Anil Kumar Sharma .P
Kindly assign points, If it helps you.
Message was edited by: Anil Kumar Sharma
If my understanding is right , then you want to see 12 mths data once the user enters the cal year . I think you can achieve this by mapping your ocalday, ocalweek calmonth and ocalyear in the time dimensions of the cube to the 'Date of Order'.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.