Course is $1700.00
Reporting on cubes
- Data Sources and Model Types
- The OLAP Structure
- The Dimensional Query
- Dimensional Expressions
MDX Reporting
- Member Structures
- Working with MUNs
- MDX Functions explained
- Creating Tuples
Report Context
- Default vs root
- Default measure vs current measure
Cube sources
- Relational vs Cube
- Filtering techniques
- Slicers
- Prompting Dimensional Data
Creating Calculations with Member Functions
- Top Bottom filters
- Percent of Base Calculations
- Dynamic Top percent
- Using Members from different hierarchies of the same dimension
- Variance Calculation
- Coercion rules
Keeping it in the family (functions)
- Scaling the dimensional family structure
Navigating Dimensional Structures with Relative Functions
- Month and yearly functions
- Functions in a Dashboard report
- Six month Running total report
Multi-Dimensional Drill Behavior
- Drill up and Drill down
- Member Set Structures
- Advanced Drill Behavior
- Independent Drilling
- Preserve Sort Order when Drilling
[woocommerce_cart]