Currency Conversion (and Much More) in Analysis Services

Presented by: Christian Wade - EMC

Want to learn more about Analysis Services and MDX?  This session covers numerous features in Analysis Services 2005 and 2008 as well as dimension/cube design.  It is all tied together to discuss and apply the options available for currency conversion. You will leave understanding some of the nuances of Analysis Services to get the most out of your OLAP implementation.

Christian will tell us about:

• Types of Currency Conversion
• Dimensional modeling
• Many-to-many dimensions
• Time dimensions
• Semi-additive measures
• Measure expressions
• MDX query authoring and optimization
• MDX scripting
• The Business Intelligence Wizard

Who should attend?  Business Intelligence professionals, Developers, Architects, SQL Server Users

Speaker: Christian Wade is a senior consultant with EMC Consulting specializing in Microsoft BI solutions for the oil and gas sector.  He is from the UK and has been working in an oil field in the Californian desert for over 2 years (lovely!).  Whilst living in the UK, Christian was an active SQL community member.  He spoke at the PASS 2005 Community Summit in Dallas and the 2005 European PASS Conference in Munich, Germany, as well as presenting on numerous occasions at Microsoft UK Headquarters.  He has also written technical articles for SQL Server Central magazine.

RSVP  To RSVP, or for more information email Mark Ginnebaugh *Please RSVP by email before noon on the day of the meeting.

Location Meetings are held at the Microsoft Office at 835 Market Street, Suite 700, San Francisco, CA 94103.   Click here for a map 

Cost  No charge

General Agenda

6:30 to 7:00 pm - Introductions, food, networking

7:00 to 8:30 pm - Presentation and Q&A

About the User Group The San Francisco SQL Server User Group maintains a focus on database development and administration practices specifically centered around Microsoft SQL Server. Presentations include developer centric interactive sessions as well as demonstrations of related products that have been judged to have potential value or be of interest to the professional database community. The intent is also to provide a face to face forum for peer learning and networking within the context of SQL Server. Members include DBAs, application developers long experienced using SQL Server, FoxPro or Access as a backend data source for custom business systems, as well as developers migrating to the Microsoft .NET platform.

About the User Group Leader Mark Ginnebaugh, User Group Leader, is the President of DesignMind, a Bay Area developer of Websites and Database Applications. Send User Group-related questions and suggestions to mark@designmind.com