none
HardCode Values MDX

    Question

  • Hi friends,

    I had one issue.

    I was writing this code and giving right results. Just I'm doing union for max val and min value

    Here my question is I want to create another measure which holds like "First" and "Last"

    this is my Query

    WITH
    
    SELECT
    NON EMPTY {
    	[MEASURES].[NetVal]
    }
    
    ON 0,
    NON EMPTY
    
    UNION
    (
    (TAIL(
    ORDER(
        NONEMPTY(
        (
         [Catalogue].[Code].&[100503]
         *
         [Dim_Ope].[Name].[All].Children
            *
         [Date].[YYYYMMDD].[All].Children 
    
         )
         
         ,[MEASURES].[NetVal]
         )
      ,[MEASURES].[NetVal]
      ,BASC
      )
      ,1
      )
      ),
      (HEAD(
    ORDER(
        NONEMPTY(
        (
         [Catalogue].[Code].&[100503]
         *
         [Dim_Ope].[Name].[All].Children
            *
         [Date].[YYYYMMDD].[All].Children 
    
         )
         
         ,[MEASURES].[NetVal]
         )
      ,[MEASURES].[NetVal]
      ,BASC
      )
      ,1
          )
        )
      )        
    DIMENSION PROPERTIES
    MEMBER_CAPTION
    
    ON 1
    
    FROM [Cube]

                                                       NetVal     Identify

    100503     Jim     2013-05-28     56289       First

    100503    Martin  2013-05-03      516         Last

    I want to create this identify measure.

    Can anyone tell me how to do that.?

    Thanks for your help.

    Monday, July 01, 2013 5:03 PM