Monday, February 20, 2012

Oracle and Analysis Services

We have a world wide ERP built on top of Oracle and .net.

We have no way to change Oracle for SQL Server at this time.

But, we would like to use the Excel OLAP features.

From what we've seen, the OLAP features in Excel only work on top of SQL Server's Analysis Services.

Is this true?

Could we have Oracle and just Analysis Services installed?

What would be the cost of such a solution (could you point a price table)?

Thanks a lot.

Analysis Services is fully supported to build cubes based on the data in Oracle relatonal database.

Analysis Services is integral part of SQL Server product offering, you will need to obtain full licence for SQL Server product to run Analysis Services.

You are not required to install SQL Server relational engine on your machine. Installation of Analysis Serivces is self contained.

Pricing of the Analysis Services is standard pricing for buying a SQL Server licence: http://www.microsoft.com/sql/howtobuy/default.mspx

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

No comments:

Post a Comment