locked
Deleted RRS feed

Answers

  • Arnoud -

    One way to accomplish this would be to flatten your snowflake (product group) into the product table.  You can accomplish this in your product table source query or via a calculated column in the product dimension using a RELATED lookup.  By doing this, you make the model simpler and the reference to group is direct from fact to dimension.  This assumes the product to group relationship is many-to-one (a given product roles up to one and only one group).

    Hope that helps.


    Brent Greenwood, MS, MCITP, CBIP
    // Please mark correct answers and helpful posts //
    http://brentgreenwood.blogspot.com

    Saturday, January 28, 2012 10:02 PM
    Answerer

All replies

  • Arnoud -

    One way to accomplish this would be to flatten your snowflake (product group) into the product table.  You can accomplish this in your product table source query or via a calculated column in the product dimension using a RELATED lookup.  By doing this, you make the model simpler and the reference to group is direct from fact to dimension.  This assumes the product to group relationship is many-to-one (a given product roles up to one and only one group).

    Hope that helps.


    Brent Greenwood, MS, MCITP, CBIP
    // Please mark correct answers and helpful posts //
    http://brentgreenwood.blogspot.com

    Saturday, January 28, 2012 10:02 PM
    Answerer
  • define your measure as Calculate(SumX(facts, fact[sales]), All(facts), Summarize(Product, ProductGroup[ProductGroupId]))

     

    • Proposed as answer by Challen Fu Tuesday, January 31, 2012 7:11 AM
    Sunday, January 29, 2012 6:21 AM
  • Deleted
    Friday, February 3, 2012 4:58 PM