can anybody tell me about issues faced while creating reports
- 1 Answers
- 2072 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 |
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Explain about alerts in bos, under what situation we need to use alerts?
please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.
what is the difference between bo and cognos?
What is thin client And thick client..?
I have 4 tables having many to many relationships between the tables? How i can get correct results in the report?
HOW TO PUBLISH A REPORT IN BO?
how to improve the performance of the report
Can more than 1 metric be applied on an analytic in business objects?
Can we start CMS server from CMC? Is yes can anyone tell me how plz Thanks in advance?
what is profile and packages in BOXI??
i want to creat 2way drilling using hyrarchies and hyperlinks...can anyone please help me
Teradata 
