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?
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 |
I have a report with some hyperlinks,any issue will i get when i migrate this report?
What is security domain in Business Objects?
How to restrict password to a user while sending a document in .pdf format
how did u give developed universe to ur client?
how to creat 2 way drilling mode.can any one know this
Can we get the data from two different databasess in reporting level?
what are the complex reports you have created. Tell me with example?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
@prompt('message',['type'],[lov],[mono/multi], [free/constraint]) what is Constraint?
How do u Receive requiremnts from the client?
What is meant by data federator and what is the use of it?
what is tuning of business reports ?
5 Answers Business Intelligence Analytics, Oracle, TCS,