SAP Knowledge Base Article - Public

3051232 - Remove Dimension Filter API does not work with Group Filter Modes in SAP Analytics Cloud (SAC) & SAP Digital Boardroom

Symptom

When attempting to remove dimension filters via a custom script, it does not remove the filters when the filter line widget has been set to group filter mode.

Environment

  • SAP Analytics Cloud Version 2021.9.0
  • Analytics Designer/Analytic Application

Reproducing the Issue

  1. Create an Analytic Application from the main menu.
  2. Insert a widget visualization *2 (chart or table)
  3. Insert a filter line widget and click on the designer builder panel for more options.
  4. Select the group filter option from the drop down mode.
  5. Select a data-source from the drop-down options.
  6. Add a dimension selection.
  7. Click on the add filters button and select an option.
  8. Click on All widgets of this data-source radio button from the option apply filters to.
  9. Insert a button and click on the fx icon to edit scripts.
  10. Reference both widget visualizations (charts or tables or both) and apply the following script in two lines:
    <table_1/chart_1>.getDataSource().removeDimensionFilter("<Dimension>")
    <table_2/chart_2>.getDataSource().removeDimensionFilter("<Dimension>")
  11. Run the application and observe that the script events do not remove the filters.

Cause

The remove dimension filter API only works when the mode of the filter widget is set to individual filter line and not group filter.

Resolution

This feature is currently not available but is proposed to be released in a future wave.
Please see the below enhancement request
https://influence.sap.com/sap/ino/#/idea/261353

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, analytic application, analytics designer, widget filter, removeDimensionFilter

  • SAP Analytics Cloud Version 2021.9.0
  • Analytics Designer/Analytic Application
, KBA , LOD-ANA-AD , Analytics Designer , LOD-ANA-AD-COR , SAC Application Designer , Product Enhancement

Product

SAP Analytics Cloud 1.0