cancel
Showing results for 
Search instead for 
Did you mean: 

Time Dimension Roll-Up Not Working

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

esjewett
Active Contributor
0 Kudos

Hi Amitabha,

This is the behavior of the YTD measure, and of balance sheet accounts (AST and LEQ type accounts). Can you try your test with your report set to the PERIODIC measure and using an income statement account (INC or EXP type)?

Ethan

Former Member
0 Kudos

Hello Ethan,

You are right the first time!!! Changing the account types did the trick for us. I wish I could provide you more than 10 points, because getting the problem solved in the first reply is some luck!

P.S: Just wondering where in SAP Help this information is mentioned.

Thanks and Sincere Regards,

Amitabha

esjewett
Active Contributor
0 Kudos

Amitabha,

It's just a problem that a lot of people run into when they are getting used to BPC. Once you see it happen to 10 or 15 people, you can start to recognize it pretty quickly

There are not a lot of examples of this in the Netweaver documentation. I think there are more in the Microsoft docs. However, there is mention of it on this page in the Netweaver documentation: [http://help.sap.com/saphelp_bpc75_nw/helpdata/en/65/84d6596224477d80cc8a4392e4c114/frameset.htm]

Ethan

Answers (0)