1 Reply Latest reply on Oct 26, 2016 3:56 PM by diego.medrano

    Consume SAP HANA Multiple input parameters

    Srinivas MANDA
    Srinivas MANDA Sep 19, 2016 12:11 PM

      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