on 10-16-2015 3:01 AM
Hi,
We are running BPC 10.0 Netweaver with a periodic model setup. I have a member formula setup for the OPENING_ASSETS account member formula that returns either the result of the previous input schedule ending assets or the result of the previous ending assets result.
The formula works find but for some reason periods 2015.04, 2015.07, and 2015.10 all show up blank under opening assets. I don't understand why these would be blank when the previous member is populated. I even tried populating both the ending_assets_inp and ending_assets in case it was pulling the value from the wrong one.
If someone can explain why this is happening that would be great.
IIF([TIME].CURRENTMEMBER.PROPERTIES("TIMEID")<[CATEGORY].CURRENTMEMBER.PROPERTIES("OPENING_PERIOD"),
([ENDING_ASSETS_INP], [TIME].PREVMEMBER),
([ENDING_ASSETS], [TIME].PREVMEMBER))
Not enough info...
Please test simplified:
IIF([TIME].CURRENTMEMBER.PROPERTIES("TIMEID")<"2015.04",
([ENDING_ASSETS_INP], [TIME].PREVMEMBER),
([ENDING_ASSETS], [TIME].PREVMEMBER))
Please explain other members you have on the report...
Vadim
P.S. Incorrect results on 2015.04, 2015.07, and 2015.10 may be due to the OLD SP for BPC and BW, please upgrade to the latest
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vadim,
I tested the formula you provided and I get the same result. I also get the same result just doing the below formula.
([ENDING_ASSETS_INP], [TIME].PREVMEMBER)
The other members I have are accounts on the left hand side where I'm selecting the member and all descendants of the ENDING_ASSETS account. On the top of the report I have time where I'm selecting all the children of 2015.Q1 - 2015.Q4.
I additionally did an MDX trace of the query and received the following result. Not sure if this will help.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.