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
- 24924 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
Is there any other repository domains rather than universe, security, document?
What three things do you consider to be the most important factors for a manager?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
Explain is there any default username & pwd for bo designer & supervisor?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Explain what are the measure objects?
What is the difference between absolute and relative div positioning?
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
is it possible to export the webi reports to crystal reports?with out using businessview?
Explain the data types present in bo and what happens if we implement view in the designer and report?
What sort of existing documents should business analysts refer to when starting on a new project?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
Explain in detail about type 2(scd),
Can we configure two instances of CMS pointing to two different CMS system databases?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
