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