Good luck! I taught myself OLAP by taking a simplified copy of an existing relational database and reformatting everything to a more dimensional model. Even with a book on OLAP...

i remembered using sp_configure to enable this in 2008 R2 and was happy to see that it was the same in 2012.

This question wasn't as difficult as I first thought. It does help that I have used partitioning a few times though. Happy Friday all!

I always proofread and check my emails for tone before sending. If something is emotionally charged then I will either save it as a draft for a couple hours to...

Thank you, thank you, thank you!

I have looked over so many books and sites that try to teach MDX and none have simplified it like this article.

For some...

paul.knibbs (11/1/2012)

That's pretty much what I did, but I did it in my head rather than...

Nice question, thanks.

nice easy one for a Friday. Thanks!

I actually thought the load would fail when trying to create a duplicate FK so I chose none of the above. I then ran the code on a test db...

Interesting function. Not sure when I would use it but good to know anyways. Thanks for the question!

Nice question, thanks.

Nice question. Thanks!

Good question on basics. Thanks!

Nice question. I was looking for a catch (no pun intended) but it was just a good question on the basics. Thanks!

Thanks for the question!