How to build cubes from Oracle database?

Hi, can anyone show me the steps to use SQL Server

to perform OLAP analysis for data from Oracle relational database?

Thanks,

Chris

Do you already have a dimensional model (fact and dimension tables) set up in your Oracle database?

Bryan

|||

Bryan C. Smith wrote:

Do you already have a dimensional model (fact and dimension tables) set up in your Oracle database?

Bryan

Not yet.

Should I build the dimensional model in SQL Server or Oracle, and how?

Is there any document to show the steps?

Thanks,

Chris

|||

Traditionally, the OLAP database/cube exists as a cached layer on top of a series of fact and dimension tables (referred to as a dimensional model) in a relational database. SSAS 2005 can support dimensional models built in both Oracle and SQL Server (as well as other relational database technologies).

Technically speaking, you can skip the implementation of the dimensional model in the relational database. You do this by assembling sets in the DSV of your cube through named queries. Some folks with smaller data marts have successfully pulled this off, but it is not recommended.

If you are new to dimensional modeling, I highly recommend Ralph Kimball's "The Data Warehouse Toolkit". It will give you a solid foundation in this stuff and SSAS 2005 is aligned with the design principle he expouses.

Good luck,
Bryan

|||I agree that this is a good book to start with. You can also try the tutorial included with SQL Server Anlaysis Services 2005. All the same concepts apply regardless of whether your getting your data from a SQL Server relational database or an Oracle relational database. The only difference will be whithin the Data Source object which abstracts the connection to the source data.