It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

This session targets SSAS developers that are already dealing with complex security solutions on a regular basis and want to get more insights on what actually happens inside SSAS when the different kinds of security are applied to their model.

In this session we'll look at the structure and basics of MDX, the Multi Dimensional query eXpression language for querying Analysis Services OLAP cubes. We'll start at the beginning, so no previous experience necessary.

Processing of SSAS OLAP databases can be a tricky business, particularly when it comes to incremental processing of dimensions. John will give you real life examples of why certain approaches work and others do not.

Most of us use Excel in our Daily work, but are you familiar with the Business Intelligence features in Excel? In this session we'll look at some of the most common and useful BI features in Excel 2010 and discuss limitations and best practices.

This session looks at some of the different methods available to load slowly changing dimension data into a data warehouse, and compares the relative performance given different data scenarios and traditional storage compared with FusionIO

Do you have complex dimensions in your data warehouse? Parent-child, late arriving, type 3 or type 6? In this session, we'll cover some SSIS patterns for handling each of these, along with tips for making them perform well.

Master Data Services has been given an overhaul in Denali, including a new Excel add-in and modified web front-end. Come to this session to see how MDS can be used to give greater control and process to your BI/DW dimension management.

Many of us know what dimensions and fact tables are. But dimensional modelling is more than just dimensions and fact tables. This session is about advanced dimensional modelling topics, which are useful for anybody involved in the design of a DW.

This session will introduce you to the core components required to set up and create a cube in SQL Server Analysis services. consideration is given to SQL Server 2005 and SQL Server 2008
to be considered for Friday

Among many of its functions, MDX language has one special set function - Axis() function. That function allows creation of calculated measures that are 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.

About

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite.
There is a breadth of knowledge in the SQL Community that will benefit everyone in the community.
We want to spread that knowledge.

We all work with the SQL community, some of us for many years. We have a range of skills and experiences from being given the MVP award by Microsoft, organising user groups and speaking at events around the world.