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

• 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

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

1. From SAC Add-in, click on “Add Table” and select the standard model “ACTIVITY_LOG” 
2. From Builder Panel, click on “Add Filter”, and search for “Resource ID” dimension (with hierarchies)
3. Select “PUBLIC” member and click on “OK” 
4. The filter can be visible correctly and applied successfully in table
5. Now try to edit the filter, by selecting “Manage Filters” icon from Builder Panel
6. “No members available” message is displayed in the “Set filter” window for “Resource ID” dimension
   

• The fix will be delivered in the next Ocean version : Wave 11
  According to the SAP Note : 2937385 - Release Plan for SAP Analytics Cloud, add-in for Microsoft Excel - SAP for Me, it is scheduled for week 20.
• Workaround : When opening the Filter Dialog, you can click on the Filter icon to disable the applied filter on the available members. Thus, you can see you members again.

• KBA 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• KBA 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
• KBA 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• SAP Analytics Cloud Connection Guide
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support 

Your feedback is important to help us improve our knowledge base.

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