Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MDX Query to remove Null Expand / Collapse
Author
Message
Posted Wednesday, February 26, 2014 10:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, March 1, 2014 4:58 PM
Points: 2, Visits: 19
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

Post #1545695
Posted Friday, March 7, 2014 2:28 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 28, 2014 7:12 PM
Points: 2,148, Visits: 487
Have you attempted the non-empty crossjoin of the 3 attribute hierarchies? If so, how was your performance?
Post #1548905
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse