Skip to Content
0
Nov 24, 2022 at 02:17 PM

Copy Cross Model with Adv. Formula to derive Cost Center

393 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.