2 weeks ago
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 .
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
83 | |
11 | |
10 | |
8 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.