building cube using AMO

hi,
i am developing an application which enables the user to create a cube on the fly. I know that i can use AMO to create a Analysis Services 2005 cube.

but my question is :

Is it possible to use AMO to create a Analysis Services 2000 cube ?

Cheers

Anil

The answer to your question is: No, you cannot use AMO to create cubes in Analysis Services 2000. There are too many differences betwee AS 2000 and AS2005. Analysis Services in version 2005 has been rebuilt almost from the groud up. The techologies and protocols used in AS2005 are new.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

I am in the process of converting a DSO and SQLServer 2000 process which programmatically creates data sources (now DS views), dimensions, and cubes to AMO and SQL Server 2005, and I've been struggling. Can anyone suggest a good book or documentation source which clearly describes the new AS object model and gives comprehesive, well explained AMO examples (preferably in VB)?

Thanks in advance.

|||how can we use AMO to build cubes on the fly?|||

Thanks for your help edward.

Cheers
Anil

|||

I suggest you guys start a new thread.

Just shorly:

To learn AMO it often better to take a look at number of AMO samples provided with SQL Server 2005 installation.

There is already abundance of information you can search for with people posting on how to use AMO.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.