SAP Analytics Cloud for planning - Advanced Formula "LINK" is not working

[guenay]

Hi everyone,

I duplicated a planning model and now want to transfer the values from the productive model to the backup model using a Data Action with the LINK function. However, it's not copying any values. What could I be overlooking?

DATA() = LINK([PlanModel] , [d/Version]="public.Forecast", [d/Measures]="Amount")

 Kind regards,

Ismail 

[William_Yu1]

I would suggest you to use trace feature within DA designer to see if there is any data read

[guenay]

@William_Yu1 and @N1kh1l 

I did some further investigation and discovered that the Data Action works only when there are 6 or fewer dimensions in the model. It doesn't seem to matter which specific dimensions are included, as long as the total number doesn't exceed six. I'm also working with other tenants, and this limitation seems quite odd. I've used this formula in models with around 15 dimensions without any issues.

Do you have any thoughts on this?

[MoonJun]

Hi @guenay

Actually, there is no limitation on the number of Dimensions for the Linked(Source) Model in the LINK() function. 

Please check first whether the Dimensions of the Default & Linked model are Public or Local. If there are local dimensions in the Linked model, they should be mapped in Link() statements.

Second, the fact data of the Linked model should be in Hierarchy member of Dimensions. If there are "Not in hierarchy members" in the Source data & dimension member, it is excluded from the calculation scope. So, any data is not copied to the Default model. Please check it and if there are fact data on the Not in hierarchy member, add the configuration "HIERARCHY.INCLUDE_MEMBERS_NOT_IN_HIERARCHY" in your data action script. 

• MODEL [PlanModel]
      HIERARCHY.INCLUDE_MEMBERS_NOT_IN_HIERARCHY = [d/Dimension_1], [d/Dimension_2]
      MEMBERSET [d/Dimension_x] = ....
  ENDMODEL

Moonjun

[N1kh1l]

@guenay

As you said that the model is a copy from existing model, I would suggest that you use cross model daat copy, its very efficient in terms of performance compared to LINK formula.

Nikhil