BPC 10 Measure Formulas - blank values EPM reports

[Former Member]

Hello,

I am using a PERIODIC storage model, and only my PERIODIC/QTD/YTD measures are working. I even tried making a copy of PERIODIC and called it MTD, but still the values within the report are blank for MTD. Am I missing a step in the configuration beyond maintaining the formula in UJA_MAINTAIN_MEASURE_FORMULA?

Below is the copy of the formula which is working (PERIODIC),

'IIF([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="INC",-[MEASURES].[/CPMB/SDATA],IIF([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="EXP",[MEASURES].[/CPMB/SDATA],IIF([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="AST",([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])),IIF([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ",-([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[%TIMEBASELEVEL%])),-[MEASURES].[/CPMB/SDATA]))))';SOLVE_ORDER=3

However, when copying this formula and renaming it as MTD the formula returns no values in EPM.

Please advise.

[former_member186338]

BPC and BW version, SP?

[Former Member · Accepted solution]

Hi Vadim,

UJA_REFRESH_DIM_CACHE resolved the issue.

[former_member186338]

"In UJA_FORMULA_APP noticed there were a few entries with Storage Type = YTD. Planning model is Storage Type = PER so I removed these entries."

May be it's a result of using code in ZBPC_ACTIVATE_FORMULAPP?

[Former Member]

The issue resolved itself. I'm not sure what I did to fix it but here are some steps I followed

1. In UJA_FORMULA_APP noticed there were a few entries with Storage Type = YTD. Planning model is Storage Type = PER so I removed these entries.
2. Attempted adding a custom measure in se38 / UJA_MAINTAIN_MEASURE_FORMULA called MTD and copied over the Periodic formula
3. Ran the program in se38 / ZBPC_ACTIVATE_FORMULAPP. This is a custom program designed to activate custom measures after transporting that I found about reading this blog
4. Deleted the MTD formula in se 38/ UJA_MAINTAIN_MEASURE_FORMULA.

[Former Member]

Is there any other way within BW to debug the formula (i.e. MDXTEST)?

[former_member186338]

You have very old SP's! Please upgrade to recent ones.

[Former Member]

Hi Vadim, please see below our SP levels.

SAP_BW 740 SP 10

CPMBPC 801 SP 10

HANABPC 801 SP08