Videos: calculations with MDX
The videos on this page explain how to build and test new calculations with MDX (Multi-Dimensional eXpressions query language) and the main concepts for different use cases.
You can always read more on our documentation: Calculated measures and members, MDX function reference
MDX ABC: Let’s start at the very beginning
Time required: 30 minutes
How to wrap a head around MDX calculations if you are not born as a developer? Start by recognizing MDX building blocks — sets, expressions, aggregations, and take time to understand eazyBI default measures.
Slides: 14-mdx-abcs.pdf
MDX debugging: How to see through calculated measure
Time required: 30 minutes
Do you ever wonder how calculated measure works and gets to the result? You will learn principles on how to disassemble the calculation to see the results of each step and how to find a faulty part in a formula to fix it.
Slides: 26-how-to-debug-mdx.pdf
MDX: Going Beyond 3D Reporting in Multi-Dimensional Data Cube
Time required: 20 minutes
Before diving into the creation of complex reports and calculations, it's essential to understand the concept of a multi-dimensional data cube and its building blocks. Start by warming up with the basics of retrieving data from a multi-dimensional data cube.
Slides: eCD2023_MDX.pdf
MDX: Understanding tuples
Time required: 30 minutes
A tuple is one of the calculated measure cornerstones. What exactly is Tuple in a multidimensional cube? How and when to use tuples in MDX formulas? Come to see some real-life examples in eazyBI.
Slides: 25-understanding-tuples.pdf
MDX: Handling sets in calculated measures
Time required: 30 minutes
Writing custom MDX calculations that work requires knowledge of basic concepts. A "SET" is one of them. Have you ever wondered what is inside the curly brackets, what means Members and Descendants? The presentation will explain how to construct and use sets in MDX formulas.
Slides: 23-handling-sets.pdf
MDX: The Inevitable Descent–From Complexity to Performance
Time required: 26 minutes
Some dive for fun, some only when it is necessary. Others because they don’t know any better. Join Roberts for a deep dive into the Descendants() function—find out how and when to use it. And when to avoid it!
Slides: eCD24-MDX: The Inevitable Descent.pdf
Journeying with an MDX
Time required: 30 minutes
Do you ever get that feeling of confusion - seeing your measure returning one result while expecting a different one? Getting lost in the multi-dimensional cube is as easy as in real life! Let’s learn principles on how to disassemble the calculation to see the results of each step, so you know where you are and can get to the desired destination.
Slides: Journeying_with_MDX.pdf
MDX the Easy Way: Build Your MDX Calculations Gradually
Time required: 30 minutes
When you learn a new language you start by putting together two simple words, then adding an adjective as a third, and soon you have said a meaningful first sentence. Follow Ilze on how to create a new calculation from scratch, putting together elements gradually and adding more and more sense to the sentence in MDX.
Slides: Build Your MDX Calculations Gradually.pdf
Hidden Gems of MDX
Time required: 20 minutes
When it comes to writing MDX calculations, knowing your data and understanding measures and dimensions is crucial. However, some of those measures and dimensions are nowhere to be seen. Let me show you the hidden side of the data cube.
Slides: Hidden-gems-of-MDX.pdf
How to Fix Total Row Calculations in eazyBI
Time required: 5 minutes
Flexible MDX formulas: How to Use VisibleRows and VisibleColumns
Time required: 30 minutes
Let’s continue mastering your calculation toolbox! eazyBI has introduced new functions to cover additional use cases when designing your custom formulas. Let us have a closer look on how VisibleRows and VisibleColumns functions work and what new horizon those functions unleash. Discover how to take your custom formulas to the next level and optimize your reporting with eazyBI.
Slides: eCD2023_Visible_Rows.pdf
MDX vs JavaScript: Behind Complex Filters
Time required: 30 minutes
There might be different ways how you set up each project in Jira. And yet you still would like to see those projects side by side and analyze their performance. In Jira, you reach out to some complex JQL queries. In this session, I will talk about how eazyBI can help you analyze those cases.
Slides: Behind complex filters.pdf
Advanced MDX: Recipe to Change Report Context
Time required: 20 minutes
In this training session, we’ll learn about relationships in eazyBI. Measures are at the center of it all, with unique relations to all dimensions. Sometimes, to answer your question, you need to redefine those relationships. Let me show you how to create new relations and connect measures with dimensions differently when defining new custom measures.
Slides: eCD2023_Context_change.pdf
Advanced Training Video on Calculated Members and Measures
Time required: 1 hour
This video demonstrates different examples of calculated measures and explains how to create and use them in custom reports.