Help on BO Stored Procedures

[legrev]

Hi!

I was trying to create a report in Business Objects with the following format,
account_name, sum of transaction amounts more than 20K USD, date and amount of last transaction. I'm only using Oracle 7.3 and scalar subqueries are not possible with this version.

Will it be possible in BO to invoke a procedure to truncate and populate a temporary table (this table would contain the account_name and sum of transactions more than 20K), then do a select from this temporary table and the main transaction table to get the date and amount of the last transaction?

I'm using BO version 4.1.7 and Oracle 7.3.

Thank you very much!!!

Vergel

 

[blom0344]

From your description it may be more appropriate to create a view holding the values over 20K and report ON the view.

If a view can do the trick, it will be a simpler solution....

T. Blom
Information analyst
tbl@shimano-eu.com

 

[tkptkp]

Hi,

I've got a similar pb as legrev's. I want BO to refresh a temporary table before to report on.
Can any body tell me how to call a stored procedure in a report before executing the bo request.

Thank in advance
TKP

 

[skrandel]

You could do it with a Macro. Other than that, I don't think there is much you can do at the report level.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com