Skip to Content

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

Hi,

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.

Regards,

Ravi

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!

    Vadim

    Add comment
    10|10000 characters needed characters exceeded

  • 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 .

    IDPARENTH12013.012013.Q12013.022013.Q12013.032013.Q12013.042013.Q22013.052013.Q22013.062013.Q22013.072013.Q32013.082013.Q32013.092013.Q32013.102013.Q42013.112013.Q42013.122013.Q42013.Q12013.TOTAL2013.Q22013.TOTAL2013.Q32013.TOTAL2013.Q42013.TOTAL2013.TOTAL

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

    Shrikant

    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:

      2013.TOTAL

           2013.Q0

                2013.00

      Where 2013.Q0 - artificial quarter 0

      Vadim