I am using Visual Studio 2008 Analysis Services to create and process a cube, using the AdventureWorks database uploaded to SQL Server 2008. I first create the cube, using FactInternetSales as the measure. The cube automatically creates a time dimension called DimTime and links them to due date, order date, and ship date. I created a hierarchy on the DimTIme dimension -- year, quarter, etc. --, but my attempts to filter on one of these fields have no effect. I appear to be doing something wrong.
According to the dimension usage screen, the Order, Ship, and Due dates show as being linked to the TimeKey field in DimTime. Is "Regular" the appropriate type of relationship for these fields? Since the FactInternetSales table links to DimTime, should this relationship, instead, be "Referenced"?
I've generated this cube several times, and I've never gotten this to work, and I'm a bit unclear as to the meaning of the different relationship types. Your suggestions are very much appreciated. Thank you, ~Peter Ferber