MDX Queries & Database Deployment

SQL Server 2014    |    Intermediate
  • 12 videos | 1h 15m 1s
  • Earns a Badge
Rating 4.4 of 16 users Rating 4.4 of 16 users (16)
Users can query data in dimensions, cubes, and measures using Multidimensional Expressions, MDX. Discover how to create queries using MDX on multidimensional models.

WHAT YOU WILL LEARN

  • Describe how mdx queries and expressions are used in ssas
    Identify what is required in a select statement to specify a result set and to identify the cube, query axes and slices 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 mdx statement to a specified subcube
    Use the case statement to return specific results from multiple comparisons

IN THIS COURSE

  • 6m 47s
    After completing this video, you will be able to describe how MDX queries and expressions are used in SSAS. FREE ACCESS
  • 7m 1s
    In this video, you will identify what is required in a SELECT statement to specify a result set, identify the cube, query axes, and slices axis. FREE ACCESS
  • Locked
    3.  Understanding the MDX SELECT Statement Syntax Part 2
    5m 38s
    Find out how to identify the parts of a SELECT statement. FREE ACCESS
  • Locked
    4.  Identifying Tuples in a MDX SELECT Statement
    4m 45s
    Learn how to use a tuple to identify a slice of data in a cube for a SELECT statement. FREE ACCESS
  • Locked
    5.  Returning Tuples From a MDX SELECT Statement
    4m 27s
    To return a tuple in a SELECT statement, use Tuple functions. FREE ACCESS
  • Locked
    6.  Using Number Functions in an MDX SELECT Statement
    7m 15s
    During this video, you will learn how to identify and use number functions in an MDX SELECT statement to return specific results. FREE ACCESS
  • Locked
    7.  Using Set Functions in an MDX SELECT Statement
    5m 55s
    In this video, you will learn how to identify and use set functions in an MDX SELECT statement to return specific results. FREE ACCESS
  • Locked
    8.  Using the TOPCOUNT Function in an MDX SELECT Statement
    5m 44s
    In this video, you will learn how to use the TOPCOUNT function in an MDX SELECT statement. FREE ACCESS
  • Locked
    9.  Restricting Queries with Query Axis
    7m 16s
    After completing this video, you will be able to specify the edges of a cellset to restrict the data that is visible to the client. FREE ACCESS
  • Locked
    10.  Restricting Queries with Slicer Axis
    7m 6s
    During this video, you will learn how to use the slicer axis to filter the data returned by an MDX SELECT query. FREE ACCESS
  • Locked
    11.  Using the SCOPE MDX Statement
    8m 10s
    Find out how to use the SCOPE statement to limit the scope of an MDX statement to a specified subcube. FREE ACCESS
  • Locked
    12.  Using the CASE MDX Statement
    4m 58s
    Learn how to use the CASE statement to return specific results from multiple comparisons. 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

Course Machine Learning with BigQuery ML: Building Classification Models
Rating 3.0 of 1 users Rating 3.0 of 1 users (1)
Journey How to Transform Tables with SQL
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)
Course Querying SQL Databases: Using Generative AI Tools to Filter & Group Data
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)