Multiple Data Selection in HANA Calculation View

[former_member462348]

Hi Experts,

I have a requirement to display a date in the HANA Calculation View Selection Screen.

Example: Consider a date field Created At:

I want the user to give an option to choose any of the below Date options and then execute the view. User may choose any one dates based on his needs.

• -Past 3 months
• -Past 12 months
• -Past 3 years
• Or Manual Date Range

Since we dont have Radio buttons in HANA views like ABAP, Can anyone help me on this, if there are any other alternative methods available in HANA to display as above.

Thanks
Rufus Samuel

[lbreddemann]

SAP HANA Studio was never considered as a reporting end-user/consumer tool or UI. It's not good for that at all.

It is meant as a development and administration tool. To build more appealing UI for report consumers, there are plenty of reporting tools available (both from SAP and from 3rd party vendors) that offer features like that. Alternatively, you can always implement a UI in SAP UI5/OpenUI5 when running on SAP HANA.

[former_member462348]

Hi Lars

Thanks a lot for the detailed explanation.

Regards
Rufus Samuel

[former_member213277]

I tried something like below and it worked for me:

create a input parameter that provides static list

then apply Projection Filter as

Regards,

Nag

[former_member462348]

Hi Nagaraj,

Thanks much for your amazing solution provided. It really works for me as well 🙂

Regards
Rufus Samuel

[akshinde]

i don't think so we have option like this , either you create different graphical calculation view for each date selection criteria and trigger it depending upon what user select at application client level ; or create one table function , pass as one parameter value as 1 for past 3 months , 2 as past 12 months , 3 for past 3 years and 4 for manual date range and using this parameter construct cobditional where clause in your table function select query.