how to increase the perfomance in ur designer & reporting?
how to reduce the refershing time & what precations would u
take ?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1917


What is the difference between user and versatile user?

753


What is the profile and package?

2052


Explain what three things do you consider to be the most important factors for a manager?

742


How to execute the plsql procedure from the report by clicking with mouse?

796


What is package in BO

2908


How to generate the report from excel sheet?

825


Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

1754


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1670


can anybody tell me about complicated object you have created

2944


Which versions are used in the bo dashboard work?

764


How to create Index to the table in the universe designer and how it improves the Query performence

2318


Explain is there any other repository domains rather than universe, security, document?

750


how to create reports on screech?

2254


What would you consider as your biggest achievement and why?

786