The pie I have not yet eaten ... http://imgur.com/4uuI2

😛

Wow, so iserror([Date Dimension].[Fiscal Year Hierarchy].CurrentMember) does not test whether the CurrentMember function returns an error? MDX is still very counter-intuitive to me in many ways.

Thanks for offering the alternative...

Thanks. Chris has given some input on another aspect of this problem in another forum and I am following this up with him too.

--Matt.

Like you, I thought of putting fake values back into the cube's Calculation script rather than using WITH. I wanted to figure out whether null came from:

1. No calculation being...

OK, I tried this (a slight variation on your suggestion):

WITH

member [Measures].[Net Lost Commitments TEST ISERROR] as

'iif(iserror([Date Dimension].[Fiscal Year Hierarchy].CurrentMember)

, 1

, 0)'

member [Measures].[Net Lost Commitments...

@davoscollective (I keep wanting to write DavrosCollective, with Dr Who overtones:-)) asks to see the calculation that defines [Measures].[Net Lost Commitments].

CREATE MEMBER CURRENTCUBE.[Measures].[Net Lost Commitments (during period)]

AS...

@davoscollective suggested running this query (I've changed it to reflect the relevant years):

select

[Measures].[Net Lost Commitments (during period)] on columns

, {[Date Dimension].[Fiscal...

I'll answer @davoscollective's three questions separately.

First, the query ...

select

[Measures].[Net Lost Commitments] on columns

, ([Date Dimension].[Fiscal Year Hierarchy].[Fiscal Year].Allmembers) on...

A suggestion from another source has solved this for me. I can use --

iif(iserror([Date Dimension].[Fiscal Year Hierarchy].CurrentMember),

, null

, [Measures].[Acquisitions] - [Measures].[Growth...