how to increase the perfomance in ur designer & reporting?
how to reduce the refershing time & what precations would u
take ?
Answers were Sorted based on User's Feedback
Answer / poonam tekchandani
To increase the performance in universe:
-as possile as use less number of joins
- avoid use of user objects
- use aggregate awareness
To increase the performance in reports:
- avoid use of user objects
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / 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 |
Answer / anil kumar ganga
To increase the performance in designer
1. Use as much conditions as possible
2. Use array fetch parameter
3. Limit the number of rows in Universe parameters as per
ur need
4. Resolve loops completely etc.,
To increase performance in reports:
1. Avoid usage of more variables
2. Use indexes on columns
Still more points are there, i didn't remember. Any body
can continue this post
Is This Answer Correct ? | 1 Yes | 0 No |
Explain what are the measure objects?
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
If there is no common dimension? Is it possible to combine two different dataproviders?
Explain what three things do you consider to be the most important factors for a manager?
without creating the business view is there possible to create & generate the Crystal reports?
what is report tracing in bo
can i use stored procedure in webi?
why measure objects are semantically dynamic?
How do you restrict access to rows of a database?
Aliases and Contexts Which once will give the better performence when resolve the loops?
WHAT IS THE DIFFERENCE BETWEEN OLAP AND DATAWAREHOUSE? WHAT IS MICROCUBE EXACTLY?
When we use aggregate awareness function in designer?