MDX Queries

SQL Server 2014    |    Expert
  • 11 Videos | 1h 12m 17s
  • Earns a Badge
Likes 13 Likes 13
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

  • Playable
    1. 
    Designing MDX Calculations
    6m 4s
    UP NEXT
  • Playable
    2. 
    The MDX Query Structure
    5m 49s
  • Locked
    3. 
    Identifying Common MDX Functions
    4m 38s
  • Locked
    4. 
    Using MDX Set Functions (Part 1)
    9m 29s
  • Locked
    5. 
    Using MDX Set Functions (Part 2)
    5m 50s
  • Locked
    6. 
    Using MDX Tuple Functions
    10m 1s
  • Locked
    7. 
    Managing Scope and Context
    7m 39s
  • Locked
    8. 
    Creating Query-scoped Calculated Members
    4m 40s
  • Locked
    9. 
    Creating Session-scoped Calculated Members
    4m 42s
  • Locked
    10. 
    Performing a Simple Case Statement
    6m 5s
  • Locked
    11. 
    Performing a Searched Case Statement
    4m 50s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 61 Likes 61  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE SOLID & GRASP
Likes 3218 Likes 3218  
COURSE T-SQL Queries
Likes 173 Likes 173