Snowflake schema: fact table with foreign key to a sub dimension?
===

Using the snowflake schema image from wikipedia:

http://en.wikipedia.org/wiki/File:Snowflake-schema-example.png

Would it ever make sense to have a "Brand_Id" foreign key in Fact_Sales as you do in Dim_Product? There is a many-to-one relationship of sales/brands just like sales/products or products/brands, so is there any logical reason not to? You may want to join directly to the Dim_Brand table.

I'm probably not seeing something obvious.

Thanks