Interested to Buy Any Domain ? << Click Here >> for more details...
can anybody tell me about issues faced while creating reports
- 1 Answers
- 2848 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 |
Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?
How to execute the plsql procedure from the report by clicking with mouse?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
how do u migrate BO 6.x to XI ?
52 Answers Cognizant, HCL, IBM, Wipro,
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
How to import BIAR file in bo?
what is custom sorting?how we can do this expalain with procedure???
How to view Public folder in Infoview for the Non-admin user? (normal user) What is the diff of working DEKI,WEBI in Infoview, and working as Individual start->Business Objects-> Deskto Intelligence, Web Intelligence.
what is the difference between input file repository server and output file repository server ?
i Have created the universe in which i have one table and different derived tables from the same table i am supposed to create report from the same universe which should dispalay the duplicates rows, but all the time i run the report i am not getting the duplicate rows i have checkd the duplicate report option too in report.. is there problem with universe or report,.. can any body help?
WHAT ARE TEMPLATES? EXPLAIN WHAT YOU HAVE CREATED?
Hi ,how many shortcut joins used in a single universe? Thanks in Advance
Teradata 
