MDX Calculated measures shows null value on facts that does not exist

[Anonymous]

Hi,

I am working with an Multidimensional OLAP Cube, and I have 3 calculated measures as follow:

CREATE MEMBER  CURRENTCUBE.[Measures].[Depense] AS

([Measures].[BUDGET],[DIM TYPE DEPENSE].[LIBELLE TYP MVT].&[Depense])



 CREATE MEMBER  CURRENTCUBE.[Measures].[Recette] AS

([Measures].[BUDGET],[DIM TYPE DEPENSE].[LIBELLE TYP MVT].&[Recette])


CREATE MEMBER  CURRENTCUBE.[Measures].[Effort] AS
1-([Recette]/[Depense])

For the last one i get as results all the years of the date dimension with null value as well as the right value for the related years.

Anyone can give me a hint or a way to eliminate the unwanted null value ?

Kind regards,

Mohammad

[v-yulgu-msft]

Hi @Anonymous,

As this thread is more related to SQL Server Analysis Service, please post your question on relative forum so that you can get more professional advice.

Thanks,
Yuliana Gu