SAP Knowledge Base Article - Preview

3076914 - Error executing query when connecting to HANA Calculation View in Crystal Reports for Enterprise


  • Error executing query.
  • SQL Error: insufficient privilege, when trying to connect to a Calculation View.
  • When connecting to a HANA Calculation View in Crystal Reports for Enterprise, it fails with the error:

    "Error executing query.
   sql processing error: Error occurred while executing a MDX statement.
     The error message is: An internal error occurred. Assertion failed with error message Hierarchy cache reference is invalid for...
     Hierarchy cache error:Hierarchy create error for ... error: SQL: insufficient privilege: Details info for this error can be found with guid..."  




  • SAP Crystal Reports for Enterprise 4.2
  • SAP HANA 2.0


SAP BusinessObjects Business Intelligence platform 4.2


CRFE, CR4Ent, CR4E, CR for Enterprise , KBA , BI-RA-CRE , Crystal Reports for Enterprise , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.