How to design OLAP dataware house from OLTP


  • Hi,

    See in my organization used an OLTP data warehouse for SSRS reports,

    now my manager asked to use SSAS cubes for SSRS reports instead of OLTP database.

    see, my questions are

    1.In My organizations all the tables have OLTP contain many tables

    2.So How will i change the all tables(OLTP) make it as OLAP data warehouse?

    How do change OLTP to OLAP data warehouse?

    Can anyone explain me briefly?

    Monday, August 12, 2013 10:36 AM


All replies

  • You should get a book called 'The Data Warehouse Toolkit' by Ralph Kimball. 

    Data Warehousing is a huge topic. I'd suggest doing some reading around the internet to get an idea of what it is. It isn't something that can be explained briefly as per your request, I'm afraid. 

    For your reference, the SQL Server samples projects on Codeplex contain a sample data warehouse and OLAP cube project over the AdventureWorks OLTP database. Looking at that project might give you an idea of what is involved.

    Thanks! Josh

    Monday, August 12, 2013 10:58 AM
  • Hi Josh,

    Thanks for your reply,

    Please let me know am asking silly question,

    who do design the OLAP data warehouse,Eighter SSAS developer or database architecture?

    please tell me

    Monday, August 12, 2013 11:14 AM
  • Data Warehousing is done in the database but most SSAS developers can model data warehouses. 

    Your mileage may vary.. 

    Thanks! Josh

    Monday, August 12, 2013 11:17 AM