Course Description
Once data is provided to the multidimensional model through dimensions, cubes, and measures, users can query the data using Multidimensional Expressions or MDX. Once the multidimension models are created, they need to be processed and the databases deployed for users to access them. This course will discuss and show how to create MDX queries as well as how to process models and deploy SQL Server Analysis Services or SSAS databases. This course is one in a series of Skillsoft courses to help learners prepare for the 70-466 Implementing Data Models and Reports with Microsoft SQL Server certification exam.
Learning Objectives
Creating MDX Queries
- start the course
- describe how Multidimensional Expressions or MDX queries and expressions are used in SQL Server Analysis Services or SSAS
- identify what is required in a SELECT statement to specify a result set and to identify the cube, query axis, and slicer axis
- identify the parts of the SELECT statement syntax
- use a tuple to identify a slice of data in a cube for a SELECT statement
- use tuple functions in a SELECT statement to return a tuple
- identify and use number functions in an MDX SELECT statement to return specific results
- identify and use set functions in an MDX SELECT statement to return specific results
- use the TopCount function in an MDX SELECT statement
- specify the edges of a cellset to restrict the returned data that is visible to the client
- use the slicer axis to filter the data returned by an MDX SELECT query
- use the scope statement to limit the scope of a Multidimensional Expressions or MDX statement to a specified subcube
- use the CASE statement to return specific results from multiple comparisons
Processing Data Models
- describe how processing and reprocessing affects SQL Server Analysis Services or SSAS objects, specifically partitions, databases, cubes, and dimensions
- describe the different processing options available for SQL Server Analysis Services or SSAS objects, specifically full processing and incremental processing
- automate the processing of SQL Server Analysis Services or SSAS objects using Analysis Management Objects or AMO
- use XML for Analysis or XMLA to process SQL Server Analysis Services or SSAS objects
- use PowerShell to process and manage partitions
- implement remote processing of SQL Server Analysis Services or SSAS objects
Deploying Databases
- use the deployment wizard to deploy a SQL Server Analysis Services or SSAS database
- test a database deployment
- use the Synchronize Database Wizard to synchronize metadata and data between two SQL Server Analysis Services or SSAS databases
Practice: Use MDX and Process Models and Databases
- create MDX queries to return specific results and process data models and deploy databases