Can businessobjects create a temporary table, and then have the query run off of it? I’m using 4.1.3, but upgrading to 5.02 soon and sybase iq 11.5 (soon to be iq 12).
Any info would be helpful. Thanks!
Listserv Archives (BOB member since 2002-06-25)
There are a couple of ways that I’ve done what I think you’re asking about in the past. The first way would be to write a stored procedure and use it from BO. When the SP is executed, it would create the temp table, and then run the query on it and return the rows to BO.
The second way would be to have a backend process that runs periodically which populates the temp table for you, such as a perl script or a stored procedure. Then, you would design your universe to query the temp table.
The difference between these two methods are how fresh the data are. With the SP solution, the data are (apparently) real time. With the prepopulate idea, it depends on how often the table gets populated/replaced/updated/whatever. Your requirements would dictate which solution you choose.
Hope that helps.
Regards,
Paul
Listserv Archives (BOB member since 2002-06-25)
Kari
You may want to check out the new product “Set Analyzer” which I believe does what you want. I saw a demo recently at a Users group meeting so I don’t know much about it but you should check it out.
Mike McErlain
At 01:51 PM 3/24/2000 -0500, you wrote:
Can businessobjects create a temporary table, and then have the query run off of it? I’m using 4.1.3, but upgrading to 5.02 soon and sybase iq 11.5 (soon to be iq 12).
Listserv Archives (BOB member since 2002-06-25)
In a message dated 00-03-24 14:55:49 EST, you write:
You may want to check out the new product “Set Analyzer” which I
believe does what you want. I saw a demo recently at a Users group meeting so I don’t know much about it but you should check it out.
When you do, be sure to be sitting down when they tell you the price… 
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)