22/02/2010 4:04:45 AM
Presenting for us this month is Geoff Orr with a presentation called ‘MDX for SQL Dudes’. Geoff describes his presentation as follows;
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.
Some info about Geoff;
Geoff Orr 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.
This month we have 2 give away prizes for lucky attendees that fill out an evaluation form;
- Microsoft SQL Server 2008 MDX Step by Step which was kindly donated by O’Reilly Publications.
- Windows 7 Ultimate Edition 64 bit courtesy of Microsoft User Group Support Services.
Venue: Excom Education, Level 2, 33-35 Ainslie Place, Canberra City, ACT, 2601 (Map) |
Duration Networking from 17:30 for an 18:00 start |
On: Tuesday, 2 March 2010