Skip to Content
0

UJA_FORMULA_APP change initial month after restart the server

Oct 31, 2016 at 03:48 PM

93

avatar image

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

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

3 Answers

Vadim Kalinin Oct 31, 2016 at 04:04 PM
0

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

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

ok I will provide to you

ujc2f.png (34.5 kB)
0

when there are transport or restart of server BW could change in the formula stat the initial month from May to Jan

plzyn.png (6.5 kB)
hyaes.png (22.1 kB)
0
Vadim Kalinin Nov 01, 2016 at 09:20 AM
0

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!

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

P.S. If you need to have calendar month name - just create a new property like CALMONTH and fill it with calendar month name. PERIOD is a special property and has to be assigned like I explained in my answer.

1

we have these settings and it works, it might stop to work properly when we do transport or restart the server

birih.png (60.4 kB)
0

Sorry, but it's incorrect! First period of the year is required to have PERIOD property JAN. It's fixed in default MEASURE formula and in many other places (calculations).

1

our year start the 1st of May

0

Have to repeat third time - it doesn't matter what is the calendar month that starts fiscal year! The PERIOD property HAS to be JAN! Second month - FEB, etc...

It's hardcoded in BPC!

If you need to have information about real calendar month - create new property!

1

thanks Vadim for your patience

I haven't done it, it is something done by the consultant company and because I joined recently I was wondering if there is a way to avoid that sometime doing the transport BPC doesn't calculate anymore the ytd from may but from jan so the consultant company left a guide to go in the table in BW and changing the formula

0
Show more comments
Vadim Kalinin Nov 08, 2016 at 11:07 AM
0

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


ias6y.png (77.8 kB)
Show 4 Share
10 |10000 characters needed characters left characters exceeded

P.S. "I have already answered this question many times, please search!"

1

just a comment, because these settings were done some years ago, now that the data has been already loaded I think that it is too late. what do you think?

0

It's not late! Changing properties will not affect data.

1

thanks a lot

0