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
- 7191 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 are the tables used in health care domain project and columns used in report?
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?
Explain what are the steps to do to use alerts in bo?
What is difference between webi and infoview?
What is difference between custom hierarchy and report based hierarchy?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
What Is Snow Flake Schema?
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 is report template in b.o?
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
What is the difference between slice and dice and cross tab report?
what will be the contents for a functional requirements specifications
In banking domain how many Fact tables,Dimension table are present?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How to create Index to the table in the universe designer and how it improves the Query performence
