advance Data action to link two dimensions

[zebashah]

Dear Community members ,

I have a requirement to link two dimensions in SAC for planning.

I am using  advance data actions for the same. below are my sample dimension & table :

I want to fill the column Cost description  ( D1 ) using a link to Org Dimension. Fetch the description( Org)  and copy it in cost description( D1) .

I wrote the following code and it didn't work :

MEMBERSET[d/D1] = [d/D1].[p/cost_decription]
FOREACH [d/ORG]
IF [d/D1].[p/cost] = [d/ORG].[p/ID]
THEN
DATA([d/D1] = [d/D1].[p/cost_decription]) = RESULTLOOKUP([d/ORG] = [d/ORG].[p/ID])
ENDIF
ENDFOR

Please help with some guidance .

@N1kh1   @Manivannan 

[akhilgs]

Hi @zebashah  please check through the below blogs, these should help to resolve your issues, you can achieve master data update via scripting.

SAP Analytics Cloud Application to add Master Data to a planning model 

Update master data of dimension using JavaScript in Analytical Application 

[zebashah]

Hi ,

[zebashah]

Hi , Thank you for your reply . I have another question .What if I do not want to update my master data and just do this link to represent in the data in story . D1 and Org has common link as c1,c2,c3 . I want to show D1 data and also show respective value of descriptions

[akhilgs]

Hi @zebashah , for this too I am not aware of any direct way within a story to achieve it, you need to use scripts to get properties of a dimension and then apply your condition to get the description to show them, we had a similar situation and was able to get part of the solution from the below blog

Retrieving Property Values from Dimensions using Tables in Analytic Applications