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.

Instead of cms which server you have to use?

2 Answers   CTS,

---

Can anybody tell me about issues faced while creating universe. thanks in advance

1 Answers   Accenture,

---

How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

0 Answers  

---

Which outer join is used in Merge Dimension. Diff between merge and auto merge dimension.

2 Answers   Cap Gemini, Infinity, TCS,

---

Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

0 Answers  

---

how to add duplicte rows to the existing report in webi ?

1 Answers   HCL,

---

how can we build one report from two data bases

4 Answers   IBM,

---

why we are using derived tables ?how it will help?

2 Answers  

---

if the project is assigned for you and the client said yo wait for a month,What will you do in that time?

1 Answers  

---

CAN A REPOSITORY CONTAINS REPORTS?

7 Answers   AG Technologies,

---

what is a Micro cube?

5 Answers   TCS,

---

what is crystal reports?how to migrate them?

2 Answers   IBM,

---