How to resolve the partial result error in the report
Answers were Sorted based on User's Feedback
Answer / anu
If it is universe based report,then we may have
restrictions at universe level.
to remove that:
->open universe->parameters->controls->set limit size of
resul set to maximum values and save export unvierse to
repository
Also check if any filter conditions or restrictions are
there at report level.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / babisri
Edit the report query under Data Access -> Edit Query -> Query Properties.
Check the option "Max Rows Retrieved" and specify a value as required
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / gowthami
Universe Level check:
1.Increase the 'set limit size of result set to maximum values' in parameters tab of universe
Report level check:
1. Check the properties of the report and increase the 'maximum rows retrived'
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / venkat
Step 1> Go to the designer set the options like ...
parameters -> controls -> a>limit size of result set
to b> execution time of queries
then save the universe and export it into the repository
| Is This Answer Correct ? | 3 Yes | 5 No |
What is the link option in the reporting Environment?
Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both
What is the pivot option ? what is the need of it?
What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?
1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.
can we use detail in generation of reports? if customer id is a dimension in a report, what will happen if we define it as a detail?
Explain the difference between compatible and incompatible objects?
Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.
what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash
can we cretae views in universe level?
What is the difference between user and versatile user?
. In production reports, some dimensions are missing. how do you load these dimensions in production