We were looking at using BusinessQuery to function as an interface between SPSS and BO. However, is BusinessQuery subject to the Excel row limitations? 65000 (approx) rows would not be a large return set.
Listserv Archives (BOB member since 2002-06-25)
Yes
“Uhles, Greg” greg.uhles@EDS.COM on 11/13/2000 12:51:14 PM
Please respond to Business Objects Query Tool BUSOB-L@LISTSERV.AOL.COM
cc: (bcc: John Harris/AHM/AM/HONDA)
We were looking at using BusinessQuery to function as an interface between SPSS and BO. However, is BusinessQuery subject to the Excel row limitations? 65000 (approx) rows would not be a large return set.
Listserv Archives (BOB member since 2002-06-25)
Actually, Business Query is not subject to the limitation. Excel is. If you are using BQ with SPSS, the question is: Is SPSS subject to a 65,000 row limitation. Unfortunately, I don’t know. If SPSS is really generating Excel files and reading from those, then I think you know your answer.
Listserv Archives (BOB member since 2002-06-25)
BusinessQuery for SPSS used to be a nice bridge to use the BO universes for filling a SPSS datasheet. But, with SPSS 10 this didn’t work anymore and SPSS stopped supporting BusinessQuery. After some “communication” with SPSS, they send us a add-in for BO to transfer the resultset of the dataprovider to an SPSS 10 datasheet. This worked until I upgraded to BO 5.1.
Before this we didn’t have any problems exporting more than 65000 rows from BO directly to SPSS.
Tom
We were looking at using BusinessQuery to function as an interface between SPSS and BO. However, is BusinessQuery subject to the Excel row limitations? 65000 (approx) rows would not be a large return set.
Listserv Archives (BOB member since 2002-06-25)