Symptom
In SAP Analytics Cloud, data action steps allow you to run a data action with parameter values that you specify. API steps integrate on-premise and cloud-based external applications using an HTTP Application Programming Interface (API).
If desired, you can add parameters for the value of a Level Based Hierarchy dimension, for example "SAC_Dimension".
Environment
- SAP Analytics Cloud
Resolution
If desired, add parameters in the Body of the API Step. When adding parameters, you can choose to add .baseMembers to include all child members of the chosen parameter. After .baseMembers, you can add .toString() to convert parameter values in array format to ones in string format.
Here are examples that provide details on the value of the Parameter (with/without formula):
1. Without baseMembers:
"testProperty":"${parameterName}"
The result in the body of the request is:
"testProperty":[["(all)","hierarchy1","member1"],["(all)","hierarchy1","member2"]]
2. With baseMembers:
"testProperty":"${parameterName.baseMembers}",
The result in the body of the request is:
"testProperty":["member1","member2"]
3. With baseMembers.toString() :
"testProperty":"${parameterName.baseMembers.toString()}"
The result in the body of the request is:
"testProperty":"member1,member2"
Please notice that with and without .baseMembers, the output data format will differ. Therefore, we suggest checking the remote API that is called in the API step to determine whether it can support the data format, then choose the formula that best suits your needs.
Keywords
KBA , LOD-ANA-PL-MA , Multi Actions , How To