MDX Queries & Database Deployment
SQL Server 2014
| Intermediate
- 12 videos | 1h 15m 1s
- Earns a Badge
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 SSASidentify what is required in a SELECT statement to specify a result set and to identify the cube, query axes and slices axisidentify the parts of the SELECT statement syntaxuse a tuple to identify a slice of data in a cube for a SELECT statementuse Tuple functions in a SELECT statement to return a tupleidentify 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 resultsuse the TOPCOUNT function in an MDX SELECT statementspecify the edges of a cellset to restrict the returned data that is visible to the clientuse the slicer axis to filter the data returned by an MDX SELECT queryuse the SCOPE statement to limit the scope of a MDX statement to a specified subcubeuse the CASE statement to return specific results from multiple comparisons
IN THIS COURSE
-
1.Understanding MDX Queries on Multidimensional Models6m 47sUP NEXT
-
2.Understanding the MDX SELECT Statement Syntax Part 17m 1s
-
3.Understanding the MDX SELECT Statement Syntax Part 25m 38s
-
4.Identifying Tuples in a MDX SELECT Statement4m 45s
-
5.Returning Tuples From a MDX SELECT Statement4m 27s
-
6.Using Number Functions in an MDX SELECT Statement7m 15s
-
7.Using Set Functions in an MDX SELECT Statement5m 55s
-
8.Using the TOPCOUNT Function in an MDX SELECT Statement5m 44s
-
9.Restricting Queries with Query Axis7m 16s
-
10.Restricting Queries with Slicer Axis7m 6s
-
11.Using the SCOPE MDX Statement8m 10s
-
12.Using the CASE MDX Statement4m 58s
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.