Post reply

OLAP Design Process: From the Datamart to the Dim/Fact Tables

  • October 15, 2008 at 9:38 am

    #214121

    Hello guys,

    i am still not sure about this issue:

    Does SQL Server 2008 provide any wizards to create the dim and fact tables that i need for the olap cube?

    I mean i have a datamart with some tables. The question is now do i have to take care that i produce some suitable dim and fact tables during the ssis process (by creating tables and manupulating data via sql) OR is there any wizard that supports me here?

    Thanks for any help.

    Regards

    John

  • October 16, 2008 at 4:13 am

    #885709

    Let me explain my problem in more detail:

    I have all the data i need in one big table (time, shop, sold products, ...) like this:

    TIMESTAMP shop1 1

    TIMESTAMP shop2 1

    ....

    To build the dim and fact tables i have to create one time dimension table and one shop dimension talbe. then i have to create the fact table. That will look like this:

    Dimension Time

    ID Day1

    ID Day2

    ...

    Dimension Shop

    ID Shop1

    ID Shop2

    ..

    Fact Table

    IDShop - IDTime - Soldproducts

    1 - 1 - 4

    1 - 2 - 3

    2 - 1 - 3

    ...

    Is this the right way to build the cube or is there another - easier - way to handle this?

    Regards

  • October 17, 2008 at 6:57 am

    #886322

    That seems the best way to me. Did you intentionally miss out the "Dimension Product" and measures/ Values.

    There are wizards that help you build cubes and dimensions but in my opinion they are not that great but could help you start out.

    some good resource are (in no particular order) http://channel9.msdn.com/

    http://www.jumpstarttv.com/

    and http://www.learnmicrosoftbi.com/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply