cancel
Showing results for 
Search instead for 
Did you mean: 

How to remove partial results alert

Former Member
0 Kudos

HI

i have run my report for the first time and i closed the report while its retrieving data...

then it should shows partial results alert always even if the query is completely run and im getting all the data

please help how to remove thr partial results alert from the report

Accepted Solutions (1)

Accepted Solutions (1)

former_member192142
Contributor
0 Kudos

Hi,

Are you sure you are actually getting all the data? The default limit in the universe is 5.000 rows. When you refresh a WebI doc it will seem as if it is finished/refreshed completely, but it will display "Partial results" if your document exceed the 5.000 rows limit.

Best regards,

Jacob

Former Member
0 Kudos

Hi

Thanks a lot

but can you help me out how to increase the number of rows to extract from database in universe because

we will be extracting more than 5000 rows at atime

former_member192142
Contributor
0 Kudos

Hi,

You are welcome.

You need to open up the Designer tool and import the universe on which you are building your WebI doc (File -> Import). Then you select the properties of the Universe (File -> Parameters -> Controls) and increase the 5.000 to whatever number you need or simply remove the checkmark to display all. Once done you will have to export the universe to the CMS (File -> Export).

Best regards,

Jacob

Former Member
0 Kudos

Thanks a lot its working fine now

former_member192142
Contributor
0 Kudos

Excellent - good to hear 🐵

Answers (0)