MDX Query to remove Null

• Star11989

  SSC Rookie

  Points: 44

  More actions

  February 26, 2014 at 10:03 pm

  #304528

  Can any MDX Guru let me know suitable MDX query to achive the below :-

  I don't want to select Null value present in the Occupation.

  Any help will be highly appreciated.

  Thanks

  "Date" "Occupation" "Number of home"

  FY 2001-Q1 Null 3

  FY 2001-Q2 Teacher 4

  FY 2001-Q3 Banker 5

• sneumersky

  SSCertifiable

  Points: 7667

  More actions

  March 7, 2014 at 2:28 pm

  #1695263

  Have you attempted the non-empty crossjoin of the 3 attribute hierarchies? If so, how was your performance?