Post reply

How to create a hierarchy in a snow flake schema

  • December 10, 2009 at 4:22 am

    #213306

    I've a fact table and this fact table is linked to 3 dimension tables(Snow flake).

    Now i want to create a hierarchy in my SSAS cube from these three dimensions and making fact table as an intermediate table.

    For Eg: Product, Product subcategory, Product Category are the dimension tables and Sales is the Fact table.

    I want to crate hierarchy like this,

    Product Category

    --> Product Subcategory

    --> Product

    Is it possible to create a hierarchy from three different dimensions(create a hierarchy in a snow flake schema)?

    If so, please help me how to create this.

    Thanks,

    Ramu

    Ramu
    No Dream Is Too Big....!

  • December 10, 2009 at 8:24 am

    #1090596

    This thread might offer some assistance -

    http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/dd633c5e-fdb4-449b-a445-c13abcd6db24/[/url]

    Tommy

    Follow @sqlscribe

  • December 10, 2009 at 10:47 pm

    #1090996

    Thanks Tommy Bollhofer,

    From the link you provided, i've understand that we can not create Hierarchy directly from different dimensions which linked via a Fact table.

    But if we could create a named query then that'll help us to create a hierarchy, is that correct?

    Ramu

    Ramu
    No Dream Is Too Big....!

  • December 11, 2009 at 3:35 pm

    #1091449

    NP - Correct 🙂

    Tommy

    Follow @sqlscribe

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

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