Time Dimension Roll-Up Not Working

181 Views

Hi Gurus,

We are on BPC NW 7.0 SP04. We are experiencing a strange problem with Time dimension. Even after defining the hierarchy correctly, the values are not being rolled up the hierarchy. Our requirement is to capture data at quarter level and year level. So we have defined the time dimension in following manner:

ID EVDESCRIPTION PARENTH1 LEVEL YEAR PERIOD STYLE MONTHNUM TYPE TIMEID HLEVEL

2007.TOTAL 2007 TOTAL YEAR 2007 TOTAL T3 12 ACT 20070005 1

2007 2007 2007.TOTAL QUARTER 2007 Q1 T2 13 ACT 2

2007.Q1 2007 Q1 2007.TOTAL QUARTER 2007 Q1 T1 3 ACT 20070001 2

2007.Q2 2007 Q2 2007.TOTAL QUARTER 2007 Q2 T1 6 ACT 20070002 2

2007.Q3 2007 Q3 2007.TOTAL QUARTER 2007 Q3 T1 9 ACT 20070003 2

2007.Q4 2007 Q4 2007.TOTAL QUARTER 2007 Q4 T1 12 ACT 20070004 2

Here TYPE is a custom dimension property . As the members depict, 2007.TOTAL value should be calculated as the sum of 2007.Q1, 2007.Q2, 2007.Q3 and 2007.Q4 (Quarters and Years are mutually exclusive in our case). But when we maintain data for Q1,Q2,Q3 and Q4, the TOTAL value is displayed as the value of Q4, and not the sum of quarters. We have tried changing MEASURES from PERIODIC to QTD and YTD, with no effect. We thought that it could be a problem with BI, and so built a simple BeX Query on top of the BPC application cube. But in the BEX query, the time dimension is properly aggregated, nd values are displayed correctly. So apparently it is not a problem with BI. In that case, we are missing something in BPC itself. Can any of you identify what it could be? Awaiting answers and Thanking in Advance.

Sincere Regards,

Amitabha