Tuesday, December 18, 2018
Task Pane 
Remember Me
Our Sponsors
Current Poll
SQL Server 2008
Are you ready for the upcoming SQL Server 2008 release?

[show results]
MDX for the SQL guy (Geoff Orr)
Author: Grant Paisley Date Posted: 1/25/2010 11:40:23 AM
Here is the blurb used by Rob in Adelaide.

If your brain is wired for Transact-SQL and you're looking for a quick and dirty introduction to the weird and wonderful world of Multi-Dimensional eXpressions then this is the session for you. The syntax looks similar to SQL but does not work the same way. Cubes have far more metadata & MDX takes advantage of that. The session commences with an explanation of the basic concepts and principles underpinning the MDX language, contrasts it with TSQL and then proceeds to describe and demonstrate key syntax, MDX queries and some MDX scripting.

Key Topics:
* Dimensions,
* Measure Groups and Members,
* How to do a join,
* How to add a condition,
* Where vs Filters.
* Perspectives,
* Accessing Properties,
* A few must know functions.

Geoff Orr of Angry Koala is an MCAD with over 20 years experience in IT in Australia and the UK. Geoff works in Database, Development and Business Intelligence. He has worked on systems as diverse as government grants, logistics, finance and even rubbish trucks. Geoff believes that data has its own story and loves databases. Geoff has previously worked for Microsoft in Premier Support for SQL Server.

Venue: Mechanics' School of Arts, Level 1, 280 Pitt St, Sydney | Duration 5:30PM Networking (Pizza & Drinks provided) | 6:00PM - 8:00PM Session | On: Tuesday, February 9, 2010