Skip to Main Content
Spotfire Ideas Portal
Status Future Consideration
Categories data sources
Created by Guest
Created on Jun 26, 2019

Support Input Parameters for SAP HANA data source

At our Company, we use lot of HANA Graphical Models. Graphical Models behave as run time views which can be introspected and used in Composite. 

One of the most important and essential feature provided by SAP HANA is input parameters in Graphical Models. With this feature, we can write queries by providing input parameter value that can then be used for filtering at appropriate level. This helps in writing efficient and effective queries. 

Once input parameters are used in a model, the model can be queried with parameters as below: 
SELECT * 
FROM 
<SCHEMA_NAME>.<MODEL_NAME>('PLACEHOLDER' = ('$$IP_PARAMETER_NAME$$', '''0000000001'',''0000000002''')); 

Till 8.1 version of TDV this feature is not supported. This feature is essential for our landscape if we have to continue using SAP HANA as a data source for TDV.
  • Attach files
  • Guest
    Nov 4, 2019

    I would agree.  This is a requirement