SAP Knowledge Base Article - Public

1776593 - Error: '[SAP AG][LIBODBCHDB32 DLL][HDB] General error;7 feature not supported: not allowed over OLAP VIEW...' when reporting off SAP HANA Analytic View in Crystal Reports

Symptom

  • When reporting from an SAP HANA Analytic View in Crystal Reports received error:
        
    "Failed to retrieve data from the database
     Details: S1000:[SAP AG][LIBODBCHDB32 DLL][HDB] General error;7
     feature not supported: not allowed over OLAP VIEW : search without aggregation or grouping by expres [Database Vendor Code: 7 ]"

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
        
  • SAP Crystal Reports for Enterprise 4.1
  • SAP Crystal Reports for Enterprise 4.2
         
  • SAP HANA

Reproducing the Issue

  1. Create an SAP HANA Analytic View.
  2. Connect to SAP HANA via ODBC or JDBC in Crystal Reports.
  3. Choose the Analytic View from _SYS_BIC\package/analyticview
  4. Add an attribute to the details section of the report
  5. Refresh the report.
  6. Notice the error.

Cause

  • Analytic Views require SQL Queries to contain SELECT DISTINCT or GROUP BY for Attributes and summaries for Measures.

Resolution

  • For Crystal Reports for Enterprise and Crystal Reports 

    • Use the "Add Command" functionality to enter an SQL Statement directly which includes SELECT DISTINCT for attributes only or GROUP BY and summaries for attributes and measures.
       
          
  • For Crystal Reports Only:

    • If only Attributes are required in the report check in "Select Distinct Records" under the menu "Database" in Crystal Reports.
        
    • If Attributes and Measures are required:
      1. Group on each Attribute required in the report
      2. Create a summary on each Measure required in the report
      3. Delete all fields from the Details area of the report
      4. Check on Database | Perform Grouping On Server
             
    • NOTE: Report must meet all conditions for Perform Grouping on Server. Check referenced Knowledge Base Articles for tips.

Keywords

  • ODBC
  • JDBC
  • Analytic View
  • Analytical View
  • SAP HANA
, KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , BI-RA-CRE , Crystal Reports for Enterprise , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016