SSAS Dynamic Prior Period

Josh,

When using the prior period function and you want the calculation to work on any level of the hierarchy, you'll need to remember the "CurrentMember.Level" syntax:

MDX Calculated Member Check if Measure is Null

Josh,

So you want to create a count of a measure when it is not null.  To do so in MDX, you can do the following:

WITH Member [Measures].[Count of Non Null]
AS
IIF(ISEMPTY([Measures].[Might Be Null - Avg]), NULL, 1)

SELECT
   NON EMPTY
   {
       [Measures].[Might Be Null - Avg],
       [Measures].[Count of Non Null]
   } ON COLUMNS,
   NON EMPTY
   {
       [Dim Date].[Fiscal Quarter].[Fiscal Quarter].ALLMEMBERS
   } ON ROWS
FROM
   [MyCube]

Function to Only Display Last Word in SSRS

Josh,

So you have an MDX query that returns back months like "FY 2013 - 2014 January", but you only want to show "January" on the report.

Here is the function to accomplish this:

SSRS Lookup Function Solves MDX Issue

Josh,

So you have an MDX query that you are using in an SSRS report. You need to show subtotals and totals, but there are a couple of issues:

1. The totals and subtotals are on averages which are difficult to total
2. The objects being counted could span multiple groups so that a sum on the report would not accurately match what's coming from the cube

The SSRS Lookup function can help solve this issue!