If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cube build time increased drastically

Started by hankler, 13 Sep 2019 01:11:46 PM

Previous topic - Next topic

hankler

Good Afternoon,
I am having an issue with a cube generation.  We've scheduled the cube update in the task manager and it has been working fine until a week ago.  The cube updated in less than 5 min, from Monday now it takes 1h 50 min approximately.  I checked the log and i noticed that "reading the data" took 1h 50 min for 67000 records, the rest of the steps were done in 1 sec.  Anybody have any idea what could be happening? The cube source is a report studio with a SQL directly to the database.

I appreciate any help.
Thanks

Francis aka khayman

indexes from tables in the database were removed or got messed up?