SAP Knowledge Base Article - Public

3690726 - Performance Issue when applying filters based on scripts

Symptom

You have a Story and it has a filter which is achieved by script :setDimensionFilters().

When applying filter , it takes long time.

Environment

SAP Analytics Cloud 1.0;

Reproducing the Issue

  1. Login to the tenant.
  2. Open the story.
  3. Select "Filter" button.
  4. Select a value for the filter and apply it.
  5. It takes long time to finish loading.

Cause

The Story need to be optimized for performance.

Resolution

To enhance performance for interactions, consider the following strategies:

  1. Use MemberInfo Instead of Strings: This can optimize operations by reducing string-related overhead.

  2. Optimize Filter Setting:

    • Replace setDimensionFilters() in most widgets with InputControl.getInputControlDataSource().setSelectedMembers(). This approach is efficient, especially when using linked dimensions for dimensions that share the same members.
    • This optimization is also verified to work with live models. To reset the filter, you can call InputControl.getInputControlDataSource().setSelectedMembers().

Keywords

KBA , LOD-ANA-UNS-SCR , Unified Story Scripting related Issues , Problem

Product

SAP Analytics Cloud 1.0