Skip to Content
author's profile photo Former Member
Former Member

Data not rolling up to Parent Level

Working on BPC 7.5 Level 10

Member set of report are on base level.

Data Present on 2014.AUG but not rolling up to parent.

DataRolling.png (2.2 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jun 03, 2014 at 01:27 PM
    Add a comment
    10|10000 characters needed characters exceeded

    • Naveen,

      Your ACCTYPE is AST/LEQ- Thease types of accounts are Balance sheet accounts and are YTD in nature by default. This means that tha values in these accounts are till that period. So If I have values as below.

      Jan Feb March Q1

      100 150 300 300

      The value of 150 in feb is that including 100 of Jan as its the value till Feb. The periodic value for Feb would be 50. The value of march 300 is that including both 100 of jan 50 of Feb and 150 of March. So the value 300 is the value till March and hence the same value will goto Q1. This is how Balance sheet accounts (AST and LEQ) are supposed to behave. You are seeing Q1 as 0 coz you March value is 0 which means the value till March has become 0.

      EXP and INC accounts are periodic in nature. So if you post data as below.

      Jan Feb March Q1

      100 200 300 600

      The values 100 200 and 300 are only for that period and does not include the previous month balances.

      YTD measure for above posting will show you

      Jan Feb March Q1

      100 300 600 600

      I hope this clears your doubt. If still in doubt Please read more on ACC Types and storage types at SAP Help.

      Regards

      Nikhil

  • Posted on Jun 03, 2014 at 12:49 PM

    Looks like ACCTYPE of the account of the report line is AST or LEQ - then it's YTD even in periodic model.

    Then the Year total will be equal to DEC - ZERO

    Vadim

    Add a comment
    10|10000 characters needed characters exceeded

    • Naveen,

      I am storing Data with Periodic Measures.

      Jan Feb Mar Q1

      100 50 0 --- Q1 will be 0 as your ACCTYPE is AST/LEQ

      Now when i change the Measures in REPORT to YTD or Keep Periodic(By default AST and LEQ account type will refer to YTD).

      Jan Feb Mar Q1

      100 50 0

      As per the logic explained by you

      --> Data present for JAN,FEB on Periodic 100,50 - Yes . But when you say Feb Data is 50 it means your value has reduced from 100 in Jan to 50 in Feb which means the periodic value of Feb is -50. Dont get confused. For AST/LEQ value of 50 in Feb means the total balance till Feb is 50. You are getting 0 in Q1 as your March value has become 0 which means your total balance at the end of March is 0 and hence your Q1 ending March shows value 0. If you post something in March then your Q1 will show the same value.

      For AST/LEQ the Q1 value is same as the March value and Year.TOTAL value is same as Dec Value.

      -->Data should be when YTD JAN,FEB 100,150. For AST/LEQ ACCTYPES Measure YTD and Periodic show same values as AST and LEQ are YTD in nature by default.

      Nikhil

  • Posted on Jun 03, 2014 at 06:18 PM

    HI Naveen

    There are 2 aspects to this , the txn data loaded to BPC and the values displayed agst measures in BPC. Once the value is there BPC converts it into Periodic / UTD per reqt.

    So in your case , if your txn system is YTD , the balance of 200 would come as Sep value and get loaded into BPC cube. It will then get displayed in Sep and agst Q3.

    If the value is not loaded , BPC will take it that the final YTD values is zero and Sep balance was -200.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.