2146672 - Query based on calculation view in Analysis for office completes with message No applicable data found

• The query shows data for measures when you pull in the measures.
• The query shows no data when you pull in any dimension with the measures.
• The SQL query generated has a grouping-sets clause with options similar to the query shown below:

SELECT
"month_name", SUM("margin")
as "margin", SUM("amount_sold") as "amount_sold", SUM("quantity_sold")
as "quantity_sold" FROM "_SYS_BIC"."BOBJ/CopyOfShopFactsCalcView"
GROUP BY GROUPING SETS WITH SUBTOTAL STRUCTURED RESULT WITH OVERVIEW
PREFIX '#BICS_1426486637208_' ((("month_name") ORDER BY "month_name"...

• If you follow step 2 of KBA 1906657 and collect the Analysis Office log file you find an error message like the following in the log file:

ERROR [S1000] [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] General error;7 feature not supported: this query cannot be handled in OLAP engine (e.g., due to join), so options 
in the grouping-sets clause cannot be supported.

SAP HANA, platform edition

SQL standard, Analytical view, OLAP, feature not supported, non supported , KBA , HAN-DB-ENG-MDS , SAP HANA Multidimensional Services MDS / InA , BI-RA-AO-XLA , Excel Addin , HAN-DB-SEC , SAP HANA Security & User Management , HAN-STD-DEV-MOD , SAP HANA Analytical Modeling , Problem