EBS Customizations (MOSC)

MOSC Banner

MDX IIF statement to match data intersections

edited Aug 12, 2020 6:30PM in EBS Customizations (MOSC) 1 commentAnswered

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center