Age not getting updated for past months
I have loaded the cube 0PA_C01 for HR data regarding Personal Administration.
Since I have loaded the cube in April,therefore in the cube when I see I get the correct Age of an employee for April.But for March,Feb and Jan I am not getting the Age as it is not getting updated.I checked the update rule 0HR_PA_0 and 0HR_PA_1,according to me it calculates the age based on system date.
The data in my cube looks as below:
AGE CALMONTH HEADCOUNT
15 042006 1
20 042006 1
and so on.
Could you please suggest how to get the Age for past months?
Thanks in advance.