Skip to Content

UJA_FORMULA_APP change initial month after restart the server

Hi BPC Friends

We have set up in the dimension time in BPC May as first month and the model is ytd.

We have restarted the BW Server and in the table

UJA_FORMULA_APP

the initial month was changed.

is that a bug?

Thanks Michele

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 31, 2016 at 04:04 PM

    "We have set up in the dimension time in BPC May as first month" - What do you mean??

    The dimension administration screenshot is required to understand what you have done.

    Also screenshot of SE38 UJA_MAINTAIN_MEASURE_FORMULA...

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 01, 2016 at 09:20 AM

    BPC Starting Month has no effect on formula etc!

    In order to have correct TIME dimension with May as first month of the Year you have to assign PERIOD property for May to JAN (Jun to FEB, etc...)! MONTHNUM property has to be also set correctly: May - 1, Jun - 2... YEAR property has to be set for fiscal year.

    I have already answered this question many times, please search!

    Please show the corrected screenshot!

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 08, 2016 at 11:07 AM

    Unfortunately the comment chain is over!

    In general the rule is simple:

    You have standard TIME dimension in ENVIRONMENTSHELL! You have to use something like:

    Property values for BASE_PERIOD, LEVEL, MONTHNUM, PERIOD, YEAR has to be set like on the screen!

    YEAR - 4 digit fiscal year

    Add comment
    10|10000 characters needed characters exceeded