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 |
can BO generate reports with out CUBICAL data to repository?
While at local system, u could get all records say 1 lakh, but while at server u got only 50000 records when u run the report. What could be the causes. How to Rectify this.
What are the types(Specific Names) of Scheduling in BO?
Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please
Explain how to execute the plsql procedure from the report by clicking with mouse?
HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?
What is casual dimension?
what is universe
How can you first report in Business Objects by using broadcast agent?
0 Answers Ness Technologies, Wipro,
can we use detail in generation of reports? if customer id is a dimension in a report, what will happen if we define it as a detail?
What is diff b/w Alias and Contexts in which situation we are using contexts instead of Alias?
i want to creat 2way drilling using hyrarchies and hyperlinks...can anyone please help me