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

[former_member812625]

First of all thank you.

could you please tell me where do you exaclty find this „advanced formula“ in the new model? Is it in data actions or do I missunderstood something. It‘s not a calculated measure right?

[nasser_itani]

Yes the link function is in data action. But before that please explain for me what are you trying to achieve.

Are you doing the link just for visualizing or its for planning purpose.

[nasser_itani]

Have a look at the below https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/afe93e3cf1414a7b8419b...

Please upvote/accepts if it helps.

Thank you.

[nasser_itani]

Hello triplicatef have a look on the link() function in advanced formulas. Please make sure in the link() function to include all the dimension in the model.

Also if you need only at the story level you can make use of the Linkage two models.

Hope it helps.