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.

In a context can i get the data from two different factables by using the single data provider?

2 Answers   IBM,

---

what is difference between folders and category ?

4 Answers   Tech Mahindra,

---

Who launches the supervisor product in Business Objects for first time?

2 Answers  

---

every alternative row should be hilighted ? how u can ?

1 Answers  

---

what is report tracing in bo

5 Answers   Satyam, TCS,

---

normally we get many contexts when resolving loops or traps,how do u take them to reports.

2 Answers   Wipro,

---

What is meant by data federator and what is the use of it?

2 Answers   TCS,

---

When a report in Web intelligence is created with ten objects and save the same as PDF the report divides the report into two pages. One page with data for five objects and the other with next five objects? Is there a way to combine these ten columns in a single page view?

2 Answers  

---

how can we overcome by loops?and also is it possible ,one user can different universe

4 Answers  

---

Explain is there any default username & pwd for bo designer & supervisor?

0 Answers  

---

What are alertors in Business Objects?

5 Answers  

---

can i link two Universes having with different connection

3 Answers  

---