When trying to connect to a HANA Calculated View with a Parameter Requirement.
I use a Select *... the use Place Holder = .... to send to the HANA CV.
This part works.
However, when I bring in launch the "Date Modeler" I get one bubble named "PLACEHOLDER" with no fields visible.
I go into the Sheet creation and the fields are there, but this does not allow use of the DATA MODELER for adding data and executing Joins.
The reason I use Select * is the design of the HANA CV is still changing and change management is ...challanging. So the easiest way to see make sure I capture added fields in my Published Viz App is to use the * to select all fields.
Hi! I have a couple if ideas. Although using SELECT * is convenient during frequent schema changes, it might confuse the Data Modeler, especially when dealing with SAP HANA CV parameters. As a workaround, consider explicitly selecting fields in the SQL query even if it means updating the query whenever the schema changes. This way, Qlik can properly identify the structure of the data for use in the Data Modeler.
Instead of using SELECT *, use a script-based approach in Qlik's script editor to capture the dynamic changes. This method allows more control over how parameters and fields are managed. For example:
LOAD Field1, Field2, ... SQL SELECT * FROM "Your_HANA_CV" WHERE PLACEHOLDER = 'YourParameter'; This way, Qlik can still capture new fields when the schema changes, provided you explicitly list them in the load statement.
May be at first stage use few fields, just to see it works.
