Transformer cubes are taking more time to execute than usual

[Chitra_Maithani]

Hi,
I am facing issues with execution time for my cognos cubes since last 10 days. Its taking more time than usual.Cube which was taking 3-4 hrs to execute ,now its taking almost 7-8 hrs.Data from source feeds are normal and same as before.
So i just want to know why this is taking more time?
And what might be the solution for this?


Thanks
Chitra

[faouzis]

Hi

When a cube is executing, it is actually running an SQL against the Data source connection. Try finding out from the RDBMS logs which SQL is taking most of the time, and execute it yourself against the database. If it is the SQL, then you might want to add index or add hint; if not then check if there is any network slowness.


Thanks
Faouzi

[nybble]

Are you talking about building a cube or executing a query against a cube?
If you have a log file compare it to one from the previous period to see where in the build it is taking longer (and to verify that about the same # of records are being fetched).