30th September - 2nd October 2010

University of York

RSS
Login or Join
Skip Navigation Links
Skip Navigation Links
Home
SQLBits 7
Register
Agenda
Booking & Pricing
Training Day
Friday
Sessions
Speakers
FAQ
Travel & Accommodation
Sponsorship
Gold Sponsors
Exhibitors
News
Previous Events
SQLBits The 6th Sets (VI)
Sessions
Speakers
SQLBits goes West (V)
Sessions
Speakers
SQLBits goes Forth (IV)
Sessions
Speakers
SQLBits Cubed (III)
Sessions
Speakers
SQLBits II The SQL
Sessions
Speakers
SQLBits I
Sessions
Speakers
About
About SQLBits
Who's Who
Privacy
Contact
Community

Brought to you by the UK SQL Server Community.

Copyright © 2007-2010 SQLBits. All Rights Reserved.

Telerik

Orcsweb

Gold sponsors
    
Silver sponsors
    
Bronze sponsors
    
    

Universal calculated measures in MDX queries

Among many of its functions, MDX language has one special set function - Axis() function. That function allows creation of calculated measures that are fully context aware and, if wanted, don't need to refer to any dimension or hierarchy in the cube. In other words, such measures are universal or independant, which means they can be used in any MDX query.

In this session we will present such measures and explain how they work. We'll also show the way how to design them for various scenarios and discuss their potentials and weaknesses.

Previous experience in writing MDX queries is recommended.

Speaker focus

Tomislav Piasevoli

Tomislav_Piasevoli_SQLBits_photo.jpg
Tomislav is a Business Intelligence Specialist focused on Microsoft platform. He lives in Croatia and works for SoftPro Tetral company known for its two OLAP clients: Manager and CubePlayer.

Tomislav's specialty is cube design and MDX. However, working in a small company for the past six years, he gained experience in all phases of a BI project, from presenting solution to end-user support.

Lately, Tomislav became involved in sharing his knowledge worldwide by contributing to Microsoft SSAS forum, blogging and speaking at conferences.

Tomislav Piasevoli's blog http://tomislavpiasevoli.spaces.live.com/


Downloads

File Type Ext ContentName
Presentation .pptx Slide Deck
Zip File .zip Samples and Slide Deck
<< 1 >> 

Other sessions from this conference

AddIns for SSMS - build your own
Comparing Azure storage and SQL Data Services
Data Mining and SSIS - makes sense.
Data Warehouse Data Modelling
Data Warehousing features in SQL 2008
Database Maintenance Optimization
Designing Effective Aggregations in Analysis Services 2008
Effective test-driven database development
End to End Report Creation and Management in SQL Server Reporting Services 2008
High Availability in SQL Server 2008
Implementing Clustering using SQL Server
Instrumenting, Monitoring and Auditing of SSIS ETL Solutions
Making the SQL developer one of the family with Visual Studio Team System
Message in a bottle: Service Broker from 1 to 100 in 75 minutes!
NHibernate – Open Source Object Relational Mapping (ORM)
Performance Optimization with SQL Server 2008
Performance Tuning your TSQL
Securing and Hardening a SQL Server Implementation - Notes from the Field
SQL Server Architecture: The life of a query
SQL Server’s storage engine
SSIS by example
SSIS Nuggets Live
Stop throwing hardware at the problem !
Understanding ADO.NET Data Services
Understanding Graphical Execution Plans
Upgrading To SQL Server 2005 & 2008: Notes & Best Practices
What’s New in SQL Server 2008 T-SQL