Explain about derived tables?
Answers were Sorted based on User's Feedback
Answer / vinay
derived tables are logical tables in the universe. to
reduce the query complexity and better query performance or
complex querys we write in derived tables. derived tables
are nothing but sql queries. thease tables can be used in
prompts...
Is This Answer Correct ? | 9 Yes | 4 No |
Answer / srini
Some times the main query needs a driving query in FROM
clause, which is not possible to build. So we use derived
tables to fix this.
Example:
SELECT
----
FROM
TABLE1,
( SELECT
---
FROM
TABLE2
)DERIVED_TABLE
WHERE
TABLE1.COLUMN = DERIVED_TABLE.COLUMN;
Is This Answer Correct ? | 1 Yes | 0 No |
How to create Derived Tables in BO 6.5.4 with columns from different tables in the universe and how it has to be joined in the universe? If any one gives us a PPT format I will be more thankful.
1 Answers Cognizant, WinAlliance,
Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?
Who launches the supervisor product in Business Objects for first time?
what is the new tool introduce in BOXI r3 compare with boxi r2, can any one tell and what is the differences between boxir3 and boxi4.0 thanx in advance
Can anybady tell me , what is the aggrigate awareness.how to use it . could u plz give me the practical example.
IN BO I HAVE DATASOURCE HAVING THE DATA LIKE "abc" and after creating the Report that is unmathed data like "DEF".what will you do ?
What are the errors u have faced in creating reports in business objects and explain some?
if we shortcut join between two tables what will be the output?that it will give all columns or same columns?
What are the steps to do to use alerts in bo?
Can some one explain in detail about the following: What are Traps? How to recognize the Traps? How to solve them?
I have all the below SAP – Business Objects Certification latest Dumps, I scored 100 % Score with these Dumps
HI ALL, CAN ANY PLEASE TELL ME HOW TO CREATE HYPERLINKS IN WEBI.THANKS IN ADVANCE