Copy Cross Model with Adv. Formula to derive Cost Center

[thodoros_polychronopoulos]

Hello,

My two Models have some common dimensions but my Target Model has a Cost Center dimension that does not exist in my source Model. However, Cost Center exists as an attribute of dimension Plant of the Source Model. Dimension Plant is missing from the Target model. I am trying to derive Cost Center by using the LINK formula but it does not work.

My code for writing data is the following:

DATA([d/SALES_ACCOUNT] = "REVENUE DOMESTIC PR", [d/Measures] = "GC_AMOUNT", [d/COST_CENTER] = [SALESPLAN3].[d/PLANT].[p/COST_CENTER]) =
LINK([SALESPLAN3], [d/Measures]="GC_AMOUNT",[d/Version]="public.Actual")

Kind regards,

T.P.

[N1kh1l · Accepted solution]

thodoros_polychronopoulos

I assume you are writing the Advanced formula in target model to read data from source model (LINK will work this way for your requirement). I see you are not specifying the Account members you want to read from source model. Also add more MEMBERSET for other dimension to narrow the scope both in target model section and source model (MODEL ..... ENDMODEL)

MEMBERSET [d/Date] = "202101" TO "202112" // Adjust or remove accordingly
MEMBERSET [d/Measures]="GC_AMOUNT"
MEMBERSET [d/SALES_ACCOUNT] = "REVENUE DOMESTIC PR"

MODEL [SALESPLAN3]
	MEMBERSET [d/Account] = // Add what Accounts you reading from source
	MEMBERSET [d/Measures]="GC_AMOUNT"
ENDMODEL

DATA([d/COST_CENTER] = [SALESPLAN3].[d/PLANT].[p/COST_CENTER]) =
LINK([SALESPLAN3],[d/Version]="public.Actual")

Hope this helps!!

Please upvote/accept if this helps.

-Nikhil

[thodoros_polychronopoulos · Accepted solution]

Thanks for your help,

I did this but still does not work:

[N1kh1l · Accepted solution]

Try adding PLANT also to the scope as that will decide the costcentre.

MEMBERSET [d/PLANT].[p/COST_CENTER] != “”

Scope all plants where cost centre is not empty. You can also try by scoping one plant for trial.

Nikhil

[thodoros_polychronopoulos · Accepted solution]

Well your solution finally worked!

I had to adjust some Dimensions but it work

Kind regards,

T.P.

[N1kh1l]

thodoros_polychronopoulos

thodoros_polychronopoulosGlad it worked for you. What changes did you make for it to work? Please share it. so that it can benefit the larger audience.

-Nikhil

[thodoros_polychronopoulos]

In my case some members had different IDs that is why it didn't work properly.

Regards,

Thodoros