Symptom
- There are different behaviors with "Cascading Effect" involving two "Page Filter input control" between "Analytic Application" consuming Live BW and a "Story2" made/converted based on it.
- Each contains two page filters and a table that are all consuming same dimension ex:"Customer".
- In Analytic Application (Designer), when setting member(s) on the right page filter, it applies successfully to the left page filter and the table.
- In Story 2.0, when setting member(s) on the right page filter, it applies to the table but it does not apply to the left page filter that remains blank/empty.
Environment
- SAP Analytics Cloud (Enterprise) 2023.21.8
Cause
Missing members are unbooked members. Cascading on unbooked members is not supported.
Refer to https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/71e6b3a0f8fb465caa156e6417b68b79.html
Resolution
As mentioned like Restrictions, when an input control with the "Show unbooked members" option turned ON has filters cascading their changes into it, the unbooked members won't be included in the input control's list of members.
This is by design behavior in Story 2.0 that is input control won't show unbooked members that are cascaded in from other input controls.
These cascaded unbooked members won't be displayed in the list of members in the new story design mode.
A feature enhancement request can be created by following this KBA https://launchpad.support.sap.com/#/notes/2424376
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!
Keywords
Cascading effect, unbooked members, input control, Story 2.0, Analytics Designer, , KBA , LOD-ANA-DES-OFLTR , SAP Analytics Cloud Optimized view mode filtering , LOD-ANA-AD , Analytics Designer , Problem