Skip to Content
0
5 days ago

Copy Cross Model with Adv. Formula to derive Cost Center

102 Views

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.