I have created one report, it contains only 3 dimensions and one measure. The details are also very less.
My DB and check integrity functions also perfectly ok. But it is very slow?
How to do increse the performance?.
Thangavel,
There are lot of things to do to increase performance… May be at database, report,network,server configuration,client configuration like that like that…
If the same query directly at database is slow, consider tuning database/tables at database level. (May be like Indexing, Partitioning or something).
If you use 6.5 , try to implement index awareness with Primary key.
If the one measure you indicated is a “summable” measure, consider the SQL statement of the measure object to be SUM().
If you give us more info we may be able to help further…
What DB are you using?
What middleware are you using?
2 or 3 tier deployment?
Type of DB schema?
Row count?
Time difference BO and your DB SQL editor?
version of BO?
Deployment locations - are all the boxes in one room together?
Remember that integrity checks only look for things that cause errors. They have no bearing on performance.
The first thing to determine is if the SQL statement is taking a long time to return or if the report is taking a long time to perform calculations on the data that is returned. The easiest way to check is to look under Data>View Data. On the definion tab, check the Duration. This does not always pin point the problem, but it is where I always start.
I also have a document about performance on my web site listed below. I maintain it for my personal use, but feel free to look at it.