Posted by russzee on 07/03/07 08:01

Hello,

Can I import an OLTP (Reltional DB) as a Data Source into SQL Server
Analysis Services 2005 and then use the Cube Wizard and the new Data
Source View feature to create the OLAP model ?

Or do I have to first design an OLAP Data Warehouse with a Star Schema
and then import this DW as a Data Source into my Analysis Services
Project.

With SQL Server 2000 , OLAP would be the way to go..but with SQL
Server 2005 , it seems as though the wizard and data source view
features do half the work for you.

I have an OLTP DB and am not sure which route I should take ! Any
suggestions / input would be much appreciated.

Thanks in Advance...

Regards
Russzee

• Next in forum: Re: Dynamic Query
• Prev in forum: How to use function based index in SQL Server2005?
• Thread view: OLTP vs OLAP (Data Warehouse) as a DataSource in Analysis Services 2005

[Reply to this message]