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
- 6906 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
What is the difference between the public object&schema object?
What is the dense rank?
Explain about a time when you discovered a more efficient way to do a work task?
What is the difference between user and versatile user?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain the difference between union and group?
What are the join problems comes appart from loop,chasm & fan Traps
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
what are the tables used in health care domain project and columns used in report?
can anybody tell me about complicated object you have created
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
Which versions are used in the bo dashboard work?
Which command using Query Analyzer will give you the version of SQL server and operating system ?
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)?
What are the steps to be taken to schedule the report?
