cancel
Showing results for 
Search instead for 
Did you mean: 

Limited result from OLE DB-connection

0 Kudos

Hi,

I am running a BO4.0 and I have a problem that my Ole Db connection (created in Information Design Tool) to a MS SqlServer 2012 only gives med 5000 rows.

I remember there was an explicit possibility to set the number of rows (or was that only for odbc?)

I have a poor reportdatasource not very well modeled. There is not to many rows to handle, about 4000 rows per month, and I would like to look at a resultset on some months. (when I run the query in Management Studio I get the whole expected dataset)

I guess its my OleDB-Connection that is the problem.

In what way should modify it to lets it give me more than 5000 rows. Whats is best practice when setting up a connection regarding "Array Fetch Size" and "Array Bind Size"?

Br,

Henrik

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Henrik,

Do you see "Partial Results" icon at the right hand bottom side of the report after running the report?

If yes, you may follow the below steps and check:

1. Import the universe in Designer.

2. Go to Parameters --> Controls tab

3. Uncheck "Limit size of result set to" option. (Seems like it is checked)

4. Export the universe.

5. Re-Open the report in BI Launchpad / refresh and check.

Regards,

Yuvraj