We are using Tableau to report on SAP HANA Calculation views. In our HANA Calculation view we have an input parameter defined (Multiple Values, Mandatory).
When we consume the view in HANA and enter the filters, it is throwing an error. By drilling down in to this error we see the SQL generated by Tableau is wrong.
SQL generated in Tableau
SELECT SUM("Development_Srini_Inventory__MARC_STOCKS_SRINI"."UMLMC") AS "sum_UMLMC_ok",
1 AS "X__alias__0"
FROM "Development.Srini.Inventory::MARC_STOCKS_SRINI" ( 'PLACEHOLDER' = ('$$IP_PLANT$$', 'NLP2') ) "Development_Srini_Inventory__MARC_STOCKS_SRINI"
WHERE (NULL IS NULL)
GROUP BY 1
Error is : [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error: [34023] Instantiation of calculation model failed;exception 306105: Invalid query. Failed to find 'nlp2' at node 'TRAME_etc'
SQL generated in Tableau
SELECT SUM("Development_Srini_Inventory__MARC_STOCKS_SRINI"."UMLMC") AS "sum_UMLMC_ok",
1 AS "X__alias__0"
FROM "Development.Srini.Inventory::MARC_STOCKS_SRINI" ( 'PLACEHOLDER' = ('$$IP_PLANT$$', '''NLP2''') ) "Development_Srini_Inventory__MARC_STOCKS_SRINI"
WHERE (NULL IS NULL)
GROUP BY 1
Can you please help me in resolving the issue.
Thanks
Srini
Hey Srini,
Tableau 10.1 improves the use of parameters with SQL in SAP HANA. I would check out our beta and see if the issue still occurs.
-Diego
Become a Viz Whiz on the Forums! Support the Community and master Tableau.