Max Rows in BO Report

building reports webintelligence
1

I have3 millon records in my Database .Is it possible to view all the 3 million record when i run the BO Report.
I always get partial result.
I have also unchecked the Limit of rows in the universe…

Is that Possible to bring all the 3 million Reocrds …

If You have any idea pls help me out in this

Peliyar (BOB member since 2008-05-26)

2

Why do you want to do this, how are you going to read through all these rows?

You may have memory problems when trying to view this data in Webi.

Did you export it?

Also, the restriction may be set at the database side, try running the query througha SQL tool using the BO user account…

Mak 1 :uk: (BOB member since 2005-01-06)

3

Guess, viewing all rows in any DB query tool will fail.
Assuming you have 10 colums, each 30 characters, the file size will be approx 900MB. Opening such a large file (of any format) on any platform would be a limitation of the system.

This is not the best scenario/use of BO.

vigi_guna :australia: (BOB member since 2008-07-09)

4

Also mostly the reports will be exported as pdf or as Excel sheet. Practically speaking, who is going to view all these 3 million records? :crazy_face:

Jansi :india: (BOB member since 2008-05-12)

5

300 million records :blue:

You might want to apply a condition so thata data onto the report is returned based in a certain condition and you dont have to see all the data at once, a condition could be ‘month’, ‘day’, etc.
Good Luck!

gdrg7 :us: (BOB member since 2008-04-29)

6

Let see: 3000000 records, 60 lines per page, that will be 50000 pages if you print it :crazy_face: :crazy_face:
Is one of your users trying to create his own database in Excel or something?

HenkK

HenkK :netherlands: (BOB member since 2004-03-02)