Skip to Content
0
May 14, 2019 at 09:45 AM

BO Universe on HANA - Input Parameter Default Values Issue

508 Views Last edit May 20, 2019 at 12:27 PM 2 rev

Hello experts,

I have a HANA calculation view with two input parameters. All of them have default values, example:

input parameter XX - default value '001'

input parameter YY - default value 'AAA'

You can enter of course other values for these input parameters and the data preview returns data acording what you choose in the prompt.

I created an universe on this HANA CV with also two parameters and at query script END_SQL in the business layer:

WITH PARAMETERS ('PLACEHOLDER' = ('$$HANAInputParameter1$$',@Prompt(Parameter 1)), 'PLACEHOLDER' = ('$$HANAInputParameter2$$',@Prompt(Parameter 2)) )

But it does not work, only data for the default values are available in the query results at universe of webi level even if the user chooses in the prompt other values for these fields,

I unchecked default values in data foundation and also does not work.

How can I solve this issue? It's about a syntax error at END_SQL? Removing the default values at HANA CV level, what about the performance? Is there something I'm missing?

Thanks a lot in advance

Samantha A