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
- 5009 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 |
disadvantages of boxi
what is slice & dice?
3 Answers Cognizant, Saama Tech, TCS,
Shall we connect to the oltp systems directly .,
I WOULD LIKE TO GO FOR ONLINE CERTIFICATION FOR BUSINESS OBJECTS 6X. CAN SOMEONE GIVE ME IDEA ABOUT. Thanks in advance
Explain when we use aggregate awareness function in designer?
WHAT KIND OF TOOL BO IS?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
0 Answers Banking, Genpact, TCS,
Explain what sort of existing documents should business analysts refer to when starting on a new project?
what is a filter?
I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )
what is difference between folders and category ?
how to connect the hyperlink in webi reports?
Teradata 
