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 hide the prompts?

7 Answers   TCS,

---

I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers

1 Answers   IBM,

---

HOW TO SPOT A HIERARCHY?

2 Answers   TCS,

---

Can we configure two instances of CMS pointing to two different CMS system databases?

0 Answers  

---

please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

0 Answers   CTC,

---

What is the Drill filter and it's usage?

2 Answers  

---

What is the difference between the Webintelligence and desktopintelligence?

2 Answers   IBM,

---

Hai, Can anyone tell me 'how to use one dataprovider result as an input to another dataprovider?. In BO6.5 there is an option like "select query result". we can use this option in the filter. but the same thing not available in BO XI webi. if any one face this problem , can you please share with me how to do this? Thanks, Narmatha.

3 Answers  

---

what is dashboards? what is metrics?

7 Answers   TCS,

---

I have very Latest Business Objects-XI Certification Dumps for all the Codes, If anyone need, mail at: AJITH.BOXI@GMAIL.COM

39 Answers   TCS,

---

1. What is the difference between in creating filters in designer and business objects? 2.How did u give a developed universe to your client? 3.If i want to grant access to a report to a group of users,how do i do?

2 Answers  

---

Can we use two different sources in webirich client to create A report ? Like universe and excel etc...

3 Answers   PWC,

---