how to increase the perfomance in ur designer & reporting?
how to reduce the refershing time & what precations would u
take ?
- 3 Answers
- 7859 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
in sap bi we have wad, then why we go for sap bo
Explain how we drill up week to month?
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
What is a bo repository?
Explain when to use local filter and when to use global filter?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Is there any other repository domains rather than universe, security, document?
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?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Can we Save (save as) WEBI Doc as DESKI?
How to execute the plsql procedure from the report by clicking with mouse?
Can more than 1 metric be applied on an analytic in business objects?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
What is package in BO
