Skip to Content
0

Problem with QTD and periodic measure in YTD model

May 18, 2017 at 09:19 AM

213

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Vadim Kalinin May 18, 2017 at 09:24 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 18, 2017 at 11:46 AM
0

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


Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin May 18, 2017 at 12:20 PM
0

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)

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

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

0
avatar image
Former Member May 18, 2017 at 12:48 PM
0

Thanks, I will try that.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0