Skip to Content
0

Teradata Macro trigger through SAP Business Object

Nov 29, 2016 at 03:24 AM

53

avatar image
Former Member

Hi,

We have requirement to run Teradata macro through SAP BO report . When report refresh it should execute the Teradata macro and display the result of the macro in BO Report.

Please let me know the feasibility to achieve this requirement.

We are using the BO version BO 4.2 SP 02.

Please advise .

Regards,

Siva.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Manikandan Elumalai Nov 29, 2016 at 05:19 PM
0

Hi Siva,

There is no direct way to achieve your requirement. However there is a work around with a slightly different approach.

Instead triggering the macro from report and the get the report results after the macro ran, Try to trigger your macro from Teradata side.You may need to do as follows.

- Create a webi report based on custom SQL i.e. Teradata macro

- Create a event driven schedule for the report cretaed in Step1

- As on when the user need the report, He need to trigger the Teradata maro which in turn creates a Event file for the report and triggers the schedule and users will receive the report with latest data.

Let us know if you need any clarification.

Thanks

Mani

Share
10 |10000 characters needed characters left characters exceeded