Post reply

Table design for cube with time-product-based structure

  • May 10, 2009 at 7:24 pm

    #209379

    HI,

    I'm new to SSAS and I'm trying to build a cube. The issue I'm running into is that I have 1 Table with the following columns ProdLevel1|ProdLevel2|Year|Month|Amount. From experimenting, SSAS will not allow fact and dimension columns in one table. So now i'm trying to split this information into 3 tables. I've decided on dimProduct Table, dimTime Table and factAmounts. The problem is that my ProdLevel dimension are based on Time, eg in Year 2005 ProdLevel1 was different in Year 2006. Would I need to create a 4th table? (ie. TimeProduct?)

  • May 11, 2009 at 10:14 am

    #992285

    Are you saying that for the same product, it is different depending on the year?

    if so, then you might want to look into how to manage slowly changing dimensions.

    If the product is only good for a year, and its product id is never reused, then the year of availablity is in effect an attribute, so you can dimension it.

    The more you are prepared, the less you need it.

  • May 11, 2009 at 4:03 pm

    #992521

    Great ! Thank you.

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

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