MDX IIF statement to match data intersections
Hi All,
I have this ASO member formula which validates fine but doesn't produce any result. I haven't used MDX much so I am not sure if I can compare data intersections this way. If there is another way to match data intersection values, please let me know.
Thanks in advance.
IIF(
([Measures].[Country MDM]) = ([Measures].[Country MDM],[Accounts].[No Accounts],[Years].[No Year],[Period].[No Period] ,[GEO].[No Geo],[RegionParent].[No RegionParent]),
([Measures].[GEO Planning Territory],[Accounts].[No Accounts],[Years].[No Year],[Period].[No Period] ,[GEO].[No Geo], [RegionParent].[No RegionParent])
, Missing)