All eazyBI for Jira eazyBI for Confluence Private eazyBI

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!

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. 

More videos