Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between derived table and views?
which one gives better performance?
- 2 Answers
- 24818 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / prasanna.ramesh1
a derived table is dynamic,virtual table that you create
within universe structure.it consists of set of sql
statements that you create in designer and you can use it as
a logical table to create objects.
in the derived table sql set,you can put a select statement
in place of table name in the from clause.sql set can also
contain embeded prompts and you can create joins between
embeded physical tables ,just as you can with other tables.
derived tables can be used in place of database
views,aggregate tables,lookup tables.
by using derived table we are processing load from the
report server to the database.
views are also virtual tables which are created in database
level and can make use in universe.but we can not create
them in universe structure.
| Is This Answer Correct ? | 11 Yes | 6 No |
Post New Answer View All Answers
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
Can we create universe with no cache??
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
Explain difference between zabo and webi?
What are the steps to be taken to schedule the report?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain about a time when you discovered a more efficient way to do a work task?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
Did you face any problems while creating reports? Name? Solutions?
What is difference between webi and infoview?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
What is top business?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What task is 98% of the required work of a business analyst?
