Skip to Content

SAP BPC 10 - Hierarchy Aggregation for Custom Time dimension not working


We are using BPC 10 in that as per the Client requirement for Consolidation we created a new Time Period 2013.00 (Opening Period of 2013)

Now when we are extracting the report I am unable to see any aggregated data for entire year from (2012-2013) inside 2013.00

As I can only see the data at Base Level and not for any Members & Children.

Now I want to see the proper aggregated data with proper hierarchy what changes are required in Time dimension or any other changes are expected?

Please help need your guidance.



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jan 13, 2015 at 07:38 AM

    Hi Ravi,

    Please, show the screenshot of the TIME dimension in the administration!


    Add comment
    10|10000 characters needed characters exceeded

    • Where you want to see this period - in 2013 as opening?

      Then it has to be under 2013.TOTAL. 2013.TOTAL in your case is a fiscal year, not a calendar!


      P.S. Please, follow my instructions and check the result!

  • Jan 13, 2015 at 07:12 AM

    Also to add the above information in SAP BPC 10 NW we have defined the Consolidated Model with Data entry mode as "YTD"

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 13, 2015 at 07:35 AM

    Hi Ravi,

    Why do you require 2013.00 as opening period ? any specific requirement?

    Bellow is the standard structure of TIME dimension having 12 months , 4 quarter, for 1 year .


    If you want to add 2013.00 in total year then assign parent 2013.TOTAL to it.


    Add comment
    10|10000 characters needed characters exceeded

    • First - there is no screenshot, I want to see all months of the year!

      Second - for this special member 2013.00 create standard 3 level structure:




      Where 2013.Q0 - artificial quarter 0