Schedule WebI Report on SAP HANA Calculation View

[bassam]

Hello Experts,

I am working on a WebI report based on SAP HANA Calculation view. The report has a date range filter in it and some other optional filters aswell.

I have a requirnment from the user where he wants the same report to be generated as an excel every day and sent to a group of users on their email. The report should be filtered on every previous day every day.

I would apprecaite if any one can guide me what will be the best approch for implementation of a schedueld report on SAP HANA view? If there can be any step by step guide it will be of great help.

SAP BO : 4.2 SP6

SAP HANA : 2.0 SP03

Thanks & Regards,

Bassam

[former_member812387]

Hi ,

Create two new columns as below

CurrentDate = date(now())

PreviousDay = date(now()) -1

In webi report, for the date range filters pass these two objects.

ex: we have a date range object as Date --

Date >=current-date

and Date < Previous day.

if Now () function doesn't work then use CURRENT_DATE function.

Thanks

[bassam]

Hello seshap2022,

I have created the objects of current date and previous date as you have mentioned but WebI doesnot allow to assign an object as a filter in the prompt field. When assigning a filter type for the date object i.e "FORM_DATE" in the prompt panel of the query the following prompt type options are grayed out "Object from the query" , "Result from another Options" as you can see from the image. As per my understanding these options are only available when the view is based on a universe but in my case I have a HANA view.

I have even created a separate query with only date objects in order to use the "result from another query" option but it is grayed out as well.

Regards,

Bassam