MDX Training Part 2

Explore the descendants function to display related members at a given level in a hierarchy, using flags like self, before, after, and leaves, with examples from geography.

Learn how to use MDX parent, ancestor, and ascendence functions to identify a city's state and country and to list its geographic ancestors.

Explore MDX member functions such as first child, last child, previous member, next member, lead and lag, plus the item function across multi-level and single-level hierarchies.

Use the hierarchize function to enforce the natural hierarchy, place the calendar year on top, and display readable months like August 2005 and July 2005.

explore how to use current member to iterate through each sales territory member, access its properties (id and unique name), and build calculated members during go through operations.

The ordinal function returns a numeric value for a level and builds calculated members for year, semester, quarter, and month across a calendar hierarchy.

Learn to use the order function to sort data by a measure, apply ascending or descending clauses, and break hierarchy to extract the top 20 records across months.

Discover how the MDX rank function assigns each country a position by ranking them on internet sales in descending order, using current member within the sorted order.

Explore the iif function in MDX, using a logical expression to return one of two objects while demonstrating current member, user defined hierarchy, and ordinal to display months and dates.

Learn to rank product subcategories by their share of total orders using MDX in Analysis Services, and assign grades based on contribution percentages.

Compute the monthly average of daily internet orders from July 2005 onward using calendar dimensions, current member filtering, and non-empty data in MDX.

Explore drilldown member and drilldown level in a geography hierarchy, using sets and levels to drill from continents to countries to states.

Explore drilldown level top and drilldown level bottom in MDX, using the calendar and month hierarchies to reveal top or bottom dates and states by sales.

Demonstrate drilling down MDX data with top and bottom members to reveal monthly, quarterly, and geographic breakdowns of internet sales.

Learn how to use the MDX generate function with two sets to produce the top five products per country by internet order count.

Add time intelligence to a dimension by configuring a time dimension with calendar year, quarter, month, and date, enabling mdx functions like ytd, mtd, and wtd through proper attribute relationships.

Master time intelligence in MDX with YTD, QTD, MTD, and WTD functions, configure the date dimension, and practice MDX queries on the demo cube.

Learn how periods to date works in MDX, expanding date levels from year to month to produce cumulative data, with examples using September 2006 and semester to date.

Learn opening period and closing period in mdx to get start or end of month. Use current member with month level to show first day of month and order count.

Learn how to use the last periods MDX function to analyze four months of bike orders from October 2005 to January 2006, considering member level, calendar hierarchies, and year restrictions.

Explore how parallel period compares current year sales to the previous year, using calendar year, month, quarter, and day levels to reveal trends.

Compute rolling three month average retail sales in MDX using last period, create a calculated member, and compare current sales to the average while handling missing data.