What is the definition of derived table ?
Answers were Sorted based on User's Feedback
Answer / subramanyam
Derived table is nothing but logical table like view.it
doesn't carry out any data in the database.It is the
function in the designer. You can use the view as the table
in the universe design and you can create the class objects
and conditions based on that derived table.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / kumarreddy
A derived table is one that is created on-the-fly using the
SELECT statement, and referenced just like a regular table
or view. Derived tables exist in memory and can only be
referenced by the outer SELECT in which they are created.
| Is This Answer Correct ? | 4 Yes | 0 No |
What is the need of live office connector
1.what is the use of migration.(converting one version to another) 2. what r the migration issues faced while migrating from Bo5.x to BOXIR2 n how 2 resolve it. 3. provide some .ppt/material to understand abt migration easily.
What is the difference between the Webintelligence and desktopintelligence?
What are the data types present in bo? What happens if we implement view in the designer and report?
Explain about alerts in bos, under what situation we need to use alerts?
6.what is conformed dimension? R u used?
When to use local filter and when to use global filter?
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,
I HAVE DRAGGED OBJECTS IN QUERY PANEL.... IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES IN WHAT SITUATION IT WILL HAPPEN?
what is fantrap ?
Explain in detail about type 2(scd),
What is the @script and @variable functions in the universe designer ? can anybody explain me in a simple way?