Web Intelligence does not display data

[ailton_souza]

Gentlemen,

I am going through a hard time and would rely on the experience of all.

I have a database SQL Server 2008 (over 20 million lines) where my universe (UNX) is built and feeding a Web Intelligence report (BOE 4.0 SP6).

Until the universe is very fast to query aggregates affairs. But when we build a report from the beginning and execute the query the report does not display any information, and more strange, does not display any error message.

Anyone have any suggestions of what might be the problem? It will be a service in the CMC? A property of the Web Intelligence?

Thanks!!

[former_member188911]

Hi Ailton,

sorry for the late reply...

this was a bug, fixed in SP6 Patch 3 

https://websmp107.sap-ag.de/~sapidb/011000358700000578702013E/

Page 26

ADAPT01695593 Description:

In Web Intelligence, if the data provider retrieves more than 1 million rows, a blank report is generated.

New Behaviour:

This problem is resolved.

Thanks!

Best regards,

Simone

[Former Member]

Hii Ailton ,

Try and create a new universe which would contain a single table without any restrictions and then build

a Webi Report on top of this new Universe and if it display any data then something is wrong with your Previous Universe and if the new universe also display Zero Records then kindly check the Font Size of

the Report data as for New Installed Server Webi Considers 0 Font hence we need to increase the Font Size and Color if required and i experienced the same issue in BO 3.1.

Regards

Jeetan Jagtap

[Former Member]

Hi

Please check your query result contain any blank fields. Any restriction on number of rows to be displayed on Universe?

Sandeep

[Former Member]

Hi,

Is it returning "No data to returned" message?

Also check if the universe parameter is having any "Controls" specified as '5000 rows" or somthing

Thanks

Sivakami P S

[Former Member]

Hi Ailton,

Check the below points,

1) Run the sql generated (from the Webi Report) in SQL Server DB.

2) Check the Row level and object level restrictions if any.

3)check the max row limit options in Both IDT and Webi Query

4) Check the where class of the objects which you have pulled in webi query

these steps may help you find the solution...

let me know anything is required...

[Former Member]

Hii Ailton ,

Kindly check whether the universe structure is appropriate and make sure all loops , traps are resolved

which many times restrict the data and also make sure the joins are defined properly with appropriate Dimension and there are no filters and condition.

Also check whether Connection is pointing to appropriate System .

Regards

Jeetan Jagtap

[Former Member]

Hi

Check the Joins

Entire SQL Query you copy and Paste it in Database

IN the Edit Query screen, click the SQL button. If the button is grayed out then your  admin will have to grant you the rights. If you clicked the SQL button, a window will open. CLick the Copy button to copy the SQL into your clipboard. Open your SQL tool, paste the SQL in and execute the SQL. If you don't have a SQL tool, then give the code to your DBA to execute.

The JOIN conditions are probably wrong or there are row restrictions in the WHERE clause.

ow level security can be in the database or the universe. To look in the universe go to Tools - Access Restrictions and see if there are any defined and whether they are applied to your account. More details on access restrictions can be found in the Designer documentation.

[ailton_souza]

Hello Naveen Kumar!

It was the first steps I performed. Unfortunately it seems it is not something in the universe.

Thank you for your help.