Skip to Content
avatar image
Former Member

Problem with QTD and periodic measure in YTD model

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • May 18, 2017 at 09:24 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 18, 2017 at 11:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 18, 2017 at 12:20 PM

    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)

    Add comment
    10|10000 characters needed characters exceeded

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

    Thanks, I will try that.

    Add comment
    10|10000 characters needed characters exceeded