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.

what is the different between link and join ?

2 Answers  

---

Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?

0 Answers  

---

Why do we need metrics and sets?

1 Answers  

---

I am getting an pop"there is no data to retrieve" when ever there is no data in the DB,what should be done not to get this pop up even if there is no data

2 Answers  

---

1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

2 Answers   TCS,

---

1.what is the functionality of "Event Server" in BOXIR2? 2.what happen if RAS server is down in BOXIR2

3 Answers   CTS,

---

What is the difference between Sychronisatio and join?

2 Answers   Mind Tree,

---

HI, can anybody explain me how performence will decrease if we create objects using derived tables ?

2 Answers  

---

What is #DATASYNC error how to remove it?

2 Answers   IBM, TCS,

---

What are universe parameters?

6 Answers  

---

Difference between zabo and webi?

0 Answers  

---

what is meant by slowly changing dimensions?

3 Answers   TCS,

---