MDX -- NON EMPTY-- Part-7

                                              MDX -- NON EMPTY-- Part-7
NON EMPTY Function:-
                                                                               NON EMPTY Function is used to get all the specified members whose value are not NULL.

-- 1. NON EMPTY    

-- The NON EMPTY is used to get all the specified members whose values are not NULL

-- Actuall MDX Query

SELECT {

         [Measures].[Sales Amount]

        ,[Measures].[Order Quantity]

              ,[Measures].[Tax Amt]

          } ON COLUMNS

      ,[Dim Product].[English Product Subcategory Name].[English Product Subcategory Name]

          ON ROWS

FROM [MSBI]

  

-- Example-1

SELECT {

         [Measures].[Sales Amount]

        ,[Measures].[Order Quantity]

              ,[Measures].[Tax Amt]

          } ON COLUMNS

      ,NON EMPTY [Dim Product].[English Product Subcategory Name].[English Product Subcategory Name]

          ON ROWS

FROM [MSBI]

-- Example-2

SELECT {

         [Measures].[Sales Amount]

        ,[Measures].[Total Product Cost]

        ,[Measures].[Tax Amt]

       } ON COLUMNS

      ,

         NON EMPTY

         (

           [Dim Product].[English Product Subcategory Name].[English Product Subcategory Name]

          ,[Dim Product].[Product Key].[Product Key]

         )       ON ROWS

FROM [MSBI]

-- NON EMPTY with Measures to exclude the Members

-- which are having all NULL values

-- Actual MDX Query

SELECT {

        [Dim Date].[Calendar Year].[Calendar Year]

       } ON COLUMNS

      ,(

         [Dim Date].[English Month Name].[English Month Name]

       ) ON ROWS

FROM [MSBI]

-- NON EMPTY with Measures to exclude the Members which are having all NULL values

ESLECT NON EMPTY{

        [Dim Date].[Calendar Year].[Calendar Year]

       } ON COLUMNS

      ,(

         [Dim Date].[English Month Name].[English Month Name]

       ) ON ROWS

FROM [MSBI]

Thanks for Looking into this.....