Hana Input Selections and processing -

[former_member1302915]

Hi,

My Hana view contains records of all order types of RGL (regular) or BLK (bulk) with Order dates.

Requirement at HANA view level-

1 User gives date range ( I think we should use variable -range for this)

example : 01-05-2020 to 31-05-2020

2. User Selects OrderType : RGL (regular) or BLK (bulk)

Result /Output :

If I select RGL then it should retrieve RGL records for the period 01-05-2020 to 31-05-2020

If I select BLK then it should retrieve BLK records for the period 01-05-2020 to 31-05-2020

Please guide me how to achieve this?

[KonradZaleski]

1. Go to Semantics
2. Select Order Date column and click on Create Variable icon
   

   

3. Select Range as Selection Type
   

   

4. Click Ok and activate the view

When running the view you will be able to select Between operator and select the range

Perform the same steps for Order Type column but select Single Value as Selection Type .