Skip to Content

How to pass an asterisk as a parameter in HANA flowgraph

Hi all,

I am struggling with passing an asterisk as a custom parameter in a HANA flowgraph and would appreciate your help as I haven't found any information on the internet so far.

The flowgraph loads the values from a Calculation View into a CDS Entity. This Calculation View has an Input Parameter (e.g. mandant) that of course needs to be filled in the flowgraph (please, see attached images).

The parameter is: type: direct, multiple entries, default value: constant ALL.

If I fill it with ALL or *, or leave it in blank, I get an SQL syntax error. And if I fill it with 'ALL' or '*', it's interpreted as string and I get a search table error. Otherwise, when filling with an specific value in single quotes (e.g. '100'), it works, but I need to run the flowgraph for all the values.

Version: SAP Web IDE for HANA 2 SPS 04 Patch 9 (Build 4.4.22)

Many thanks for your help!

Kind regards,

Carlos

bfimt.png (23.4 kB)
ek8jk.png (19.5 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.