cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

SAC Planning : Cross model copy with hierarchies

kiran_s611
Explorer
0 Kudos
115

Hi All,
I am trying to copy data from Model A to Model B using advanced formula steps.
These 2 models are having different hierarchies at different levels.
Model A hierachy

kiran_s611_0-1762306857246.png

Model B hierarchy

kiran_s611_1-1762306876180.png

I am writing data copy step like below

MODEL [Model A]
ENDMODEL
DATA([d/Measures]="Sales_Qty",[d/Product]=[Model A].[d/Product]) = 
LINK([Model A] ,[d/Measures]="SalesQty",[d/Version]="public.Actual" )
If i want to include the hierarchy either from Model A or Model B , how to do it ?
If we have 2 models with different level hierachies how data will get copy from one to another.

Cany anyone of you please clarify this.
Thanks in advance 

Accepted Solutions (0)

Answers (1)

Answers (1)

N1kh1l
Active Contributor
0 Kudos

@kiran_s611 

Better approach is to always have a common hierarchy setup within the dimension across model. So setup an identical hierarchy setup in both models and use that in the mapping rule of the cross model data copy to get consistent results.

 

Hope this helps !

Nikhil