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

Answer 1

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

Answer 2

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