cancel
Showing results for 
Search instead for 
Did you mean: 

Staggered report (Monthwise) with structures(??)

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You would be doing this in the cube and not the query .

Former Member
0 Kudos

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

Former Member
0 Kudos

Hey Anil,

Thanks man for your explanation. Couldnt visit this forum for a while so kind of late. But I was wondering if you could help me out by letting me know what I need to do in the user exit.

Thanks,

Doniv

Former Member
0 Kudos

And also can we do that for the current year, without the user having to enter the year in the variable?

Thanks,

Doniv

Former Member
0 Kudos

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'.

Former Member
0 Kudos

Hi Krishna,

Can you be more elaborate if possible. How do you think, I can restrict the selection of 0CALMONTH based on the entry on 0CALYEAR. Please note that I am looking for a report of Jan thru Dec of a particular year and not a report of the last 12 months.

Thanks,

Doniv