converting oltp database into dimension model (olap) database

• sej2008

  SSCarpal Tunnel

  Points: 4495

  More actions

  May 1, 2013 at 5:41 am

  #144402

  I work on ssas using adventureworksDW2008 database for creting cube and understanding other features but if I want to convert my oltp database such as Northwind database where data is in relational model(customers,products,orders tables)what exactly is the way I can do it.

  Is there any mechanism that directly table will be converted to fact and dimension tables.

  What I want is a way to convert OLTP Data into OLAp data for creating cubes.

  I do not want to work on ready database like adventureworksDW2008.

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  May 1, 2013 at 9:48 am

  #1611629

  sej2008 (5/1/2013)

  ---

  I work on ssas using adventureworksDW2008 database for creting cube and understanding other features but if I want to convert my oltp database such as Northwind database where data is in relational model(customers,products,orders tables)what exactly is the way I can do it.

  Is there any mechanism that directly table will be converted to fact and dimension tables.

  What I want is a way to convert OLTP Data into OLAP data for creating cubes.

  I do not want to work on ready database like adventureworksDW2008.

  It sounds like you're asking for a magic bullet that will convert a 3NF db to a dimensional model (star schema or snowflake off a star schema). I'm not aware of anything like this -- it boils down to having to do the data modeling yourself. A good book on star schema/modeling is the Kimball - 'Data Warehouse Toolkit' (the 3rd edition comes out in July). ( http://www.amazon.com/Data-Warehouse-Toolkit-Complete-Dimensional/dp/0471200247/ref=sr_1_1?s=books&ie=UTF8&qid=1367416796&sr=1-1&keywords=data+warehouse+toolkit )

  HTH,

  Rob

• sej2008

  SSCarpal Tunnel

  Points: 4495

  More actions

  May 2, 2013 at 12:10 am

  #1611795

  :-)No I was not asking for any magic Bullet,I wanted to understand from scratch(the data itself)May be that was Data modelling which I was not aware.

  Thanks