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 Bassam,

Hana views seems not supporting this functionality,

As an alternative try to use custom query script option and edit the default generated where class statement it will work.

In where class edit script

Table_1."From_Date" > =Table_1.Currrent_date

and Table_1."From_Date" <Table_1.Previous_date

NB: There are some constraints with this

1. When you add a new column to the report, it will overwrite the custom script.

2. We have to make sure no of columns & data type of each column in query result objects must be same in query script select statement.

Thanks

[bassam]

Thank you for your reply Seshu,

Unfortunately connecion to HANA is an OLAP connection and HANA views doesn't support custom query script as the options are grayed out as you can see from the image below:

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