Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell me about issues faced while creating reports
- 1 Answers
- 3065 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
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What is the difference between user and versatile user?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
In banking domain how many Fact tables,Dimension table are present?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
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 is there any other repository domains rather than universe, security, document?
Can we configure two instances of CMS pointing to two different CMS system databases?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How to execute the plsql procedure from the report by clicking with mouse?
what is universe null
Can we Save (save as) WEBI Doc as DESKI?
Explain is there any default username & pwd for bo designer & supervisor?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
