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
- 8503 Views
- TCS, I also Faced
- E-Mail Answers
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 |
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
Can more than 1 metric be applied on an analytic in business objects?
HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
i want to take a report 10 records per page. How to take it? is there any paging option in BO?
What are @FUNCTION?
Can we add our own component in Xcelcius ,I am having a Indian client and I want to either create or import component (map) is it possible?? Currently I have imported Map image and working through icons is there any other way out??Please help.
What is a join? Explain different types of joins?
What task is 98% of the required work of a business analyst?
what is difference between WEBi Report and Crystal Report?
3 Answers Cognos, Nucleus Software, Red Cross,
How to implement LDAP authentication in BOE
Can anybody tell me what are the tuning problems?
If any one Deleted the BOMain key by accidently,is any possible to get back that Bomain key.if possible please send some steps.
Teradata 
