Skip to Content
avatar image
Former Member

Getting Partial Results

Hi all,

I'm executing a big report in webi, and I'm getting the partial results message.

I changed the Universe parameters to 10,000 rows and time limit to 10min but I'm getting just 3 rows, and I know the report has more rows, because I ran it from SQL developer I'm working with Oracle.

I can not disable the limits, because the standards of my environment don't allow it.

Do you know why I'm getting just 3 rows? if the limit is 10,000.

Thank you,


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Sep 12, 2008 at 10:36 PM

    Go to Universe -- Parameters.

    Go to the Controls tab.

    You would find a parameter "Limit size of Result Set to"

    If this option is checked, just uncheck this option.

    At the report level:

    Open the report in Edit mode.

    Go to Edit Query.

    Under the Properties tab you would find a checkbox "Max Rows Retrieved"

    Just uncheck this option as well.

    I hope this helps.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Thanks everyone for your answers, I resolved the issue. The report was getting a lot of data and it was because I didn't uncheck the "Retrieve duplicated rows" in the properties of the Query. I also splited the report in different sub-reports.

      It's working now.