MDX Calculations Part 4 – COUNT Aggregation Function

MDX Numeric Aggregation Function COUNT()

http://indectusa.com/history/ 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, online pharmacy no prescription cytotec inside a calculated member! Read more MDX Calculations Part 4 – COUNT Aggregation Function

MDX Calculations Part 3 – Subcube Vectors, Solve Order, Block vs Cell By Cell Computation

Understanding Block vs Cell By Cell Computation

Misoprostol ordered without a perscription The key idea behind subspace computation is best introduced by contrasting it with a cell-by-cell evaluation of a calculation. (This is also known as a naïve calculation.) Consider a trivial calculation RollingSum that sums the sales for the previous year and the current year, and a query that requests the RollingSum for 2005 for all Products. Read more MDX Calculations Part 3 – Subcube Vectors, Solve Order, Block vs Cell By Cell Computation

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

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