Symptom
The tooltip message ignores the cascading effect, and all members of the initial active members will be visible and listed for the dimension filter in SAP Analytics Cloud (SAC).
Environment
- SAP Analytics Cloud
- SAP BW/4HANA
Reproducing the Issue
- Login to SAC.
- Open the story.
- Create two dimension filters with active cascading effect:
- "DimFilter1" = member selection "All"
- "DimFilter2" = member selection "All"
- Check the active member list for "DimFilter1".
- Now for "DimFilter2" select only the member e.g. "123" and Apply selection.
- Check again the active member list for "DimFilter1" => there will be less active member for selection because of the active cascading effect.
- Deselect (exclude) one element e.g. "456" for dimension filter "DimFilter1" and Apply selection.
- Hover over the filter "DimFilter1" with the mouse, the tooltip message ignores the cascading effect, and all members of the initial active members will be visible and listed.
Cause
- By design.
- The filter subtitle (and the tooltip on hovering) is showing 'selected' values but not taking into account of cascading effect. Actually not only in the tooltip, even the subtitle itself, if the inactive member happens to be the first few values, still show up.
- The main reason for this behaviour is performance. For filters in token mode, we need to issue a separated query to fetch the members to show in the filter token subtitle. This is done once on story loading time. In order to exclude the inactive members, for example on filter selection change, we have to issue queries on all these filters and recalculate the inactive members based on the new selection. Since many stories have a lot of story filters, and page input controls in token mode, we simply cannot afford to issue so many queries to the backend.
- The subtitle did show the selected booked members only, but what it may miss are the 'inactive' members, caused by cascading effect from other filters. For example, a filter on City has selected members "Berlin" and "Chicago", both are booked. The filter subtitle should show both of them. Now, if there is another filter on Country with members "Germany" and "USA" and user deselects "USA", due to cascading effect, all data points on "Chicago" should be gone, but the filter City's subtitle still show both "Berlin" and "Chicago". Basically, SAC won't send a separated list of values (LOV) request with both filters in context to figure out "Chicago" should be removed. However, if user expand the filter City token, and 'show inactive values' flag is off, the dropdown should have the correct members "Berlin", but no "Chicago". So only the filter token's subtitle is not affected by the cascading effect.
Resolution
By design behavior.
See Also
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
- 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
- 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
- Search for SAP Analytics Cloud content using SAP for Me, Google or Bing:
- https://me.sap.com/servicessupport/search#?q=SAP%20Analytics%20Cloud%20OR%20SAC&tab=All
- https://www.google.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fuserapps.support.sap.com+SAP+Analytics+Cloud
- Note: Add relevant text or warning/error messages to the text search field to filter results.
- SAP Analytics Cloud Connection Guide
- Getting Started with SAP Analytics Cloud Expert Community page
- SAP Analytics Cloud Get More Help and SAP Support
- Need More Help? Contact Support or visit the solution finder today!
Your feedback is important to help us improve our knowledge base.
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, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software epm, business intelligence , KBA , LOD-ANA-DES-OFLTR , SAP Analytics Cloud Optimized view mode filtering , Problem