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
- 8355 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
How to generate the report from excel sheet?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
How to sort the dynamic objects alphabetically on the Universe based on and SQL Server
What is a fantrap in business objects?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
What is the difference between slice and dice and cross tab report?
What is difference between custom hierarchy and report based hierarchy?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Explain the difference between detect alias and detect context?
is it possible to export the webi reports to crystal reports?with out using businessview?
What is difference between webi and infoview?
Explain what three things do you consider to be the most important factors for a manager?
how many reports have u created ? explain a few.
What are the join problems comes appart from loop,chasm & fan Traps
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.
