2591713 - The filtering icon does not appear when the dimension has more than 1000 members in SAP Analytics Cloud (SAC)

SAP Knowledge Base Article - Public

2591713 - The filtering icon does not appear when the dimension has more than 1000 members in SAP Analytics Cloud (SAC)

Symptom

The filtering icon does not appear when the dimension has more than 1000 members in SAP Analytics Cloud (SAC).

Environment

  • SAP Analytics Cloud 2018.02

Cause

Pagination is active in the dimension modeler.

Resolution

  • The modeling grid is implemented with a concept of pagination. When the number of dimensions in the grid exceeds 1000 rows, you have to navigate to the end (1000th row) and it will then load the next thousand rows.
  • The implementation of the filter works when all data in the grid is already loaded (visible in the modeler grid).
  • You can achieve filtering on larger dimensions by navigating to the bottom of the grid (using the CTRL + down arrow keyboard combination) and loading all the data into the modeling grid.
  • This will enable the filter icon to appear and allow you to use the data filter feature in the modeler.
    18-Jan-18 2-23-22 PM.png

See Also

 

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0