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 

[N1kh1l · Accepted solution]

@zebashah 

You cannot use Data Action to manipulate master data in SAC. Data Action can only help you with fact data manipulation/calculations. 

For Master data you have to do it either do it during Master Data load in Data wrangling step or use some scripting Application to manipulate the properties.

for API's the link shared by Akhil will be helpful.

Nikhil