COURSE OUTLINE:

Multidimensional Review

• Understand and use multidimensional terminology.

• Define multidimensional terms: Database, Cube, Dimension, Hierarchy, Level, Member.
• Explain the use of Parent Child dimension and Unary Operators.
• Understand the sample database used in the examples and exercises.
• Explain the difference betweeen a “derived measure” (a SQL expression) and a “calculated member” (an MDX).

Multidimensional Expressions

• Add calculated members to a cube.

• Contrast multidimentional expressions and statements.
• Explain the derivation and meaning of the word tuple.
• Compare MDX with spreadsheet formula.
• Include multiple explicit dimensions in a tuple.
• Create percent of total calculations.

TOP

MDX Member Calculations

• Use MDX member functions to navigate within a hierarchy.

• Use the Ancestor function.
• Use the IIF and IsEmpty functions and logical operators.
• Use the Name function.
• Include member properties in expression.
• Create percent of parent calculations.

MDX Time Calculations

• Use MDX time functions to compare values over time.

• Use PivotTable List control as a browser.
• Use PrevMember and ParallelPeriod functions.
• Find and apply other time-related member functions.
• Calculate various types of growth.

TOP

MDX Statements and Sets

• Use MDX set functions in a query statement.

• Compare MDX statements with expressions.
• Define basic MDX Statement Syntax.
• Use MDX Sample application.
• Explain concept and usage of a Set.
• Use basic Set functions: Members, Children, Descendants.

MDX Set Manipulation

• Use functions to manipulate sets of members.

• Modify sets by using Head and Tail functions.
• Create tuples in a set by using the CrossJoin function.
• Use the Union and Hierarchize functions.
• Use the Order and Filter functions.

TOP

MDX Aggregation Functions

• Use functions to aggregate values from a set of members.

• Use Sum and Aggregate functions (RollupChildren()).
• Use Time-related Set functions: LastPeriods and PeriodsToDate.
• Create calculated members by using Aggregation functions.
• Follow strategy for creating calculated members.

Using MDX in Cube Definitions

• Apply MDX to make a cube change dynamically.

• Create calculated Default Members.
• Create calculated Actions (and captions).
• Create calculated Cell-level Security.

TOP

Calculating Cell Values by using MDX

• Calculate formulas for specific blocks of cells.

• Create Custom Rollup formulas.
• Create Custom Member formulas.
• Create Custom Cell formulas.

Controlling Calculations in a Cube

• Control the order of calculations within a cube.

• Use the Solve Order property to control calculation sequence.
• Use Multi-Pass calculations to control calculation sequence.
• Correctly understand and apply the Interaction of Aggregation function, Unary Operators, Calculated Members, Calculated Cells, Custom Members, Custom Rollups, Multi-Pass, and Solve Order.

TOP

PARTICULARS: