Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell me about issues faced while creating reports
- 1 Answers
- 2969 Views
- Accenture, Tech Mahindra, I also Faced
- E-Mail Answers
Answer / vikram
While creating reports, there would be no issues in general if you have FRD(Functional Requirement Document) with you. Apart from that one must ensure few small things to avoid any sort of issues while creating a report in SAP BO
1. Always select the required objects in report rather than selecting the entire objects from the respective class.
2. Once objects are selected, try to view once the 'view script' by navigating your cursor in the query panel to avoid any multiple flow of the query which is formed.
3. Try to use query filters to reduce the load of data inside the report rather than report filter but ensure with business requirements.
4. if there is need to create multiple queries to meet business requirement then try to go for dependent filters for better performance.
5. If feasible go for Scope of analysis rather than drilling. performance factor.
6. if merging is not done then multiple types of errors will come inside report so go for merging.
7. If custom query is required then best practice would be creating a derived table rather then free hand sql, it is safe and secured.
8.avoid auto merging option in reports , this would give abnormal output.
9.if a table in universe /database is modified then it will impact reports. so don't get surprise if report was working yesterday and today not. relax and start to debug as reverse engineering.
| Is This Answer Correct ? | 0 Yes | 0 No |
how to prepare the documentation in business objects and where to get the requirement?
What is the pivot option ? what is the need of it?
Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.
I have a report with two queries and each query have prompt on some object. Tell me how many times it will ask for the input?
Can any body will explain about sarrogat key? Thanks in advance...........Prakash
What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?
IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?
What do you mean by Object qualification?
What is the use of BO SDK?
how we improve the performance of report and universe?
can any body tell me how to create Hyperlinks in BO XI R2?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Teradata 
