Gotcha. Thanks very much for clarifying that.

Steve, thank you for your clarification. It helped me understand what is happening here. Maybe I will use data mining after all. The interesting thing here is that it's so...

Steve, thank you very much for your response. What I'd like to understand from your response is more about what fact records will show when you use one role play...

Hi guys. Well, I've tried the approach above, adding a copy of the dimension to the cube and setting it's relation to another key in my fact table. But when...

Are you using Access to do this? Is there a SQL Server back end? You could persist the calculated column by performing the calculations in a stored procedure and...

You are right on the mark SSCommitted. The breadth and depth of knowledge that the author's DBA is supposed to have mastered is almost ridiculous. If someone has this "ideal...

Chris's point is dead on. In a data warehouse environment, this is the proper way to handle dates. However, usually you store the actual date as well as the date...