SAP HANA restrict columns with variable

[Former Member]

Hi all.

Is possible in HANA to filter two or more columns with different variables?. For example in a calculation view one column filtered with var1 and other with var2, and when displaying the values the pop-up will let filtering by var1 or var2.

I know that in Bex BW queries is possible.

Any thoughts?

Thanks

[Former Member · Accepted solution]

Thanks for the answers, were really useful.

The following link explains how to get all values when nothing is selected in the input parameters:

Basically using the following sentence in the calculated column:

in('DIMENSION",'$$INPUT_PARAMETER$$') or match ("DIMENSION",'*$$INPUT_PARAMETER$$$$*') * COLUMN

Hope it helps else one,

Fran.

[Former Member]

Hi again. Yes, with the input parameters is working fine when filtering one column for an specific dimension.

After testing I have realized that when no value is populated in the input parameter the output (Calculated column or Restricted column) is not getting any value. Could be possible that when no value is selected in the input parameter no filter will be applied?

Thanks for the replies,

Fran.

[RashmiAcharya]

Hi Fran,

When you apply filters on columns using Input Parameter and at runtime(data preview) if you enter values(s) for them then Data Preview will be shown with filtered values. But if you do not enter value for any Input Parameter also in data preview pop-up, no Data will be shown in data preview.

But with variables if you do not enter any values in data preview pop-up, data preview will show all the data i.e. nothing but without applying any filters. Also if you enter values for some variable filters and do not enter values for other variables, data preview will be shown accordingly i.e. filter will be applied for variables where user enters some value in pop-up.

Regards,

Rashmi

[Former Member]

Hi Francisco,

It can be done through variables or input parameters, refer » SAP HANA Variables and Input Parameters

Best Regards,

Shireesha

[Former Member]

Hi,

yes it is possible, you can create for a certain column1 an input parameter IP_1.

Please do search on Input parameters

BR

Kairat