Thank you for your help 🙂
I was basically thinking that i had to ignore completely the Date dimension and i thought you would have to analyze the full table and not for a single date.
Thank you again.
gmontanaro (10/22/2014)
Semi-Additive means that it makes sense to sum it by some dimensions, but not all.In your case, summing Products over multiple dates makes no sense, but summing by Store for a single date does.
ProductStoreDateStock
ALX01-01-201410
ASF01-01-20145
ANY01-01-20147
ALX02-01-201412
ASF02-01-20146
ANY02-01-20147
SELECTProduct
,SUM(Stock) StockLevel
FROMFactSales
GROUP BYProduct
WHEREDate='1/1/2014'
StockLevel = 22