Symptom
- Within the SAP Analytics Cloud Excel Add-in, when going to the 'Manage Filter' option and selecting 'Description' for the display and attempting to search for matching entries no data is returned even though members exist with the search text contained in the Description.
- Example: If the dimension is a Date dimension and the description contains the Month (Jan, Feb etc.) then using Feb as the search text should return a list of members that contain Feb (Feb 2026, Feb 2025 etc.)
- If the display is changed to 'ID' for the dimension then the search will return any matching members that are entered into the search text.
- This behavior appears to occur for dimensions that contain a hierarchy.
Read more...
Environment
- SAP Analytics Cloud, add-in for Microsoft Office
Product
SAP Analytics Cloud, add-in for Microsoft Office all versions
Keywords
SAC Excel add-in, description search, hierarchy selection, member selector, filter by member, inconsistent results, Profit Center, Entity, search by description not working, Datasphere analytic model, show unbooked members, SAC add-in search, hierarchy popup, intermittent search results , 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.
SAP Knowledge Base Article - Preview