dinsdag 2 maart 2010

Fact dimension in SSAS

Today i wanted to see some degenerated dimension information in my cube in SSAS (2008). After trying some options in SSAS things were not going as planned. After a while I found out that Microsoft calls degenerated dimensions fact dimensions. In an article on MSDN it’s further explained (http://msdn.microsoft.com/en-us/library/ms175669.aspx)



Fact dimensions are standard dimensions, not based on a physical dimension table but on the physical table of the fact. In this Fact dimension you can insert attributes that are not measures but descriptive fields.

In the above example SalesOrderNumber and SalesOrderLineNumber are the Fact dimension keys and the degenerated dimensions are CarrierTrackingNumber and CustomerPONumber.

Greetz,
Hennie

Geen opmerkingen:

Een reactie posten