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 ?
- 3 Answers
- 7072 Views
- I also Faced
- E-Mail Answers
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
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 ?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
how to prepare the documentation in business objects and where to get the requirement?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
What are all difference between business objects 6.5 and xi r2?
Explain what is the difference between business requirement document and use case document.
How to restrict password to a user while sending a document in .pdf format
Differences between business objects and web intelligence reports?
Can Bo generates the Report from the cubical data Explain?
What is a bo repository?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
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?
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
Explain about alerts in bos, under what situation we need to use alerts?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
