Is SSAS a new version product or it is a upgrade version of SQL Server analysis services 200

Hi, all here,

I am having a question about SQL Server 2005 Analysis Services. Is it a new version product or it is a upgrade version of SQL Server 2000 analysis services?

Thanks a lot in advance for any guidance and advices for that.

With best regards,

Yours sincerely,

It is a new OLAP and data mining engine.

There are some upgrading issues especially regarding dimensions. In AS 2005 everything was about hierarchies but in AS 2005 a dimension consists of attribute hierarchies(flat hierarchies) and user hierarchies(the old AS2000 version of dimensions)

A virtual cube is the same as a cube in AS2005. Measure groups is the same(almost) as the AS2000 physical cubes.

Some changes in MDX have also appeared.

Have a look at www.microsoft.com/sql for more information.

Regards

Thomas Ivarsson

|||

Hi, Thomas, thanks a lot for your kind guidance.

With best regards,

Yours sincerely,