Symptom
Predicates are required in a where clause in SAP Analytics Cloud (formerly known as SAP BusinessObjects Cloud / BOC)
Environment
- SAP Analytics Cloud
- SAP HANA
Reproducing the Issue
- Create an SAP HANA Calculation View that uses a Filter Expression in a Projection to add required predicates to the where clause for a table like "SYS"."EFFECTIVE_PRIVILEGES"
- Connect to SAP Analytics Cloud
- Create a Live Data Connection to the SAP HANA System
- Create a Model from the SAP HANA Calculation View
- Create a Story
- Insert a Chart that uses the Model
- Add a Measure to the Chart
- Notice the error
Cause
SAP HANA SQL Engine is required to process an SAP HANA Calculation View that uses a Filter Expression in a Projection to add required predicates to the where clause for a table like "SYS"."EFFECTIVE_PRIVILEGES"
Resolution
- Connect to SAP HANA in SAP HANA Studio
- Open the SAP HANA Calculation View
- Click the "View Properties" tab
- In the "Advanced" section change "Execute In" to "SQL Engine"
- Click "Save and Activate" icon
See Also
- Help resources and free SAP Analytics Cloud content
- Help portal
- SAP Community ( Questions & Answers / Direct Link to ask question / Blogs )
- SAP community wiki
- Enhancement requests using SAP Customer Influence (formerly known as Ideaplace)
- Video tutorials
- Videos by topic areas: ( Overview, Models and Connections, Stories, SAP Digital Boardroom, Planning, Collaboration, Administration )
- Training events
- Past event recordings
- New user handbook
- Roadmap
- How to connect to on-premise data
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud
- 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.
Thank you.
Keywords
EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, SAC, SAP BusinessObjects Cloud, Business Objects, SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, Predicates, Calculation, View, Filter, Variable, Parameter, Prompt, Where, SQL, Engine , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem