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


Please Help Members By Posting Answers For Below Questions

Explain how to execute the plsql procedure from the report by clicking with mouse?

602


Did you face any problems while creating reports? Name? Solutions?

3262


hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

1583


how to create metric universe ?

1899


What is difference between custom hierarchy and report based hierarchy?

553






Can we configure two instances of CMS pointing to two different CMS system databases?

1496


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

2609


Explain is data mart?

597


Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

592


Explain the difference between union and group?

634


Difference between zabo and webi?

638


How to open a universe with out using the Designer ??

6622


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1481


Explain 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)?

544


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

9441