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--
As my 0CALDAY is mapped with Policy Start Date...i can't use the Current Cal month SAP Exit
How can i achieve this