value help for input parameters/variables

[former_member195653]

Hi All,

Can any one help on interactive filters for calculation view.

For example :

Like ABAP filters , based on first filter selection second input parameter values should be restricted.

[Former Member · Accepted solution]

Hi Narendra,

I do not have idea on ABAP-interactive filters but there is something called 'parameter mapping' in studio where you can map input parameters with constants/other input parameters/variables. Then at run time, based on the value given in mapped input parameter, values will get filtered out in another input parameter.

Please refer this for details

Map Input Parameters or Variables of External Views for Value Help - SAP HANA Modeling Guide - SAP L...

Best Regards,

Shireesha

[former_member195653 · Accepted solution]

Hi Shireesha,

I have 2 variables 1. material group and 2. material.

First variable I will select material group xx, in second varaible I have to see only XX group materials.

Is these possible in HANA.

Thanks,

Narendra

[Former Member · Accepted solution]

Hi Narendra,

I think it should be possible, can you post requirement with sample data?

Regards,

Shireesha

[former_member195653 · Accepted solution]

Hi Shireesha,

Table: MARA

MATNR      MAKTL

01               A1

02               A1

03               A1

04               B1

05               B1

Hana Variables:

1.V_MAKTL

2.V_MATNR

Expected Output1:

V_MAKTL -- B1

V_MATNR -- 04 and 05

Expected Output2:

V_MAKTL -- A1

V_MATNR -- 01, 02 and 03

Explanation:

When we select V_MAKTL variable as "B1", in second variable V_MATNR drill down show as 04 and 05 only. same for second Output2 also.

Thanks,

Narendra

[Former Member · Accepted solution]

This message was moderated.

[Former Member · Accepted solution]

Hi Narendra,

Create calculation view CAL_VAR as below

Create input parameter as below and add it as a filter to column MAKTL

Create another calculation view CAL_USE_VAR as below

Create variable using external view CAL_VAR

click on Manage mapping button and map external view input parameter with current view variable as below

activate and data preview - both variables VAR_MATNR and VAR_MAKTL will be popped up wherein first you choose value for VAR_MAKTL as 'A1' then you will get 1,2,3 in VAR_MATNR.

External variable VAR_MATNR query would be roughly like this 'select MATNR from CAL_VAR where IP_MAKTL = VAR_MAKTL';

Video:

Paramteter Mapping - YouTube

Best Regards,

Shireesha

[Former Member · Accepted solution]

Hi Shireesha,

Thanks for your Help and appreciate your time.

I tried with your approach, it is working for interactive filters. I am not getting data preview output for the Variable Selection.

Thanks,

Surendra

[Former Member · Accepted solution]

Hi Surendra,

Looks there is an issue with variables, meanwhile you can achieve the same output with input parameters as filters.

Regards,

Shireesha

[former_member195653 · Accepted solution]

Hi Shireesha,

Thanks for your help. For variable selection it is working as expected. Now I got an idea to display the data preview output also.

Thanks,

Narendra

[Former Member]

We dont have option for interactive filters. please help any body on this.