That is what I saw as well. You have to write is like an openrowset() type query I think. Inside that you would have your MDX. I like QlikView as...

Thanks for the 2012 question. More please! 🙂

Ah, I can see where the structure would work better for QlikView. Since it has it's own processing engine that builds a cube in memory (more or less). I did...

I'm introverted as well which is why I like the idea of the birds of a feather sessions where you get to discuss issues with people who are dealing with...

Another oldie but a goodie. SSRS has changed enough that I had to dust off the cobwebs to remember this one.

Oldie but a goodie.

Had to guess the author's intent on this one. Glad I guessed right!

Nice question, thanks!

Steve Jones - SSC Editor (11/28/2012)

Simon E Doubt (11/28/2012)

I do think there is a lot of value in networking as well, so this might not be the best approach for...

Well this is the first time that I have noticed the disconnect so that shows how important it is to me! 😀 Thanks for the insight Steve.

It is...

It's an interesting design but goes against everything I have seen in my BI/Data Warehousing studies. I am half tempted to design a similar schema just to see what happens....

+ 1 on being confused.

richardkeithmoss (11/27/2012)

For reference, the system is using SQL Server 2008 R2 and the method in question basically uses a separate table to store measure names, while the fact table holds...

Thanks for making mention of Simon's adventure. After reading day 1 of his OLAP Sprint, I mentioned to my boss how it would be nice to go to PASS with...