All eazyBI for Jira eazyBI for Confluence Private eazyBI

Videos on calculations with MDX

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. SMARTEN UP

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. SMARTEN UP

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. SMARTEN UP

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. DIG DEEPER

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. DIG DEEPER

Slides: 23-handling-sets.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. DIG DEEPER

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 a scratch putting together elements gradually and adding more and more sense to the sentence in MDX. DIG DEEPER

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. DIG DEEPER

Slides: Hidden-gems-of-MDX.pdf

 

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. DIG DEEP

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. DIG DEEPER

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. DIG DEEPER

SlideseCD2023_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. DIG DEEPER

NEW: MDX: The Inevitable Descent–From Complexity to Performance


NEW: How to Fix Total Row Calculations in eazyBI