Thanks, that helps. Perhaps I should have made clear is that I'm trying to be open to the idea that in an OLAP environment typical RI constraints might not...

My biggest tip: Once you have mastered the art of the lookup transform, remove all foreign keys in your fact table. Like the author states, they are "technically right, but...

I...

There's nothing wrong with using MS Access (assuming you know it) to capture the data and then bring it into a warehouse.

There's not enough information here to give you a good suggestion for your case, particularly in terms of dimension record count. Here are some guidelines.

If you absolutely...

I would add that MDX allows you to create metrics for the cube users that take the information farther. You use it to create metrics such as percentages (eg...

If all you want are links, I would suggest that you can google for them and use Microsoft's links.

You will only be able to use SSAS if you understand dimensional...

There's not enough here to be sure, but you need to determine what business process you are trying to represent, and then what factors are relevant to it. In...

It sounds like your fact table is an accumulating snapshot. So snless the cube is split into partitions, and you can be certain that all the changes are in...

As to "usp": it is illogical. The "sp_" in system procs stands for "special". So for a proc named "usp", why is this user proc "special" from other user procs??...

If you're only doing a nightly update, I agree with the recommendation to use a simple backup.

I have several updates throughout the day, however, so I make a full backup...

Why would you never do this? I've seen dimension tables prefixed...

This...

Translations is enabled for Developer and Enterprise. You will not be able to deploy them to standard. There is a way to turn off Enterprise-only features in Developer....

While anything is possible, the uses for a snow flake schema are uncommon. ...