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 |
REGULAR CLASSES for OBIEE Reporting(RPD, Answer, BI Publisher) is Starting From Tuesday, 25th Oct, 7:00 AM IST
When is the Repository created?
i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)
WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE? WHAT IS MICROCUBE EXACTLY?
how can we build one report from two data bases
Explain in Detail about Measure Objects? and what is the use of it? How to create it?
1. I have 2 universes. that is u1 and u2. From u1,i created one report that is r1. Now i want to give the connection r1 to u2 and at the same time delete the connection from u1 to r1 ? How is it possible explain? 2.How can i schedule the reports in BOXIR2?
Tow tables is there employee, projects . (many to many) one employee has different projects and one project has different employees . how we can achive the data from both
what is universe testing(not mention check integrity)
what is local filter
When we r going for Short_cut join & It's Resolution??? Plz provide one scenario??
How can we improve performance?