Skip to Content
0
Former Member
Oct 10, 2006 at 09:07 AM

Last year's corresponding date's reveneue in query

25 Views

Hi,

We have a requirement to present data (from Sales cube 0SD_C03) in following format.Infocube has 0CALDATE and 0BILL_DATE is used to populate billing date in 0CALDATE in update rules.

Billing date Revenue Last year's reveneue

11.08.2006 5000 4000 (for 11.08.2005)

12.08.2006 4000 4000 (for 12.08.2005)

13.08.2006 3000 5000 (for 13.08.2005)

We have defined the query and the data for month August 2006 appears fine. How can be obtain Last year's corresponding date's revenue ?

When we use restricted key figure (with offset -365 on 0CALDAY) to get last year's revenue, query presents the data in two lines, as below.

Billing date Revenue Last year's reveneue

11.08.2006 5000

11.08.2005 4000

How do we get the desired result. Please guide.

Regards,

Piyush