3 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 .
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 |
---|---|
80 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.