I didn't assert that; I only took issue with your assertion to the contrary.

Like you, I...

RAP is in the same spirit. The objective is to properly and systematically do what most programmers currently do both imporperly and inconsistently. They do these things poorly because they're...

Neither have I, so I assume that's the expected behavior....

In a typical development the schema design is done by a database guy who is obsessed with micro-optimization of individual tables. He fusses over minimizing table size and deciding things...

You don't say what version of SQL Server you are using, but your question is very broad. I would suggest googling some of the items. If you prefer...

I would refer you to Ralph Kimball's work on Date and Time dimensions, such as in The Data Warehouse Toolkit 2nd Ed. There have also been some recent articles...

BTW, rather than call the dimesion Time, call it Date or even Calendar. One day you may need to add Time, and you'll be glad you did.

I agree that the date should be an integer, but I disagree that it must be a human readable one. Human readable ones have the advantage of being readable,...

Check the sort order for that property. It's probably set to Name, which is the default. Change it to Key.

Although perhaps technically allowed, it would be better to subsitute...

SSAS should know it's an integer as long as the source field is an integer. What exactly is the issue? The order of the weeks?

Also, recommend...

This isn't the entire idea. The calculations can also be done much easier. ...

Since then I’ve realized that I should have created one of the relationships between a fact table and dimension table using two columns instead of the one column that I...

My point was not that solve order wouldn't matter. It was simply not to get hung up on that. Try the formula first. I have seen examples...

I have some very complex (at least they seem so to me) time queries in my cubes, and they don't kill performance. It is important, however, to have date...