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 column if the value is >10000, it has to show downwards Arrow in green color, If the value is <10000, it has to show upwards arrow in red Color.... How to achieve this?

4 Answers   Cap Gemini,

---

how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this

5 Answers   HCL,

---

how to create metric universe ?

0 Answers   TCS,

---

What is self join

2 Answers   Blue Star, IBM,

---

What are the diffrences between Business Objects 5.1 & 6.5 ?

1 Answers   Siemens,

---

what is document design in boxi,have u participate in that

0 Answers   Accenture, TCS,

---

What is difference between custom hierarchy and report based hierarchy?

0 Answers  

---

How to resolve the partial result error in the report

4 Answers   Keane India Ltd,

---

What is the dense rank?

0 Answers  

---

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

0 Answers   ASD Lab, Wipro,

---

Can i use personal database connection to the Webintellegence reports?

1 Answers   Infotech,

---

can i use stored procedure in webi?

4 Answers   CTS, Wipro,

---