If I have a fact table with a geography dimension where zip code is the primary key in the dimension table and the foreign key in the fact table, is there a way to create a cube where the leaf level in the geography dimension is at a higher level, say City
(or State), even if City (or State) is not an attribute on the fact table?
Alternately, if I have a fact table with dates but I only want monthly summary data in my SSAS cube, is there a way to make the Month level the leaf level member of the Time dimension in the cube without adding a Month foreign key column to the fact table?
It would seem to me that people would want to do this wiht some frequency; however, I can't find a way to do it in the SSAS documentation. This link seems to suggest that the grain of the cube has to be basically the same as the grain of the fact table
in all cases: http://msdn.microsoft.com/en-us/library/ms166573.aspx
View Complete Post