Using more than one multiple entries Input Parameters in Graphical Calculation View

[former_member192347]

Hi I have a Calculation which takes Division and Region as parameters, as single value and works well.

Now per business requirement change, I made both these parameters Multiple Entries, updated the Filter expression. This works ok.

However the business user wants to enter multiple values for both the input parameters and HANA allows to input multiple values only for 1st parameter (in this case division) and not for both parameters.

Is this a bug or am I missing something?

Thanks,

Abhay

[former_member182302]

Enabling multiple value parameters is done at input parameter level and there should not be a case where it is working for 1 column and not for another ( Hopefully HANA is not showing input parameter level discrimination )

Let us know how you are handling the multiple values and may be we can help.

Also have a look on this blog from Lars :

Regards,

Krishna Tangudu

[former_member192347]

Filter condition

[former_member182302]

So you are unable to enter a value for Division as you showed in the screenshot?

Regards,

Krishna Tangudu

[former_member192347]

every time clicked on the green plus sign, in opens up new row to enter value for the Division and but not for the Region. You might want to try similar scenario.

If I make the Division as Single entry and keep the Region as multiple entries then it allows to enter multiple values for Region.

Let me know how to use it correctly.

Regards,

Abhay

[former_member182302]

Just to confirm, you were able to write a query like below :

SELECT
  REGION
  DIVISION
FROM "_SYS_BIC"."TEST/CV_UNION_TABLES"('PLACEHOLDER' = ('$$region$$',
  '''reg1'',''reg2'''),
  'PLACEHOLDER' = ('$$division$$',
  '''div1'',''div2'''))

But you were unable to get the data preview option to enter multiple values for both the input parameters right?

Regards,

Krishna Tangudu

[former_member182302]

Adding to the above, Even I notice the same behaviour . If I add 2 default values for each of the input parameter then it is repeating twice as shown below :

But on "Adding" , I get the initial parameter only.

Regards,

Krishna Tangudu

[former_member192347]

Hi Krishna,

Yes, you got what is the issue, "clicking on the green plus sign only adds row for first parameter and doesn't provide row for 2nd parameter". Question is, how to enter multiple values for 2nd parameter, when there are two parameters with multiple entries.

Regards,

Abhay

[former_member182302]

HANA Data Preview :

The option to choose is coming in this way :

I tried to data preview from Web IDE and it is working fine there as shown below :

It is better to use Web IDE more than HANA Studio

Regards,

Krishna Tangudu