Interested to Buy Any Domain ? << Click Here >> for more details...
how to increase the perfomance in ur designer & reporting?
how to reduce the refershing time & what precations would u
take ?
- 3 Answers
- 8504 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ashish
1. Increase array fetch size.
2. Use Bit map indexing on Fact columns.
3. Remove unwanted objects and classes from your universe.
4. Remove unwanted variables, filters and charts from report
5. Always ensure your fact table execute before your
dimensional table in the FROM clause (Query optimization)
ex. Select F1.A
D1.B
FROM
Fact F1,
Dim D1
6. Use of Derived Tables so that complex calculation can be
performed at universe level.
7. Aggregate table
8. Remove unwanted alias and context.
9. Always ensure in join condition you have fact table
appearing at LHS. (F1.A=D1.B)
10. For prompts related columns, have indexing done at DB
level
11. Also at universe level you can change row count for
table rows for SQL execution as per requirements.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is the difference between datawarehousing and businessintelligence?
What is a bo repository?
How to generate the report from excel sheet?
How many universes can be created in a project?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Can we configure two instances of CMS pointing to two different CMS system databases?
Explain what three things do you consider to be the most important factors for a manager?
Explain the difference between detect alias and detect context?
What sort of existing documents should business analysts refer to when starting on a new project?
Can more than 1 metric be applied on an analytic in business objects?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
how to prepare the documentation in business objects and where to get the requirement?
what are the day to day activities of BO administrator ?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
