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
- 8638 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
Explain what is the difference between business requirement document and use case document.
Explain when we use aggregate awareness function in designer?
Explain which versions are used in the bo dashboard work?
What is difference between custom hierarchy and report based hierarchy?
what is universe null
Explain what sort of existing documents should business analysts refer to when starting on a new project?
can anybody tell me about complicated object you have created
Explain the data types present in bo and what happens if we implement view in the designer and report?
What is Indexing? how did u implement indexing?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Did you face any problems while creating reports? Name? Solutions?
Explain the difference between detect alias and detect context?
Explain the difference between union and group?
What sort of existing documents should business analysts refer to when starting on a new project?
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...
