MS SQL Server OLAP - MDX Scripting

Author

MDX Scripting

KoryS

2005-09-18, 8:23 pm

Is there any good source for MDX scripting in SQL 2005 (besides BOL)?

Chris Webb

2005-09-19, 9:23 am

Richard Tkachuk's site at
http://www. sqlserveranalysisser and Mosha's blog
(http://www.sqljunkies.com/WebLog/mosha/) have some examples, but nothing
like a proper introduction. The MSDN whitepaper at
http://msdn.microsoft.com/sql/defau.../IMDXSMSS05.asp
is probably the best place to start but is out of date in at least one
important respect - attribute hierarchies in the September CTP work in a much
more intuitive fashion.

<Shameless plug>
Otherwise, place your order for the second edition of 'MDX Solutions':
http://www.amazon.co.uk/exec/obidos...2192185-2564434
which has a chapter on the subject.
</Shameless plug>

Chris

--
Blog at:
http://spaces.msn.com/members/cwebbbi/

"KoryS" wrote:

> Is there any good source for MDX scripting in SQL 2005 (besides BOL)?
>
>

grahamiec

2005-09-19, 11:23 am

I use the free Excel 2002/2003 Plugin for Analysis Services. It let's
you create pivot tables and other OLAP views, and then view the MDX
query that generated the view.

KoryS

2005-09-20, 7:23 am

Thanks Chris, I probably will get this book when comes out. Was a
single chapter enough to cover the topic of MDX scripting?

Chris Webb

2005-09-20, 9:23 am

It's a big chapter! To be honest, our intention for this edition was only to
provide an introduction to the subject - in future editions I would imagine
that we'd need two or three chapters to do it justice.
--
Blog at:
http://spaces.msn.com/members/cwebbbi/

"KoryS" wrote:

> Thanks Chris, I probably will get this book when comes out. Was a
> single chapter enough to cover the topic of MDX scripting?
>
>

Sponsored Links