- Filters are not applied properly in charts based on linked models.
- Chart shows "Unable to retrieve data from datasource" error after applying an Input Control for one of the linked dimensions.
- SAP BusinessObjects Cloud 2017.
Reproducing the Issue
- Create Story with canvas page.
- Add two charts having models linked together.
- Add an input control based on the linked dimension.
- Apply a filter selection.
- The ID's of the linked dimensions are not matching, only the description of the values are the same.
- Linking was applied based on the ID's and not based on Description.
In the Link Dimensions window under the "Matched Dimensions" pane the Description has to be selected in order to make filtering work.
- The ID of a dimension must match the ID of the dimension it is linked to.
- Chart filters do not affect linked dimensions, because they are only applied to a single chart.
- Some dimension links may not result in filters being applied to all charts due to limitations in translating filters applied to one model to meaningful filters on a second model.
Refer to the online SAP BusinessObjects Cloud User's Guide
- Help portal
- SAP Community network ( Questions & Answers / Direct Link to Create Question / Blogs )
- SAP Community WIKI
- Ideaplace forum ( for enhancement requests & new features )
- Watch these videos to help start your journey with SAP BusinessObjects Cloud
- Training videos by topic areas: ( Overview, What's New, Models and Connections, Stories, SAP Digital Boardroom, Planning, Predictive, Collaboration, Administration )
- Training Events
- Past Event Recordings
- New user handbook
- How to connect to on-premise data
- Introducing SAP BusinessObjects Cloud: BI and Planning (SAP Press book)
Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, link, blend, modeler, filtering , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , How To