Advanced Formlua LINK | New Model

[former_member812625]

Hey everybody,

I try to understand the "advanced formula" by self teaching however it's harder than I thought.

My challenge: I have 2 models (new) which needs to be linked as one model needs the information from another one.

So I tried to show the situation in the screenshot. Could you give me a hint / starting point how I'm writing this script?

That would be very amazing!

Thanks in advance

[N1kh1l]

triplicatef

You can try the below approach.

You would need to write the Advanced formula in Model 1.

First scope the intersection where you want to write back the Freight data coming from Model2. I see you have mentioned >200 dimension (not sure if you actually have 200 dimensions).

The actual code will depend on what actual dimensions you have in the model.

MEMBERSET [d/Date] = "202301" TO "202312"
MEMBERSET[d/dim]="AAA" // Add scope where you intend to write the data in model1.

MODEL [MODEL2]
	MEMBERSET [d/Invoice] = BASEMEMBER([d/Invoice].[h/parentId], "All invoices") // If invoice has a hierrachy else scope all.
	MEMBERSET[d/Dimension2]= "ABC" // Scope the dimensions where Freight data is stored
ENDMODEL

DATA([d/Measures] = "Freight") =LINK([MODEL2], [d/Measures] = "Freight", [d/Version] = "public.Plan01")

Hope this helps !!

Nikhil