SAP Knowledge Base Article - Preview

3747291 - SAC Add-in : "No members available” displayed for dimension with hierarchy based filters using SAC usage models

Symptom

  • When using the SAC standard model “ACTIVITY_LOG” in the Excel SAC Add-in, and adding a filter on dimension “Resource ID” with hierarchies, the filter cannot be edited anymore since “No members available” is displayed.


  • Only if we delete the filter and set it back again, we see the members. This only happens with dimensions containing hierarchies
  • It does not happen with custom analytical or planning enabled models, so the issue is specific to the SAC standard models, like "ACTIVITY_LOG" model


Read more...

Environment

  • SAP Analytics Cloud SAC Excel Add-in - Application Version 2026.7.160

Product

SAP Analytics Cloud all versions

Keywords

KBA , LOD-ANA-OF-XLA , SAP Analytics Cloud, add-in for Microsoft Office , Problem

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.