SAC Planning Derive Property from different Planning model

[christian_willi]

Hi

I have an SAC Planning Model which contains the following planned data:

The Product also has a property

Now I want to copy the Data to a different Planning Model an write the Property, Product Group into an own dimension that it looks like this:

My current approach would be to copy via a Data Action with the Cross-Model Copy and in a next step derive this information with an advanced formula. So far I had no success with the advanced formula.

Any input is appreciated!

Thanks

Christian!

[N1kh1l · Accepted solution]

christian.willi

christian.williYou can follow 2 approaches as below.

Approach 1: 2 step process. First use cross model copy step and copy all data from [Model1] to [Model2]. For Product Group in [Model2] use #, so all data will be copied at Product group # in [Model2]

Now use a Advanced Formula to assign the right product group in step 2 and delete the data at #

MEMBERSET [d/PRODUCT_GROUP] = "#"
DATA([d/PRODUCT_GROUP]=[d/PRODUCT].[p/PRODUCTGROUP])=RESULTLOOKUP()
DELETE()

You can combine both this step into a Multi action for ease of use.

Approach 2: Use of LINK formula in Advanced Formula Data Action in [Model2] to create the data. Please adjust the dimensions and measures accordingly as per your model.

MEMBERSET [d/Date] = "202101" TO "202112" // Adjust accordingly

MODEL [MODEL1]   // Source Model
	MEMBERSET [d/PRODUCT] = BASEMEMBER([PRODUCT].[h/parentId], "Total_Product")
ENDMODEL

DATA([d/Measures] = "Amount",[d/PRODUCT_GROUP] = [MODEL1].[PRODUCT].[p/PRODUCTGROUP]) =
LINK([MODEL1], [d/Measures] = "Amount", [d/Version] = "public.Plan")

Hope this helps.

Please upvote/accept if this helps you.

Nikhil

[christian_willi · Accepted solution]

nikhil_1486

Thank you for the help!

The first solution works fine for me!

Can you please ellaborate on this real quick? As i also do no have the dimension [Product].[h/parentID]?

MODEL [MODEL1]   // Source Model
	MEMBERSET [d/PRODUCT] = BASEMEMBER([PRODUCT].[h/parentId], "Total_Product")
ENDMODEL

[N1kh1l · Accepted solution]

christian.willi

This was just a sample to choose all products from hierarchy top node. As I do not know your model structure I just put up an example. You can remove that whole line

MODEL [MODEL1]   // Source Model
	
ENDMODEL