2056276 - Error: [HDB 02018]-Cannot Execute Query when adding subtotal to Dimension in Lumira connecting to HANA views

Symptom

"Error: [HDB 02018]-[Cannot Execute Query: Invalid table types]" when trying to add subtotals to visualization in Lumira connecting to HANA views in online mode.

Other Terms

Environment:

• SAP HANA
• SAP Lumira 1.18

Steps to reproduce:

1. Connect SAP Lumira to HANA in Online mode.
2. Create a visualization on calculation views to display dimensions and measures in a grid.
3. Add a subtotal to Dimension.
4. Error is returned.

Reason and Prerequisites

SAP HANA Revision 81 contains an issue with auditing which is causing this problem.

Solution

SAP HANA Revision 82 contains a fix to auditing for this issue.
Recommended solution is to upgrade to SAP HANA Revision 82 and SAP Lumira 1.19.
A short term workaround is to disable Auditing in the SAP HANA Revision 81 system.

Header Data

Released On	23.09.2014 01:28:22
Release Status	Released for Customer
Component	BI-LUM-DSK SAP Lumira (Desktop)
Priority	Correction with medium priority
Category	Program error