Skip to Content

2020.TOTAL Shows No Data in BPC report

Hello All,

Could you please provide some insights on the below issue.

BPC Version - 10.1
BPC Cons Model - Costcenter IFRS

Issue:

I had created a simple report with Accounts in Rows, Category and Time dimension in Columns.

I am unable to view the 2020.TOTAL even though the related members have got values for the the periods 1,2 & 3 for the category ACTUAL. The CC model has got data for the same selections.

Note:

I am able to see values for 2020.TOTAL for BUDGET without any issues.

I am able to see values for 2019.TOTAL for both ACTUAL and BUDGET without any issues.


From one of the SCN thread, I found the below fix and tried.

The value became visible under 2020.TOTAL when I enable the the option “calculate Parents in hierarchies” under sheet options and expand 2020.TOTAL. This value goes off when I shrink it back. (not shown in screenshot). This does not seem to be a solution instead a workaround.

Questions:

1. Why am I unable to see the 2020.TOTAL cell populated with the lower member values?

2. Why should I enable the option calculate Parents in hierarchies, to see the value populated under 2020.TOTAL alone?

3. Why am I experiencing this only in Costcenter Model and that too only for 2020.TOTAL Actual?

Things I had checked already:

1. The account used above is not a balance sheet account with LEQ / AST type account.

2. The master data TIME dimension and Category dimension does not seem to be an issue as we are able to see data for ACTUAL under 2020.TOTAL in MGMT_IFRS model.

3. No issues with the way how Time Hierarchy has been defined as well.

4. Ensured that the requests in the cube are compressed without any issues.

5. Tried switching the axis but no luck.

6. Looked for any extra spaces in the Master Data but none found.

Please let me know your thoughts on what could possibly causing this issue.

Regards,

Vinoth V

report.jpg (214.7 kB)
backend.jpg (93.7 kB)
hier.jpg (36.4 kB)
time1st-half.jpg (113.2 kB)
time2nd-half.jpg (120.4 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Mar 31 at 06:27 PM

    In YTD model Year Total= December

    If you have no data in DEC then Year total is empty!

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 01 at 01:41 PM

    Both the MGMT_IFRS and CC_IFRS models are with storage type YTD.


    cc.jpg (27.0 kB)
    mgmt.jpg (27.4 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 07 at 06:26 PM

    Hi Vadim,

    I am unable to submit the content if I use Comments. tried several times, hence posting here. Bear with me.

    Thank You for your inputs. You are correct. I had checked the MGMT_IFRS model and expanded in 2020.TOTAL, where I am able to see that the values are present until December 2020. I also noticed that at the backend the April month's data was getting, carry forwarded until December this was not happening in the CC_IFRS model.

    This gave me a conclusion that the YTD won't work if December month value is blank. However, I had also seen one more scenario in the MGMT_IFRS where two accounts do not have data for January but had got data for Feb and March where it was not carry forwarded until December (refer screenshot Total).

    Is it like YTD would consider both Jan and December to populate the TOTAL?


    mgmtif.jpg (175.4 kB)
    cc.png (26.8 kB)
    total.png (26.6 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 08 at 12:00 AM

    "I also noticed that at the backend the April month's data was getting, carry forwarded until December"

    There is no automatic carry forward in BPC. It has to be configured!

    For the rest I have to repeat AGAIN and AGAIN:

    YTD Year TOTAL= YTD December value!

    Data in Jan, Feb is not related to YEAR TOTAL, only December!!!

    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.