BO4 - Large reports not displaying rows but data exists

[former_member272336]

Hi,

We have a large report returning approx 2 million rows.

Data exists but when add report doesn't display in the report.

If put filter on to limit rows displatyed dat ashows.

Is there a parameters which governs if data shows in report when over n rows?

Thanks

[Former Member]

Hi Philip

How many rows can be seen at once, for a mximum?

Reagrds

Sandeep

[former_member272336]

Hi Sandeep,

I million rows.

Thanks

Philip

[CdnConnection]

Philip,

     WebI is an Analysis tool NOT Data Exploration &/or Data Dump tool.  If you need to explorer with anything more than 500,000 records, you should be using Explorer.

WebI is NOT designed to work so many records.

Regards,

Ajay

[former_member272336]

Thanks for advice.

Appreciate that.   Trying to convince users about this as often they want reports with way too many records.

[jyothirmayee_s]

Hi,

Do you mean when yuo add a tab within report.. recors are not displaying?.

There must be a safety belt applied on maximum records. Please check properties in repot level as well as on server level.

Thanks,

Jothi

[former_member272336]

Hi All,

Thanks for replies.

yes - is dat abut when try drag on doesn't show -

which properteis - checked webi proc server nothing abvious.

Thanks

[former_member272336]

Hi,

Looking on service marketplace - looks to be ismilar issue adapt raised fro > 1 million rows.

ADAPT01695593

We are unx and dont have the critical patches installed but are sp06.

Anyone else seen this behaviour.

Thanks

[former_member188911]

Hi Philip,

it is what you said, queries that have more than 1M rows return a blank report.

It is assigned to development and waiting for a fix, please liaise with support for timing.

Thanks

SC

[former_member188911]

PS it happens only on SP06 hence if this is preventing normal reporting you may wish either to reduce the number of returned rows or to not upgrade to SP06 yet.

[former_member272336]

Hi,

Thanks for response.

Will workaround in meantime.

Hopefully will be fixed by time have sp7.

Thanks

[Former Member]

Hi Philip,

Use the function Numberofrows([Dataprovider/Query name]) under the Data provider category of functions to get the number of rows retrieved from the query, which gives a picture whether data is present on report or not.

If its showing a number then try and create a new report tab to drag and drop objects to see data.

Hope this helps.

Thanks

Mallik