cancel
Showing results for 
Search instead for 
Did you mean: 

WEBI returns 'Partial Results' (BOBJ 4.x)

former_member226862
Participant
0 Kudos

After refreshing data in WEBI report yellow triangle is displayed with worning message 'Partial Results'.

WEBI report was built on top of MS SQL based universe and BOBJ version 4.0. Univers was built using Information Design Tool.

In Query properties 'Max Rows retrieved' and 'Max retrieval time' are unchecked.

What needs to be done to eliminate 'Partial Results' warning?

PS. Solution suggestions based on 3.x posts did not help

Accepted Solutions (0)

Answers (3)

Answers (3)

Hi all-

Glad to find this post.  Using the older Universe Designer I found that in File>Parameters I had a search return limit of 5K records in one of my linked universes.  I lifted the attenuator by unchecking it and my report now returns expected results.

Thank you all for sharing!!

Patti Ciavarelli

Senior Research Analyst

Pratt Institute

Former Member
0 Kudos

Hi, can someone help me with your knowledge.

I've chagned the max row limit in all three settings

1) Business Layer 'Query Options'

2) CMC - Manage - Applications - Webi - Quick display mode

3) Report - Query Panel - Query properties

But it still shows partial results. I don't know what's going on? Is there a way to track it down where it's restricting the result set?

sateesh_kumar1
Active Contributor
0 Kudos

Hi Ravi ,

Make sure you did unchecked limit size of result set and Limit Execution time in Business Layer properties in production environment.

Check no of rows returned in webi (use Querysummary()) .

Execute the SQL webi generated in database and check for no .of rows .

If you are using multiple Business layers ,make sure this changes applied in all .

Former Member
0 Kudos

Ravi

Change the default value for 'Maximum List of Values Size' from 50,000 to your desired size in CMC -> Servers -> WebApplicationProcessing Server under IES

See if this helps

Kris

Former Member
0 Kudos

Hi,

Did you try changing the properties in CMC for Webi Application under:

Quick display mode properties as it has got the max number of rows option to set it up to max of 100,000.

Thanks,

Suresh

former_member226862
Participant
0 Kudos

I did now but it did not help and I did not think it would in this case.

Depending on filter condition applied WEBI report would show from 1 to 1000 summarized records.

Former Member
0 Kudos

Hi,

Forgot to mention one more option.

In Webi Report Design mode of the Query not the report, there is a Icon which says Query Properties and this

has got the Max rows retrieved default to 5000 to all globally.

Check the radio button and change it to any number and you are good to go.

recommendation is to change both at CMC level and the above step too so that it won't bypass.

Thanks,

Suresh

former_member226862
Participant
0 Kudos

I am getting the same warning when I refresh data for report using saved version.

former_member226862
Participant
0 Kudos

Max record count I could put in was 10'000 records and I am still getting "Partial Results" warning.

However when unchecked - shouldn't it return all records?

Also maybe it's me but I could not find where to change Max records returned for query in CMC

former_member226862
Participant
0 Kudos

I found it...

In Information Design Tool look for tab 'Query Options' under Universe Parameters. It allows setting record count and time limits for Universe specified. By default those are set to 5000 records and 10 minutes.

Former Member
0 Kudos

Dear Egil Robs,

I am also facing same issue of Partial result , But I am not able to find tab 'Query Options' under Universe Parameters" as suggested by you.

Can you please help me with step by step for this ??? Where can I find this ????

former_member188911
Active Contributor
0 Kudos

please consult the Information Design Tool Guide at page 153

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4sp2_info_design_tool_en.pdf

another level at which you can limit the number of rows returned from a Database or the time is in the Query Properties in the Web Intelligence designer tools (Rich Client, Web, etc)

former_member224057
Discoverer
  1. Open the .BLX in the Information Design Tool
  2. Select the "Business Layer" panel if it wasn't opened by default
  3. Click on the universe name if not already selected
  4. The right-hand panel is called "Universe Parameters" and has four tabs: Properties, Query options, Comments, and Custom Properties
  5. Select the Query options tab
  6. Set the Query Limit and Query Options to meet your needs
Former Member
0 Kudos

Thanks a ton, Tom

Former Member
0 Kudos

Yours is a simple and exact solution Tom

jones_joseph
Explorer
0 Kudos

Thanks Tom... you saved lot of my time. I was looking for this property all over the place.... Great!