HI, can anybody explain me how performence will decrease if
we create objects using derived tables ?
- 2 Answers
- 4058 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manoj
Derived Tables decrease the performance because even if you
include one single object from this table the entire query
from the table is executed .
You can see this in the sql Query panel.
hence i would avoid using any derived tables unless
mandatory
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ashok
by using derived table we can improve the query performance
because that is not created in database it can be designed
at universe designer only.
| Is This Answer Correct ? | 2 Yes | 2 No |
The business object 6.5 version is possible for created dashboard reports.if possible how is generated universe to dashboard reports
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Can some one say abt "ALL" in prompt .. How to get the word "ALL" in the prompt along with the list of values? Plz give me the steps?
When to use local filter and when to use global filter?
what is confirm dimension ?
any of the person working on encyclopedia? give the explanation briefly?
What is Indexing? how did u implement indexing?
IN BO i have data source having the data like "abc" and after creating the Report on that datasource the data unmathed like "def".what will you do ? please anybody help me
how to coneect to a server in a business objects
How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.
Can Bo generates the reports from cubical data ? Explain?
how many times can use the union operator in a report?
Teradata 
