SAC member FORMULA

rajarshi_muhuri · ‎06-24-2022

In classic BPC we have member formula say for an account dimension ( example P_ACCOUNT )

and it has a member ( or masterdata ) = 1001. and COST_CENTER is another dimension with member CC100

and I have the formula [P_ACCOUNT].[1001] - ( [P_ACCOUNT , [COST_CENTER].[CC100])

how do we do this is SAC , I cant seem to cross P_ACCOUNT boundaries in SAC formula

N1kh1l · ‎06-24-2022

Rajarshi,

You can achieve the same by using RESTRICT/LOOKUP/RESULTLOOKUP to get the second part

[1001]-RESTRICT([1001],[d/COST_CENTER]=("CC100")

[1001]-LOOKUP([1001], [d/COST_CENTER] = “CC100”)

Refer below for more help as per your requirement.

REgards

Nikhil

Re: Revaluation of Batch Item Variance Recognition