how to improve the performance of the report

Answer Posted / vams_gk

to inprove the performence of the reports we have multiplw
ways in my view. for example

1)generate LOV for required objects
2)use aggregate tables in universe design
3)use pre defined conditions and formulas.
4)check context (if there resolve it)
5)check loops (if there resolve it through alias table)


if u did u all these at universe level,when u generate the
report at query panel level automatically performence will
increese

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the profile and package?

1767


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...

1628


Explain which versions are used in the bo dashboard work?

635


What are the join problems comes appart from loop,chasm & fan Traps

1556


Explain what are the measure objects?

553






What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2404


1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?

5978


Explain the difference between detect alias and detect context?

629


How would you format some text using css to be verdana and bold?

674


how to create metric universe ?

1899


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:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3289


Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

635


IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY

9441


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3847


Can we create universe with no cache??

1960