MDX Queries & Database Deployment

SQL Server 2014
  • 12 Videos | 1h 19m 1s
  • Earns a Badge
Likes 5 Likes 5
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

  • Playable
    1. 
    Understanding MDX Queries on Multidimensional Models
    6m 47s
    UP NEXT
  • Playable
    2. 
    Understanding the MDX SELECT Statement Syntax Part 1
    7m 1s
  • Locked
    3. 
    Understanding the MDX SELECT Statement Syntax Part 2
    5m 38s
  • Locked
    4. 
    Identifying Tuples in a MDX SELECT Statement
    4m 45s
  • Locked
    5. 
    Returning Tuples From a MDX SELECT Statement
    4m 27s
  • Locked
    6. 
    Using Number Functions in an MDX SELECT Statement
    7m 15s
  • Locked
    7. 
    Using Set Functions in an MDX SELECT Statement
    5m 55s
  • Locked
    8. 
    Using the TOPCOUNT Function in an MDX SELECT Statement
    5m 44s
  • Locked
    9. 
    Restricting Queries with Query Axis
    7m 16s
  • Locked
    10. 
    Restricting Queries with Slicer Axis
    7m 6s
  • Locked
    11. 
    Using the SCOPE MDX Statement
    8m 10s
  • Locked
    12. 
    Using the CASE MDX Statement
    4m 58s

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 19 Likes 19  
Likes 11 Likes 11  
Likes 37 Likes 37