3602416 - Unexpected Behavior of Scripting Method in SAP Analytics Cloud

• The sort order of a BEx query in SAP Analytics Cloud (SAC) is not as expected.
• The BEx query designer shows the sorting of the dimension 0CALMONTH DESCENDING based on the dimension-key.
• However, when using a scripting method, the values are sorted ASCENDING by dimension-key.
• This is contrary to the expectation of the sorting to be DESCENDING as defined in the BEx query.

SAP Analytics Cloud

1. Use a BEx query in a SAC Story.
2. Try to get all the members of the dimension 0CALMONTH using the scripting method.
3. Set the sorting of the dimension 0CALMONTH DESCENDING based on the dimension-key in the BEx query.
4. Observe that the array returned by the method on the console is sorted ASCENDING by dimension-key.

The scripting method used does not respect the sorting setting of the BEx query when collecting data of dimension 0CALMONTH.

Backend needs a note:

3532142 - INA: Key figure variable & dynamic filter metadata not in sync
You are trying to execute a BW Query using application which is using BICS interface INA like SAC, DataAnalyzer etc. The Query contains a Variable on a Keyfigure structure. While making changes to this variable you will notice that filtering not always works as expected and sometimes filter is ignored and Structure member variable doesn't work as expected.

Refer to Knowledge Articles KB0970971 and KB0030782 for related information.

SAP Analytics Cloud, BEx query, sorting, dimension, scripting method, unexpected behavior. , KBA , LOD-ANA-AD , Analytics Designer , Problem