SAP Knowledge Base Article - Public

2541080 - Predicates are required in a where clause in SAP Analytics Cloud (BOC)

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

  1. 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"
  2. Connect to SAP Analytics Cloud
  3. Create a Live Data Connection to the SAP HANA System
  4. Create a Model from the SAP HANA Calculation View
  5. Create a Story 
  6. Insert a Chart that uses the Model
  7. Add a Measure to the Chart
  8. 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

  1. Connect to SAP HANA in SAP HANA Studio
  2. Open the SAP HANA Calculation View
  3. Click the "View Properties" tab
  4. In the "Advanced" section change "Execute In" to "SQL Engine"
  5. Click "Save and Activate" icon

See Also

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 , 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) , Problem

Product

SAP Analytics Cloud 1.0