what are the all possible reasons of getting partial result on a webi report?
Answers were Sorted based on User's Feedback
Answer / xyz
there may be restriction at the universe level ie allow max
array size limit in universe parameters should be unchecked
to get read of partial results
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / sj
Another reason,when you stop the refresh in between...
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / gowthami
1. Universe level data restriction: Allow max row limit in universe parameters
2. Report level restriction: Edit Query – Edit Query properties
1. Max rows
2. Max execution time
3. User’s improper refresh – stopping the execution in the middle
| Is This Answer Correct ? | 2 Yes | 0 No |
I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
what is local filter
What is the prm file ? can anybody explain me ?
How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?
Tell me the difference between cmc and cms?
GENARALLY HOW MANY REPORTS ARE CREATE FOR EACH ONE ?PLZ EXPLAIN AFEW FOR AUTOMOBILE PROJECTS?
please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.
What are the different types of connections?Explain?
WHO ARE THE USERS OF THE REPOSITORY?
tell me about aggregate awareness in detail?
Report have 10000 records,how to restrict the end user to 1000 Records?