2020.TOTAL Shows No Data in BPC report

[former_member212236]

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

[former_member186338 · Accepted solution]

In YTD model Year Total= December

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

[former_member212236 · Accepted solution]

Thank You for your response, Vadim.

If that is the case, then I should not be able to see values in the MGMT_IFRS model as well, right?

But that is not the case. In the MGMT_IFRS model, I am able to see data for 2020.TOTAL for ACTUAL.

[former_member186338 · Accepted solution]

vinoth.v

Sorry, but I have no info about MGMT_IFRS model

What is the default storage type for this model?

[former_member186338]

"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!!!

[former_member212236]

Thank You Vadim.

[former_member212236]

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?

[former_member186338]

Is it so hard to create a simple input form in the copy of ENVIRONMENTSHELL Consolidation (YTD) model?

And to play with figures.

[former_member186338]

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

There is a well-known limitation for comments: only 2 images can be inserted in a single comment. But you can use 2 comments for 4 images etc!

[former_member212236]

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

[former_member186338]

First - please, stop posting "answers" instead of correct comments!

Second - please show report with December and TOTAL visible.

2020.P12 and 2020.TOTAL