Question Re: 2020.TOTAL Shows No Data in BPC report in Financial Management Q&A

2020.TOTAL Shows No Data in BPC report

former_member212236 — Tue, 31 Mar 2020 18:23:50 GMT

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

Re: 2020.TOTAL Shows No Data in BPC report

former_member186338 — Tue, 31 Mar 2020 18:27:25 GMT

In YTD model Year Total= December

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

Re: 2020.TOTAL Shows No Data in BPC report

former_member212236 — Tue, 31 Mar 2020 18:31:57 GMT

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.

Re: 2020.TOTAL Shows No Data in BPC report

former_member186338 — Tue, 31 Mar 2020 19:49:02 GMT

vinoth.v

Sorry, but I have no info about MGMT_IFRS model

What is the default storage type for this model?

Re: 2020.TOTAL Shows No Data in BPC report

former_member212236 — Wed, 01 Apr 2020 13:41:53 GMT

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

Re: 2020.TOTAL Shows No Data in BPC report

former_member186338 — Wed, 01 Apr 2020 13:58:41 GMT

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

Second - please show report with December and TOTAL visible.

2020.P12 and 2020.TOTAL

Re: 2020.TOTAL Shows No Data in BPC report

former_member212236 — Tue, 07 Apr 2020 18:26:54 GMT

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?

Re: 2020.TOTAL Shows No Data in BPC report

former_member186338 — Wed, 08 Apr 2020 00:00:17 GMT

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

Re: 2020.TOTAL Shows No Data in BPC report

former_member186338 — Wed, 08 Apr 2020 00:02:44 GMT

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

And to play with figures.

Re: 2020.TOTAL Shows No Data in BPC report

former_member186338 — Wed, 08 Apr 2020 01:43:05 GMT

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

Re: 2020.TOTAL Shows No Data in BPC report

former_member212236 — Thu, 09 Apr 2020 09:51:00 GMT

Thank You Vadim.