MDX Queries

SQL Server 2014    |    Expert
  • 11 videos | 1h 9m 47s
  • Earns a Badge
Rating 4.9 of 26 users Rating 4.9 of 26 users (26)
Multidimensional expression, MDX, is a query language used to retrieve data and perform data definition and data manipulation operations for Analysis Services. Learn how to create MDX calculations to obtain the desired result set.

WHAT YOU WILL LEARN

  • Describe the key concepts in mdx
    Describe the basic structure of an mdx query
    Describe the common mdx functions
    Use mdx set functions
    Use mdx set functions
    Use mdx tuple functions
  • Use the calculate and scope statements as well as the this function
    Create query-scoped calculated members using the with keyword
    Create session-scoped calculated members using the create member statement
    Perform a simple case statement to compare an expression to a set of simple expressions to return specific values
    Perform a searched case statement to evaluate a set of boolean expressions to return specific values

IN THIS COURSE

  • 6m 4s
    After completing this video, you will be able to describe the key concepts in MDX. FREE ACCESS
  • 5m 49s
    Upon completion of this video, you will be able to describe the basic structure of an MDX query. FREE ACCESS
  • Locked
    3.  Identifying Common MDX Functions
    4m 38s
    Upon completion of this video, you will be able to describe the common functions of MDX. FREE ACCESS
  • Locked
    4.  Using MDX Set Functions (Part 1)
    9m 29s
    In this video, find out how to use MDX set functions. FREE ACCESS
  • Locked
    5.  Using MDX Set Functions (Part 2)
    5m 50s
    In this video, find out how to use MDX set functions. FREE ACCESS
  • Locked
    6.  Using MDX Tuple Functions
    10m 1s
    In this video, find out how to use MDX tuple functions. FREE ACCESS
  • Locked
    7.  Managing Scope and Context
    7m 39s
    Find out how to use the CALCULATE and SCOPE statements as well as the THIS function. FREE ACCESS
  • Locked
    8.  Creating Query-scoped Calculated Members
    4m 40s
    During this video, you will learn how to create query-scoped calculated members using the WITH keyword. FREE ACCESS
  • Locked
    9.  Creating Session-scoped Calculated Members
    4m 42s
    To create session-scoped calculated members, use the CREATE MEMBER statement. FREE ACCESS
  • Locked
    10.  Performing a Simple Case Statement
    6m 5s
    Find out how to perform a simple case statement to compare an expression to a set of simple expressions and return specific values. FREE ACCESS
  • Locked
    11.  Performing a Searched Case Statement
    4m 50s
    In this video, you will learn how to use a searched case statement to evaluate a set of Boolean expressions and return specific values. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Book SQL Server Analytical Toolkit: Using Windowing, Analytical, Ranking, and Aggregate Functions for Data and Statistical Analysis
Journey Fundamental Math for Data Science
Book Querying SQL Server: Run T-SQL Operations, Data Extraction, Data Manipulation, and Custom Queries to Deliver Simplified Analytics

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Extract, Transform, & Load
Rating 4.5 of 71 users Rating 4.5 of 71 users (71)
Course Recovery & Backup
Rating 4.6 of 18 users Rating 4.6 of 18 users (18)
Course Introduction to Machine Learning Bootcamp: Session 1 Replay
Rating 4.6 of 114 users Rating 4.6 of 114 users (114)