2024 Nov 04 9:14 PM - edited 2024 Nov 05 8:33 AM
Hello
In SAP Analytics Cloud, I have a 2 steps process:
PlanningModel.createMembers("DimensionName",MemberArray );]
2. Call Data Action (through script) with the new members as parameter
DataAction1.setParameterValue("DimensionName", MemberArray);
DataAction1.execute();
My requirement is to execute both steps sequentially but there is an inconsistency with the create Members step. Even though the members are created (verified though debugging and also refreshing the dim table), there is a delay (sometimes consequential) between the time of member creation and availability in both stories and Data Action. Therefore, the Data Action fails because newly created members are tagged as invalid even though they are already in the dimension table. The volume of the data is not a factor here as there is no clear pattern on when there is a delay or not.
Eventually ,the story and DA will detected the new members and execute properly but the delay does not make this a viable option since the process needs immediate execution.
Is there another kind of refresh and configuration that can help with this? 😞
Request clarification before answering.
Hello - I have used the create member followed by a data action several times and have not encountered a delay. The data action is able to pick up the new member straight away within the same script without delay timers etc.
When the data action fails I've found instead it's caused by the syntax of the dimension member you are passing across. For example passing a member without a hierarchy you can just pass the ID, but if passing a member to the data action from script that is in a hierarchy, then you have to add the full technical hierarchy information around the ID like below:
var id = InputField_ID.getValue();
var id2 = "[DIMENSION].[H1].&["+id+"]"; // restate ID so that the Data Action can recognise this
..then id2 is passed to the DA
DataAction_1.setParameterValue("DIMENSION",id2);
Just want to check this is not the issue first as I've not experienced any delays before upon master data creation.
David
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
30 | |
10 | |
8 | |
8 | |
7 | |
7 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.