Cognos Report Slowness issue

[YogiWagh1990]

Hello Everyone,

I have a simple list report that has so many columns and a single query and the database is DMR cubes. When I run this it will take too much time to run.

In that report, there are few data items that may have so much data in it but those are mandatory data items.

Please suggest suitable steps to resolve the slowness issue.

Kind Regards.

[cognostechie]

Hi

DMR cubes is not a database. DMR is only a definition and hence a virtual cube which restructures the data after retrieving it from the database and then sends it to the report. I have remade reports to make it run in less than 10 seconds which were taking 7 days to run earlier and in most cases found that it was the way queries were written was causing the problem. That being said there is another factor which is possible in your case. Since DMR is virtual and has to restructure the data every time the report is run, huge volume of data can cause it to become slow. It is also possible that your data is not huge and the modelling behind the scenes or the way the report is made is causing the problem. I am giving you ideas so that you can check these things because it is not possible to give you a solution with the limited information you have provided.