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
indexes from tables in the database were removed or got messed up?