Modify Standard Delivered Measures in BPC 10.1 standard

[former_member254616]

Dear All,

I have a requirement to change the standard measures "Periodic", "QTD" and YTD" as FTE's (Full Time employees) are not shown correctly.

FYI - In current project, FTE Accounts are defined in User defined dimension and not in standard Account dimension

For e.g.

In Jan - FTE's are 2

In Feb - FTE's are 2

In Mar - FTE's are 2

All Measures "Periodic", "QTD" and YTD" are showing as "6" instead of "2".

Please find screenshot attached for your reference.

The formula for "Periodic" measure in our system is as below

MEMBER [MEASURES].[PERIODIC] AS 'IIF([%ACCOUNTDIM%].CURRENTMEMBER.PROPERTIES("ACCTYPE")="INC",-[MEASURES].[SIGNEDDATA],IIF([%ACCOUNTDIM%].CURRENTMEMBER.PROPERTIES("ACCTYPE")="EXP",[MEASURES].[SIGNEDDATA],IIF([%ACCOUNTDIM%].CURRENTMEMBER.PROPERTIES("ACCTYPE")="AST",([MEASURES].[SIGNEDDATA], CLOSINGPERIOD([%TIMEDIM%].[%TIMEBASELEVEL%])),IIF([%ACCOUNTDIM%].CURRENTMEMBER.PROPERTIES("ACCTYPE")="LEQ",-([MEASURES].[SIGNEDDATA], CLOSINGPERIOD([%TIMEDIM%].[%TIMEBASELEVEL%])),-[MEASURES].[SIGNEDDATA]))))';SOLVE_ORDER=3

Can you please help me to achieve the result I am expecting?

Incase of any questions, please let me know.

Thanks and Regards,

VRR

[former_member254616]

Hi Vadim,

Thanks for your reply.

Currently 21600000_00040 is EXP. You can change it to AST.

Answer - This is only one example and the users use 21600000_00040 Account to post not only on FTE's but Non FTE's as well. It will affect other NON FTE Accounts. As per Business, it should be "EXP" ACTTYPE only. Also, 21600000_00040 is one example. They use many such accounts.

Would be great if you can let me know how to tweak the Measure. I can let my users know about the performance.

Thanks and Regards,

VRR

[former_member186338]

Sorry, but tweaking the measure is the wrong way, it will end up with unmanageable system. It's not a joke! I do not want to support incorrect design. Create a new AST account and use it for FTE posting only!