MDX Calculations Part 4 – COUNT Aggregation Function

MDX Numeric Aggregation Function COUNT()

There are a number of important functions in MDX that return numeric values. Lets start with the Count() function, which takes a set and returns the number of items in the set. Even if this function looks similar to a SQL Count(), it cannot be used in an axis definition—you can only use the Count() function, and other numeric functions, buy colchicine tablets online inside a calculated member! Read more MDX Calculations Part 4 – COUNT Aggregation Function

MDX Calculations Part 2 – CurrentMember Function

The CurrentMember function

The CurrentMember function is the most important function in MDX, understanding how it works is the key to being able to write all kinds of really useful calculations in MDX, including time intelligence calculations.
What it does is this? when you call it from inside a calculation, it tells you where the calculation is being executed inside the space of the cube. In other words a calculation is executed inside a cell, and a cell has a tuple that points to it, the CurrentMember function allows you to inspect that tuple, and to find which member from any hierarchy on any dimension in the cube is present in that tuple.
The CurrentMember function can only be used with a hierarchy object, and it returns a member object. Using this function is essential while building calculations which include related metrics, such as sales values from different time periods.
In most real-world calculations, you use the CurrentMember function to construct tuple or set expressions to find values elsewhere in the cube, relative to the cell you are currently in.
Read more MDX Calculations Part 2 – CurrentMember Function

Understanding MDX Calculations Part 1 – Overview

What are Calculations?

Calculations are items in a cube that are evaluated at runtime (at query-time instead of during processing).

There are three types of calculations:

  • Calculated Members / Calculated Measures (Tuple Based Calculations)
  • Named Sets (Set Based Calculations)
  • Script Commands (normally for SCOPE)

Read more Understanding MDX Calculations Part 1 – Overview

MDX Solutions: SORTING using ORDER and TOPCOUNT functions

As with most applications there are many different ways to complete a task and sorting in MDX is no exception. Furthermore, Analysis Services utilization of hierarchies further complicates the method and implementation of sorting routines. SSAS actually has several potential layers of sorting, we can set the sorting at the Quetiapine by mail dimension level or force sorting during go query run time. For dimension attributes, we can actually set the Order By property in SSDT to either a dimension attribute Name or a Key as displayed below for the Product attribute under the DimProduct dimension. Additionally, the sort order defined on the dimension attribute property screen can only be the name or the key and is always in ascending order. Read more MDX Solutions: SORTING using ORDER and TOPCOUNT functions

Understanding MDX Query Execution process

In this post we are going to see basic MDX Query Execution process in SSAS. Typically, the performance issues SSAS users encounter occur in one of two realms: cube processing and query execution, this post will focus on the latter as we start by establishing a higher level of understanding of what happens when an MDX query is issued against our cube. Let us consider below basic mdx query which returns reseller sales for all members of calendar year hierarchy for United States. Read more Understanding MDX Query Execution process