Skip to Content
0
Dec 13, 2018 at 11:08 AM

Look Up Function

119 Views

Hi Experts,

I am looking into BPC 11.0 N.W.

The Requirement is as followes

Planning model & Cost Model Have Same dimensions.

Cost model (Account=60000) = Planning Model (account=50000,scenario=ACTUAL,currency=USD,Functional_area=NO_FA)-cost model(account=61000),account=STAT_TOTGA)

*XDIM_MEMBERSET ACCOUNT = 61000

*LOOKUP PLANNING_MODEL

*DIM GA:ACCOUNT="60000"

*DIM SCENARIO = "ACTUAL"

*DIM CURRENCY = "USD"

*DIM FUNCTIONAL_AREA="NO_FA"

*ENDLOOKUP

*WHEN ACCOUNT

*IS 60000

*REC(EXPRESSION=LOOKUP(GA)-[ACCOUNT].[61000],ACCOUNT=60000)

*ENDWHEN

But run the above logic is not working.

Please kindly suggest me