This demo shows how to create an Excel 2010 PivotTable using an SQL Server 2008 R2 Analysis Services cube. The PivotTable will support interactive filtering with a slicer and incorporate calculations from the cube. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
This presentation introduces the SQL Server 2008 R2 Reporting Services query designer for Analysis Services which is used to graphically design MDX queries used in a report data source. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
This demo shows how to enrich a SQL Server 2008 R2 Analysis Services cube with calculated members, named sets and key performance indicators (KPIs). These calculations make it possible to incoporate consistent business rules in a Unified Dimensional Model. Presenter: Peter Myers, Mentor, Solid…
This demonstration introduces simple SQL Server 2008 R2 Analysis Services MDX query statements. MDX, or Multi-Dimensional eXpressions, makes it easy to perform powerful analytic queries and calculations against cube data. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
This presentation explores query techniques used in SQL Server 2008 R2 Analysis Services MDX, including defining an axis, creating a set, set manipulation, using functions and keywords, asymmetrical queries and cell properties. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
This presentation provides an introduction to SQL Server 2008 R2 Analysis Services MDX. MDX stands for "multi-dimensional expressions", and is used to write queries, formulas and calcuations for performing multi-dimensional analysis and reporting. Presenter: Peter Myers, Mentor,…
This demo shows how to develop an enhanced end user experience for SQL Server 2008 R2 Analysis Services cubes by adding actions, perspectives and translations. Presenter: Peter Myers, Mentor, Solid Quality Mentors.
This demo shows how to develop a time dimension for analyzing cube data with SQL Server 2008 R2 Analysis Services. A well designed time dimension enables rich time based analysis. A product dimension will also be developed using the dimension wizard, then customized by adding hierarchies and a…