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. what is the purpose of creation of universe than other
data sources ?
2. which is the best method in performance tuning techniques ?

Answer Posted / babu

Universe creation in other data source is to get more info
or which not possible in the same universe like(more than 2
fact tables ) in the way we can go for more than one data
source.

Performence tuning :
Universe level
1.universe should be Indexed on key columns
2.Increase Array fetch size.
3.Make short cut joins
4.Delete unnessory joins.
5.Use less no of Aliases
6.Use less Outer joins
Query Level:
1.Disable LoV for measure objects
2.Create filters(condition objects) at universe level
Report level
1.Create less no of variables
2.create comoplex logic in D/B level.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the data types present in bo? What happens if we implement view in the designer and report?

1015


how to prepare the documentation in business objects and where to get the requirement?

2203


Is there any other repository domains rather than universe, security, document?

1039


Can more than 1 metric be applied on an analytic in business objects?

2141


any difficulitis have you phase while creating bo reports and how did u solve it

3432


8. How much supervision have you typically received in your previous job?

2240


Explain about a tricky situation for which you found a very simple solution?

986


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

1116


How were the reports scheduled and how to resolve unexecuted documents?

2655


Difference between b.o 5.1 and 6.1b?

1230


What is the difference between user and versatile user?

1055


Can we create universe with no cache??

2490


What Is The Difference Between Oltp And Olap?

1102


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3818


what is the difference b/w the refresh and buffered data?

2320