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.

I have all the latest SAP – Business Objects - XI Certification Dumps, SABE201: BUSINESS OBJECTS(TM) Enterprise Certified Professional XI – Level One SABE301: BUSINESS OBJECTS(TM) Enterprise Certified Professional XI – Level Two SABE401: BUSINESS OBJECTS Enterprise Certified Professional XI – Level Three SABE501V3.0: BUSINESS OBJECTS Certified Professional – BUSINESS OBJECTS Enterprise XI 3.0 – Update. RDCR201: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level One RDCR301:1 BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level Two RDCR08201: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level One RDCR08301: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 – Level Two RDCR08401: BUSINESS OBJECTS Certified Professional – Crystal Reports 2008 QAWI201V3.0: BUSINESS OBJECTS Certified Professional Web Intelligence XI 3.0 QAWI301V3.0: BUSINESS OBJECTS Certified Professional BUSINESS OBJECTS Web Intelligence XI 3 DMDI201: BUSINESS OBJECTS Data Integrator XI – Level One DMDI301: BUSINESS OBJECTS Data Integrator XI – Level Two You can get Guarantee Pass 100 % Score with these Dumps, If interested in any of the dump, drop me a mail to: srivatsav.2k5@gmail.com with Certification code

7 Answers   IBM, SAP Labs,

---

How to create a tooltip in Webi? Is there a way to create Tooltips in Webi reports for non- hyperlinked columns? Users should be able to hover over a value in a column in the report and that should show a tooltip box with more detail regarding that column value. This is possible when you hyperlinked the column,Is it possible when you dn't have hyperlinking? Thanks in advance.

1 Answers  

---

explain merge dimensions with real time in DWH?

1 Answers   IBM,

---

What is difference between custom hierarchy and report based hierarchy?

0 Answers  

---

i want to hide a chart in reporting level? i want to hide a prompt in designer level?

1 Answers   TCS,

---

I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?

4 Answers  

---

From Business Objects Web-I reports, we can link to other BO reports using Opendoc functinality. How do we link to reports in other reporting tool or how to give a link any website?

1 Answers  

---

Explain the diff security levels of Private, Public, Controlled, Confidential, Restricted.

1 Answers   TCS,

---

What is the drill up , drill down, drill by , drill trough ?

3 Answers   TCS,

---

What is the use of AFD? Where it can be stored?

1 Answers  

---

What is the degenerated Objects?

2 Answers  

---

my info view somehow stop working and when i try to open my info view or CMC both keep buffering in Internet explorer but unable to open please see if any one can help on it

1 Answers  

---