Skip to Content
avatar image
Former Member

Unable to create Custom Measure in BPC 10.0 system

Hi Exerts,

Am trying to create Custom Measure in BPC system. Facing the following issue. “Value WTD for characteristic Measures unknown” .This is the logic i used and please find the attached error screenshot for your reference.




MEMBER [MEASURES].[JAN] AS '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%].[LEVEL02])),IIF([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ",-([MEASURES].[/CPMB/SDATA], CLOSINGPERIOD([%TIME%].[LEVEL02])),-[MEASURES].[/CPMB/SDATA]))))';SOLVE_ORDER=3



Kindly help me on this.



Regards,

Harini.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 15, 2015 at 05:26 AM

    Can you provide a screenshot of UJA_MAINTAIN_MEASURE_FORMULA? What do you try to achieve with this measure?

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 15, 2015 at 02:25 PM

    Hello,

    What is in your time dimension?  Do you have anything like Week in your time dimension, what is the LEVEL02 in your time dimension?

    The measure formula depends on the Time dimension as you see in statement ... ([%TIME%].[LEVEL02] .... I recommend verifying what is LEVEL02 in your time dimension.

    Regards,

    Leila

    Add comment
    10|10000 characters needed characters exceeded