can anybody tell me about issues faced while creating reports
Answer Posted / 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 |
Post New Answer View All Answers
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Can we create universe with no cache??
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
What is the difference between the public object&schema object?
how many reports have u created ? explain a few.
What is the difference between condition & filter?
How to schedule the report in b.o?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What sort of existing documents should business analysts refer to when starting on a new project?
What is the difference between datawarehousing and businessintelligence?
What we need to discuss with designer before starting the universe designing.
Explain what is the difference between slice and dice and cross tab report?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
Explain about a time when you discovered a more efficient way to do a work task?