Skip to Content

Web Intelligence does not display data

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!!

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2013 at 04:39 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2013 at 05:47 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2013 at 09:01 AM

    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...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2013 at 09:18 AM

    Hi

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

    Sandeep

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 23, 2013 at 10:18 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 30, 2013 at 03:07 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.