SAP Knowledge Base Article - Preview

2830016 - How to sort dimension values in SAP Analytics Cloud (SAC) filter dynamically in order of measure from HANA

Symptom

  • The dimension values will be shown in order of alphabet in filter by default
    => How to sort dimension values in filter dynamically in order of measure?
  • Filtering data by rank can focus a chart on a specified number of data points with the highest or lowest values
    => How to filter data by rank on page level or story level to show data of Top N dimension values only?


Read more...

Environment

  • SAP Analytics Cloud
  • Live Data connection to SAP HANA

Product

SAP Analytics Cloud 1.0

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, Live ,HANA, filter, order, sort, values, list, dynamically, measure, dimension, top, rank , KBA , sac kba hana live query , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.