cancel
Showing results for 
Search instead for 
Did you mean: 

setting reports for webi(infoview)

Former Member
0 Kudos

Hi,

where can i set Report setting for improvement of performance? like i have to do setting that at a time only 10 reports can open in webi or inview not more than that.... in CMC or other places .

this type of setting where can we do..

could you please asist me where i can do this type of perfomance tuning...

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hello Kumar,

could you please clarify more your Problem. The best to get performance out of a report is the design. Keep it simply and you have better performance.

f.e. a Report with 200 Pages and 100.000 Records is not very perform cause the user maybe only takes a look at the first three pages.

Regards

-Seb.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi there are a lot of ways you can improve the performance

1. increase the array fetch from your universe

2. checking the SQL statement fo the report and add index on the table if needed (based on the where condition that you used)

3. creating partitions on your tables

4. redesign your report

you must be able to check first what is causing the performance issue.

Former Member
0 Kudos

HI All,

Thanks for reply..

but i want to know Performance improvement on user level in CMC.

like we have 100 rpoert in production server & we have 50 concurrent user ..i want to restrict at a time only 30 concurrent user can open report from Infoview not more than that....like that security seeting i require...

if it is possible then how & where i can do this .....

0 Kudos

Hi Kumar,

please do the following: Go in the CMC and select Servers. Open the Properties page of your web server (highlight it and invoke the context menue using the right mouse button). You can set the value of Maximum connections to 30. This way your webi server can serve up to 30 request at the same time. Please keep in mind, that a conneciton will remain open after a report is opened and will be closed only if the relevant timeout expires (Check the Idle Connection Timeout setting on your WebI Server, default value is 20 minutes). You can try to reduce the Idle Connection timeout in order to get the connections be released in time and let new connections be created.

I hope this helps.

Regards,

Stratos

kalpesh_pandey
Contributor
0 Kudos

I agree with above post. Make sure you have total of those connection. So in case you have cluster and have webi servers in 2 machine so effectively you have 2 webi servers so make setting of 15 on both.

Thanks,

0 Kudos

Hi,

normally a single WebI server can serve up to 50 connections. Since the server is multi-threaded you do not have to create two instances unless you want to have a fail-over setup.

Please also keep in mind to consider the performance issue when you design your reports. Badly-designed reports can cuse performance problems in your system even when you open just few of them at the same time.

Regards,

Stratos

Edited by: Efstratios Karaivazoglou on Jul 17, 2009 8:27 PM

Edited by: Efstratios Karaivazoglou on Jul 17, 2009 8:30 PM

Former Member
0 Kudos

Thanks all i got what i require