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?
Answer Posted / 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 |
Post New Answer View All Answers
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
What is the difference between the public object&schema object?
How to restrict password to a user while sending a document in .pdf format
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
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...
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
8. How much supervision have you typically received in your previous job?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
How to open a universe with out using the Designer ??
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S