Hi Friends,
I need to develop a custom measure called "Activity".
Data available at periods level.

Lines 5& 6 are LEQ Acc type with Period & Activity measures.
Similarly lines 9 & 10 are AST Acc type with Period & Activity measures
Need to derive "Activity" measure values for month, quarter & year level. Here values are generated correctly for months & year level. Need help in Quarter level figs derivation. All time periods (i.e.Quarters, months have properties PRIOR) in PERIOD dimension. Here PERIOD is TIME dimension.
2018.Q1 prior value is 2018.Q4
2018.Q2 prior value is 2018.Q1
2018.Q3 prior value is 2018.Q2
2018.Q4 prior value is 2018.Q3
2018.Q1 = 2018.Q1 (Periodic measure) - 2018.Q4 (Periodic measure)
2018 Q2 = 2018.Q2 (Periodic measure) - 2018.Q1 (Periodic measure)
2018 Q3 = 2018.Q3 (Periodic measure) - 2018.Q2 (Periodic measure)
2018 Q4 =2018.Q4 (Periodic measure) - 2018.Q3 (Periodic measure)
For months derivation: Current month (periodic measure value) - previous month(periodic measure value)
I am getting error while reading Quarter values and pls suggest on this.
Ours is BPC 10.1 NW,
BW7.4 on HANA SP13.
I read in blogs STRTOVALUE supported from SP12 onwards.
E.g. Acct type: LEQ OR AST 'IIF([%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="AST" OR [%ACCOUNT%].CURRENTMEMBER.PROPERTIES("2/CPMB/ACCTYPE")="LEQ",
IIF([%PERIOD%].CURRENTMEMBER.PROPERTIES("2/CPMB/TILEVEL")="QUARTER", (STRTOMEMBER("[%PERIOD%].[" + [%PERIOD%].CURRENTMEMBER.PROPERTIES("CURRENT") + "]"), [MEASURES].[/CPMB/SDATA] )- ((STRTOMEMBER("[%PERIOD%].[" + [%PERIOD%].CURRENTMEMBER.PROPERTIES("PRIOR") + "]"), [MEASURES].[/CPMB/SDATA]),
-([MEASURES].[/CPMB/SDATA] - ([MEASURES].[/CPMB/SDATA], [%PERIOD%].PrevMember))), -[MEASURES].[/CPMB/SDATA])';SOLVE_ORDER=3
Here require support at bold letters place.
Regards,
Anjan