none
First letter upper case remaining Lowe case for MDX Query

    Question

  • Hi Friends,

    I know Ucase function and Lcase functions but my requirement is first letter should be Upper case remaining lower case..is that possible in the MDX Query. below is my Query

    WITH MEMBER [Measures].[ParameterCaption] 
    AS 
    [Dim Gloabal Dimension1].[Costcentres].CURRENTMEMBER.MEMBER_CAPTION 
    MEMBER [Measures].[ParameterValue] 
    AS [Dim Gloabal Dimension1].[Costcentres].CURRENTMEMBER.UNIQUENAME 
    MEMBER [Measures].[ParameterLevel] 
    AS [Dim Gloabal Dimension1].[Costcentres].CURRENTMEMBER.LEVEL.ORDINAL 
    SELECT {[Measures].[ParameterCaption], 
    [Measures].[ParameterValue],
     [Measures].[ParameterLevel]} ON COLUMNS , 
     [Dim Gloabal Dimension1].[Costcentres].ALLMEMBERS ON ROWS FROM [Retail]


    Thank you

    Thursday, December 22, 2011 12:03 PM

Answers

  • Hi,

    Try This one :-

    Member test as [Dim Gloabal Dimension1].[Costcentres].CURRENTMEMBER.MEMBER_CAPTION
    Member Test1 as Left( VBA!UCASE(test),1)

    Member Test2 As Test1+ Right(VBA!LCASE(test),Len(test)-1)

    and in select clause

    select  Test2


    Sanjeewan

    • Edited by Sanjeewan Kumar Thursday, December 22, 2011 2:08 PM
    • Marked as answer by BandSr Friday, December 23, 2011 10:39 AM
    Thursday, December 22, 2011 1:49 PM

All replies

  • Hi,

    Try This one :-

    Member test as [Dim Gloabal Dimension1].[Costcentres].CURRENTMEMBER.MEMBER_CAPTION
    Member Test1 as Left( VBA!UCASE(test),1)

    Member Test2 As Test1+ Right(VBA!LCASE(test),Len(test)-1)

    and in select clause

    select  Test2


    Sanjeewan

    • Edited by Sanjeewan Kumar Thursday, December 22, 2011 2:08 PM
    • Marked as answer by BandSr Friday, December 23, 2011 10:39 AM
    Thursday, December 22, 2011 1:49 PM
  • I think that the best place to do this would be in the DSV or the ETL so that it is formatted correctly in the dimension in the first place.
    http://darren.gosbell.com - please mark correct answers
    Friday, December 23, 2011 4:34 AM
    Moderator