Answer / mayur

hi,

see i would like to answer it through on example:

consider the case where u retrive the data from the table xyz
by writing the "SELECT STATEMENT" & get the output ( say 5 rows) now their is the condition ....where u need this output(5 rows) for report/query..etc..

now, in such condition you can create an object of the above statement i.e "Select Statement" and store it in Derived table
& hence next time u will not require to write sql again...

& even a complex sql is effectively implemented...


finally this will enhance ur performance & a effective development logics ....

Answer / sampath kumar

Instead of Aggregated table we use the Derived table.
Aggregated table will be created by ETL people, for
summarized columns we use Aggregated table.

How to create a report template BO XI R2

2 Answers   Infosys, LBM,

---

what are the documentations u r created?

2 Answers   Wipro,

---

Steps to create alias and apply

2 Answers  

---

(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.

0 Answers  

---

What is mean by stored procedure ? and how we can generate stored procedure universe?

3 Answers  

---

what is mean by lov?

4 Answers  

---

how many times can use the union operator in a report?

3 Answers  

---

I need to modify Web Intelligence Report, I need to Add 7 columns in WEBI Report-Java Pannel, so i could Add only 6 Columns in the Webi-Java Pannel as one X Table - X Column is not available in the Universe. I was advised that i can do it with Free Hand SQL in Web Intelligence even X Table - X Column is not available in Universe. Please kindly let me know how to implement the same

2 Answers  

---

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

2 Answers  

---

If any one Deleted the BOMain key by accidently,is any possible to get back that Bomain key.if possible please send some steps.

2 Answers   iFlex, Pfizer,

---

Explain how to execute the plsql procedure from the report by clicking with mouse?

0 Answers  

---

you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1

4 Answers   IBM,

---