I'm using SQL 2008 standarrd. Probably a simple question,
But I want to creata a calculated measure in a cube that always displays a measure(e.g. total sales) on the year level of the Date-dimension-hierachy.
So wether I choose Year, Quarter, Month or Day, it always shows the measure value (sales) on the Year level. How to do that?
View Complete Post