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
- 4892 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 |
Explain about Short cut join?
What are the diffrences between Business Objects 5.1 & 6.5 ?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
What is the use of AFD? Where it can be stored?
Can anyone tell me how to display (calculate )Turn Around Time between two dates in the BO Report? Thanks in Advance
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
how can i add two different reports in the same document?
When we go for OLAP , and When we go for OLTP for generating the reports ?
Explain the data types present in bo and what happens if we implement view in the designer and report?
any difficulitis have you phase while creating bo reports and how did u solve it
please anyone explain me the derived table with the problem tables.
How do u Receive requiremnts from the client?
Teradata 
