as some of you might know, there is still an issue regarding the use of Input Parameter of type “Multiple Values” on calculation views when working with Lumira.
There is also a SAP Note for that, number 2373901, probably still not released, but here the content:
2373901 – HANA Calculation view multiple values prompt does not work properly in Lumira.
• Records are filtered only for the first value selected in HANA Calculation view multiple values prompt
• SAP Lumira 1.31 Patch 1
Reproducing the Issue
1. Create a Hana Calculation View with Multiple Entries Input Parameter
2. Connect Lumira to the Calculation View
3. Select Multiple Values for the Input Parameter
4. Refresh and notice data filtered only for the first value selected
Lumira does not support Multiple Entries Input Parameters for Hana Calculation Views
If possible change the Multiple Entries Input parameters to Multiple Entries Variables. Variables are supported.
Note: There is a difference between processing variables and input parameters in SELECT statement. The variable filter goes in into the WHERE clause of the statement whereas input parameters go in as a PLACEHOLDER.
Unfortunately, we cannot use variables, because we want to apply some logic on the aggregated result set:
We need to be able to select some cost centers, assume CC1000, CC2000 and CC3000. Then, in a projection after an aggregation without the column for cost center, we build a calculated column, let’s call them “Sales higher 1000”, where we put an ‘X’ when the aggregated (over all three cost centers!) sales amount is higher than 1000.
As you certainly know, variables apply only on the final result set, which in our case would lead to wrong results.
Any suggestion and help is appreciated.
I'm using Lumira 1.31 Patch 3.