I had a post last month, MDX #25 – Slicer or Sub-Cube?, verifying that the query context did not change with the subquery. This can pose problems if you want to use the Time-series functions in MDX. Two functions come into mind, YTD() and PeriodsToDate(...

Many function names in MDX are very family-friendly. Children, parent, ancestors, descendants, ascendants, are all terms we often used in telling family stories. Except ascendants. I never really understand what this word means until I ran into this wor...

Many function names in MDX are very family-friendly. Children, parent, ancestors, descendants, ascendants, are all terms we often use in telling family stories. Except ascendants. I never really understand what this word means until I ran into this word...

I’ve blogged about the Properties()  function before. MDX #11 – How to get number of cars each customer owned using Properties() function? MDX #12 – Do not forget the TYPED flag in the Properties() function  The Properties()  function ...

I’ve blogged about the Properties()  function before. MDX #11 – How to get number of cars each customer owned using Properties() function? MDX #12 – Do not forget the TYPED flag in the Properties() function  The Properties()  function is ...

Slicer, Axes and Calculations Can All Filter Data in MDX Every developer with SQL background knows how the WHERE clause works. You put some condition in the WHERE clause, such as TheDate = Yesterday (pseudo code), and it will only return data for yester...

Slicer, Axes and Calculations Can All Filter Data in MDX Every developer with SQL background knows how the WHERE clause works. You put some condition in the WHERE clause, such as TheDate = Yesterday (pseudo code), and it will only return data for yeste...

Functions such as NonEmpty(), Filter() and Exists() must use a numeric expression Many of the MDX functions, such as NonEmpty(), Filter() and Exists(), seem to be easy enough to use, but they present quite a challenge for people with T-SQL background....

Functions such as NonEmpty(), Filter() and Exists() must use a numeric expression Many of the MDX functions, such as NonEmpty(), Filter() and Exists(), seem to be easy enough to use, but they present quite a challenge for people with T-SQL background. ...

Calculated Field has existed in Reporting Services since version 2005. SSRS 2005 did not have the most attractive user interface design, so this pretty useful feature stayed hidden from me until version 2008. Even in SSRS 2008, I did not pay much atten...