how to increase the perfomance in ur designer & reporting?
how to reduce the refershing time & what precations would u
take ?
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 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)?
Explain the difference between detect alias and detect context?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Difference between zabo and webi?
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?
How to create Index to the table in the universe designer and how it improves the Query performence
What is the difference between slice and dice and cross tab report?
When we use aggregate awareness function in designer?
Explain when to use local filter and when to use global filter?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
How to open a universe with out using the Designer ??
Explain the data types present in bo and what happens if we implement view in the designer and report?
Difference between b.o 5.1 and 6.1b?
What three things do you consider to be the most important factors for a manager?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message