Skip to Content
0
Former Member
May 13, 2008 at 08:33 PM

How to develop this rolling 12 Months Report

26 Views

Hi Experts

Please update me on how can i develop this query

I got the following CHAR's in Cube

Location ID,Employee No, Policy Start Date (CHAR-Dats) and Policy Expiry Date(CHAR_Dats).

Policy Start Date is Mapped to 0Cal Day in Cube

My requirment is to develop Employee Policy Expire projections for the next 12 Months (Rolling)

It should display count of employees whose policy expires in next 12 months according to the month it is expiring.

Loc ID-- Current Month -Current Month1---Current Month2---Current Month+11

1--


3
7

6

7
--


As my 0CALDAY is mapped with Policy Start Date...i can't use the Current Cal month SAP Exit

How can i achieve this