Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell me about issues faced while creating reports
- 1 Answers
- 2865 Views
- Accenture, Tech Mahindra, I also Faced
- E-Mail Answers
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
What is aggregate table and aggregate fact table ... Any examples of both?
What is the difference in creating filters in designer and business objects?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
Explain about alerts in bos, under what situation we need to use alerts?
Explain what are the measure objects?
how many reports have u created ? explain a few.
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Explain what sort of existing documents should business analysts refer to when starting on a new project?
When to use local filter and when to use global filter?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain about a task that really tested your analytical abilities?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
What is report template in b.o?
Explain how to execute the plsql procedure from the report by clicking with mouse?
