Author Topic: Cube build time increased drastically  (Read 1159 times)

Offline hankler

  • Full Member
  • ***
  • Join Date: Dec 2016
  • Posts: 5
  • Forum Citizenship: +0/-0
Cube build time increased drastically
« on: 13 Sep 2019 01:11:46 pm »
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

Offline Francis aka khayman

  • Statesman
  • ******
  • Join Date: Jun 2009
  • Posts: 518
  • Forum Citizenship: +25/-4
    • CognosM
Re: Cube build time increased drastically
« Reply #1 on: 16 Sep 2019 02:28:28 pm »
indexes from tables in the database were removed or got messed up?

 


       
Twittear