Print Page - Transformer cubes are taking more time to execute than usual

Title: Transformer cubes are taking more time to execute than usual
Post by: Chitra_Maithani on 09 Dec 2014 10:52:44 AM

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

Title: Re: Transformer cubes are taking more time to execute than usual
Post by: faouzis on 05 Jan 2015 01:45:04 PM

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

Title: Re: Transformer cubes are taking more time to execute than usual
Post by: nybble on 13 Feb 2015 03:59:45 PM

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).

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: Chitra_Maithani on 09 Dec 2014 10:52:44 AM