Automate query execution and email results in BW 3.5

Hi!

We have a request to automate query execution every day and email the results to the user.

This query should be scheduled to execute every day at 6:00AM in the morning.

We cannot use Information broadcaster. We need permission to install it, which would have to go through many channels.

I tried to look into RSCRM_BAPI. But with this feature we can only save the query results as a .csv file on a file server.

Any other approach that could solve my problem, would be highly appreciated.

Thanks,

S.P