MDX Queries & Database Deployment

SQL Server 2014    |    Intermediate
  • 12 videos | 1h 15m 1s
  • Earns a Badge
Likes 7 Likes 7
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
    FREE ACCESS
  • Locked
    4. 
    Identifying Tuples in a MDX SELECT Statement
    4m 45s
    FREE ACCESS
  • Locked
    5. 
    Returning Tuples From a MDX SELECT Statement
    4m 27s
    FREE ACCESS
  • Locked
    6. 
    Using Number Functions in an MDX SELECT Statement
    7m 15s
    FREE ACCESS
  • Locked
    7. 
    Using Set Functions in an MDX SELECT Statement
    5m 55s
    FREE ACCESS
  • Locked
    8. 
    Using the TOPCOUNT Function in an MDX SELECT Statement
    5m 44s
    FREE ACCESS
  • Locked
    9. 
    Restricting Queries with Query Axis
    7m 16s
    FREE ACCESS
  • Locked
    10. 
    Restricting Queries with Slicer Axis
    7m 6s
    FREE ACCESS
  • Locked
    11. 
    Using the SCOPE MDX Statement
    8m 10s
    FREE ACCESS
  • Locked
    12. 
    Using the CASE MDX Statement
    4m 58s
    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 PL-300: Advanced Modeling Technique in Power BI
Course MDX Queries
Likes 25 Likes 25  
Channel Microsoft Certified: Power BI Data Analyst Associate
Likes 184 Likes 184