I create my date dimensions manually, but my hunch is the wizard will not help you at this point. You will need a script to add the date values....

Access is my friend. That said, however, I have no idea why Microsoft chose to dump all the security features Access used to have. That probably contributed to...

The Named Sets in SSAS isn't quite like the named Sets in MDX. In SSAS, the use seems to me to be limited to listing dimension members, not creating...

Not sure if this is a clue, but almost every time the backup takes a long time or doesn't start, the transaction log backup immediately preceeding it takes a long...

It turned out the crawler and backup were occuring at the same time. Moving them apart by three hours still does not provide a consistently smooth backup process. ...

I always have an unknown in a dimension, and it's key is 0. Then the sql statements can be COALESCE(value, 0). Most of the time using 0 is...

I agree. If the information is there, it must be valuable...

It's not insane to use stored...

This has stymied me for some time as well. Based on the question, I took a relook. There are only two things required, as I found in Designing...

Ein Log muss immer geschrieben werden.

I'm not validating the answer, just putting it in the correct syntax. Computer translations only go so far.

I don't know that it's common at all, but more details would be helpful. You could consider seperate dimensions or maybe even a...

If you are using Standard edition, you can't use partitions. If you are using Enterprise edition, I would suggest breaking out your data into partitions. You can refresh...

I think the answer can be both. Although I would normally associate those items with a dimension, it could be possible depending on the business processes that they would...

Agree completely. If you're not sure where to put it, you need to read up on warehouse design. ...

Thanks for the clarification. You think someone would have solved that already (unlike the active/inactive parents problem, I haven't had to solve overlapping dates). If no one posts...