September 27, 2017 at 7:50 am
WITH MEMBER [Measures].[CurrCode] AS
[WDI_Series].[Topic].currentMember.properties('Code')
SELECT
{[Measures].[CurrCode]} ON 0 ,
[WDI_Series].[Topic].[Indicator Name] on 1
FROM [WDI]
Need a name for the indicator column
September 29, 2017 at 12:44 am
mnr123 - Wednesday, September 27, 2017 7:50 AMWITH MEMBER [Measures].[CurrCode] AS
[WDI_Series].[Topic].currentMember.properties('Code')SELECT
{[Measures].[CurrCode]} ON 0 ,
[WDI_Series].[Topic].[Indicator Name] on 1
FROM [WDI]Need a name for the indicator column
Can I ask why? You seem to be running this query in SSMS. Any reporting tool will give the column an alias, even if it's as nasty as something like "[WDI_Series].[Topic].[Indicator Name].[MEMBER_CAPTION]" you can rename it. Technically speaking, the alias is the displayed member name because it is a multidimensional query, but enough of that.
The short answer to your question is no, you can't do this in SSMS directly.
September 29, 2017 at 9:09 am
PB_BI - Friday, September 29, 2017 12:44 AMmnr123 - Wednesday, September 27, 2017 7:50 AMWITH MEMBER [Measures].[CurrCode] AS
[WDI_Series].[Topic].currentMember.properties('Code')SELECT
{[Measures].[CurrCode]} ON 0 ,
[WDI_Series].[Topic].[Indicator Name] on 1
FROM [WDI]Need a name for the indicator column
Can I ask why? You seem to be running this query in SSMS. Any reporting tool will give the column an alias, even if it's as nasty as something like "[WDI_Series].[Topic].[Indicator Name].[MEMBER_CAPTION]" you can rename it. Technically speaking, the alias is the displayed member name because it is a multidimensional query, but enough of that.
The short answer to your question is no, you can't do this in SSMS directly.
Thanks
I was able to put an alias name from front end
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply