Interested to Buy Any Domain ? << Click Here >> for more details...
HI, Can any body explain me ? If we careate objects using
derived tables it will decreasess the performence? If we
are not creating the objects using the derived tables then
what is the use of having the derived tables?
- 3 Answers
- 4826 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
we can create objects using derived tables
if derived tables increses then only performance decreses
but if we include one object form this table the entire query from this table is executed.we can see this in query panel
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gowthami
In some scenario’s we cannot meet the requirement. In that case using derived table we can create own query with needed objects and can write the formula to achieve the requirement which cannot be done in general.
If there is no other way to achieve the requirement only the derived table can do. We can go for derived table. But it will decrease the performance of universe (more no of derived tables)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / raj
Use only when you need complex joins and calculations between tables in the BO universe then go with Derived table.To Update / Change the derived table structure in the universe is very easy
| Is This Answer Correct ? | 0 Yes | 0 No |
what are the tables used in health care domain project and columns used in report?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Where will you find the address of repository in Business Objects?
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
2 Answers Accenture, Rolta, TCS,
is it possible to export the webi reports to crystal reports?with out using businessview?
HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..
how u restrict the values?to display 5 values insted of 10 values?
What do you mean by Object qualification?
How to change the order of prompts in universe?
how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????
Explain what are the measure objects?
what is the source for metrics?
Teradata 
