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
- 25034 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
Explain what is the difference between slice and dice and cross tab report?
What three things do you consider to be the most important factors for a manager?
Can you please send me the migration related issues .
What is the difference between slice and dice and cross tab report?
What is the difference between user and versatile user?
What is top business?
Which versions are used in the bo dashboard work?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
8. How much supervision have you typically received in your previous job?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
Explain about a time when you discovered a more efficient way to do a work task?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
How to schedule the report in b.o?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
