what is tuning of business reports ?
Answer Posted / v.sivakumar
To add some with the before answers
Avoid Using objects from dreived tables.
Reduce the joins in the query.
Create index in the database level.
Apply the filter Properly as per the logic
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain in detail about type 2(scd),
What is the difference between absolute and relative div positioning?
Explain difference between zabo and webi?
When we use aggregate awareness function in designer?
What we need to discuss with designer before starting the universe designing.
How we drill up week to month?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Explain what task is 98% of the required work of a business analyst?
what will be the contents for a functional requirements specifications
Explain what are the measure objects?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
what is the difference b/w the refresh and buffered data?
How to schedule the report in b.o?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?