SAP Knowledge Base Article - Public

3540327 - Error : 'Rank could not be completed because the specified account/measure or version member is no longer available. Please update your rank selection' when ranking chart in SAP Analytics Cloud (SAC)

Symptom

  • Error : 'Rank could not be completed because the specified account/measure or version member is no longer available. Please update your rank selection' when ranking chart in SAP Analytics Cloud (SAC)
  • When using a planning model, Top 5 rank is not working because Dimension member specified in Measure Coordinate can't be found in Dimension 'Version'.
  1.  

Environment

SAP ANALYTICS CLOUD 2024.15.16

Reproducing the Issue

  1. Login to the SAC
  2. Open the story 
  3. Apply the Top 5 rank filter on the chart 
  4. In the version filter, uncheck the first filter.

    Notice the error: "Rank could not be completed because the specified account/measure or version member is no longer available. Please update your rank selection." 

Cause

  • Behavior by design.
  • When you use the Top 5 option, it will select the default version. This is typically the one with the lowest Version ID in the list of all 'active' versions in the Chart.
  • In the Top 5 version, we use the 'first' version. 

Resolution

If you wish to select a different version, it can only be set explicitly. This can be done by creating the rank via the Top N Options menu.

See Also

Keywords

SAP Analytics Cloud, Rank, TOP N, TOP 5 , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0