Problem with QTD and periodic measure in YTD model

[Former Member]

Hi,

we are currently migrating from BPC 7.5 to BPC 10.1. We have a consolidation model which is a YTD model. In BPC 7.5 the QTD and periodic measures when used in evdre reports showed the correct numbers.

In BPC 10.1 we now have the following problem.

QTD shows the correct values in any period in Q1, incorrect values (YTD values) in the first period of each following quarter but correct values for all other periods (income statement accounts).

Example:

Month YTD value QTD value

1 100 100

2 200 200

3 300 300

4 400 400

5 500 200

6 600 300

7 700 700

8 800 800

The periodic values simply show YTD values, which I would expect on balance sheet accounts but not on income statement accounts.

Has anyone had this issue before and solved it?

Thanks,

Arnold

[Former Member]

Thanks, I will try that.

[former_member186338]

In BPC 10 some hidden hierarchies are automatically created for TIME dimension assuming all members have 3 level hierarchy.

[former_member186338]

Your issue is related to INP members

INP members has to be inside 3 level hierarchy like normal members:

2015.INP Level: MONTH Period: JAN TIMEID: 150100 (to be outside of normal TIMEID sequence) YEAR: 2015 PARENTH1: 2015.QIN

and extra members:

2015.QIN Level: QUARTER Period: Q1 TIMEID: - (no TIMEID on parents) YEAR: 2015 PARENTH1: 2015.YIN

2015.YIN Level: YEAR Period: TOTAL TIMEID: - (no TIMEID on parents) YEAR: 2015 PARENTH1: -

P.S. Remove TIMEID from parents to make dimension structure more clear (TIMEID on parents has no effect)

[former_member186338]

P.P.S. TIMEID is used for TMVL function in scripts.

To my mind INP has to be outside of normal month sequence

[Former Member]

For the ACCTYPE we use all four members, AST and LEQ for the balance sheet and INC and EXP for the income statement. These settings are correct and we had no issue with the periodic measure in BPC 7.5

Here is a screenshot of part of the TIME dimension, I have also attached the full dimension in csv format.

fileserver01ctx-redir-zbminfomotionawamy-documents.txt

What the screenshot does not show are the INP elements for entering annual plan data but they are included in the attached file.

Thanks,
Arnold

[former_member186338]

Looks like your TIME dimension is configured incorrectly.

Please post TIME dimension screenshot with properties visible. Do you have some special members in TIME dimension like XXX.INP?

"The periodic values simply show YTD values" - hope that ACCTYPE is configured properly in account dimension.