Consider a table (tblStuff) with the following columns:
Color: red, white, blue, etc
Size: small, medium, large
Weight: light, medium, heavy
CustomerID: FK to customer table
I have built a cube with a single measure "tblStuff Count" and am able to slice the counts according to color, size and weight, etc., but I want to also slice the data by fiscal months, quarters and years. I have no idea what I'm doing ...
I think I need to create a server time dimension but have no idea how to connect it to the DateSold field in tblStuff.
Can somebody fill in the missing details, please ?