3757113 - Setdimensionfilter does not filter secondary structure members (CustomDimension2) in SAP Analytics Cloud (SAC)

• In an optimized story, filtering structure members (second structure) via the builder panel or table context menu works as expected.
• Calling the scripting API Table_1.getDataSource().setDimensionFilter("CustomDimension2", "xxx") has no effect on the table.
• No error message is shown in edit mode or view mode.

SAP Analytics Cloud

1. Create a story based on a Datasphere analytic model that contains structure members (a second structure next to measures).
2. Insert a table based on the model, add a measure, and add the structure to the table. Confirm that filtering the structure via the builder panel or table context menu works.
3. Add a button and script it to run Table_1.getDataSource().setDimensionFilter("CustomDimension2", "xxx").
4. Switch to view mode, click the button, and observe that no filtering occurs and no error is shown.

Working as designed: the scripting API setDimensionFilter does not support filtering the secondary structure dimension (“CustomDimension2”).

If you believe this new feature would be beneficial, please create an enhancement request as per KBA 2424376 and follow up with the product owner team about this enhancement request on the SAP Customer Influence Site https://influence.sap.com/sap/ino/#/campaign/884 . 

DataSource.setDimensionFilter API documentation

setDimensionFilter, CustomDimension2, secondary structure, structure members, scripting API, table filter, optimized story, analytic model, Datasphere live, no error, no effect, filter via UI, show/hide tables, SAC scripting, table scripting limitations , KBA , LOD-ANA-UNS-SCR , Unified Story Scripting related Issues , Product Enhancement