Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Business Objects
  2. Suggest New Category

HI, can anybody explain me how performence will decrease if
we create objects using derived tables ?

Question Posted / vinodkrishnamsetty

Answers were Sorted based on User's Feedback



HI, can anybody explain me how performence will decrease if we create objects using derived tables..

Answer / manoj

Derived Tables decrease the performance because even if you
include one single object from this table the entire query
from the table is executed .

You can see this in the sql Query panel.

hence i would avoid using any derived tables unless
mandatory

Is This Answer Correct ?    5 Yes 0 No

HI, can anybody explain me how performence will decrease if we create objects using derived tables..

Answer / ashok

by using derived table we can improve the query performance
because that is not created in database it can be designed
at universe designer only.

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More Business Objects Interview Questions

I have 2 structures in universe,but i can't link the structures b'cos no related columns,so what i have 2 do to link dat and if don't link them can i get data of 2 structures in the report that i run?

3 Answers   Wipro,

Why do we need metrics and sets?

1 Answers  

Can we get the data from two different databasess in reporting level?

1 Answers   Infotech,

What is the Drill filter and it's usage?

2 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 ?

2 Answers   TCS,

what are the differences between web intelligence reports and crystal reports ?

3 Answers   AG Technologies,

date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2

1 Answers   Honeywell,

Tell me the difference between cmc and cms?

4 Answers   Wipro,

1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

0 Answers   PWC,

What are the traps ? What are the disadvantages of traps?

5 Answers   Wipro,

Hi, difference between loop and trap in business objects ? Thanks in Advance nvsraghu

2 Answers   Infosys,

Hi All, I have found out this site very interesting and knowledge sharing site.I was wondering if you can tell me where I can get study materials for the BO XI 3.1 or suggest me the one that you have taken recently. Regards, Ace

1 Answers  

For more Business Objects Interview Questions Click Here
Categories