Nightly processing of OLAP cubes...

[ppiazza]

I am somewhat new to the world of OLAP and hopefully someone here can point me in the right direction...

Our ERP system has a method for creating OLAP cubes on a SQL 7.0/OLAP server using our enterprise data. I need a way to automatically process the cubes at night so all of the sales data is updated. I've done this on a SQL 2000 setup using DTS, but 7.0 does not seem to have the same DTS components for processing cubes.

Any help would be greatly appreciated!

Regards,
Phil Piazza

 

[issahar]

Dear Phil.

7.0 has the DTS Components for processing cubes
if you don't have them - you should run the DTSTasks.exe of the Service Pack 3 of the OLAP 7. (I am pretty sure that this will fix your problem)

please, notify me if it helped you.
Thanks

Issahar
senior software engineer

http://www.softwatch.com

 

[ppiazza]

Thank you for your response. That's just what I needed!

Regards,
Phil