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.

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

0 Answers  

---

Shall we connect to the oltp systems directly .,

2 Answers   iNautix,

---

how many micro cubes can a report can have

3 Answers  

---

What are the advantages of setting up LOVs in the Universe?

2 Answers   Cap Gemini, Deloitte,

---

If there is no common dimension? Is it possible to combine two different dataproviders?

7 Answers  

---

What is thumbnail?

0 Answers  

---

What three things do you consider to be the most important factors for a manager?

0 Answers  

---

I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?

2 Answers   Patni,

---

How to hide objects or columns?

6 Answers   Infotech,

---

suppose case1:a person buy a car case2: rent a car which is context & which is alias? why?

2 Answers   IBM,

---

How to create a report template BO XI R2

2 Answers   Infosys, LBM,

---

HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..

4 Answers   IBM,

---