PeterFrb
asked on
Time dimension failure
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
DimensionUsagePage.bmp
DefinedRelationship.bmp
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
DimensionUsagePage.bmp
DefinedRelationship.bmp
One more note, whenever you create your time dimension, it has to have all the members included in it that your fact table needs measured.
And here's a screenshot of where you generate the members (Data Source View area is probably empty for you)
dimCalendar.bmp
And here's a screenshot of where you generate the members (Data Source View area is probably empty for you)
dimCalendar.bmp
ASKER
I think you're on to the answer, but I need more information to take effective action.
1) How do I check the definition of the time dimension?
2) How do I get the time dimension to populate data in the base table?
Please identify specific commands or properties and, if necessary, attach more images. My hierarchy looks similar to the image you provided, but I think there's a disconnect, the source of which is still mysterious to me.
Best, ~Peter
1) How do I check the definition of the time dimension?
2) How do I get the time dimension to populate data in the base table?
Please identify specific commands or properties and, if necessary, attach more images. My hierarchy looks similar to the image you provided, but I think there's a disconnect, the source of which is still mysterious to me.
Best, ~Peter
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks! Sorry to get back to you so late on this. This question fell under the radar.
That's probably where your problem is.