SAC member FORMULA

[rajarshi_muhuri]

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]

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.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/2784376d431e4a7da9564...

REgards

Nikhil