Hi,

I have the query below which returns two columns:

[vwFHPROP_dmnTime].[All dmnTime].[2004].[8].[13]
[vwFHPROP_dmnFH].[FH1].[MEMBER_CAPTION]

How can I modify the query to rename the column names?

Thanks.


WITH SET [OlapX%X0_Lst] AS 'DESCENDANTS([vwFHPROP_dmnTime].[All
dmnTime].[2004].[8].[13], [vwFHPROP_dmnTime].[Day], SELF_AND_AFTER)' SET
[OlapX%X0_Flt] AS '[OlapX%X0_Lst]' SET [OlapX%X0_Prt] AS '[OlapX%X0_Flt]' SET
[OlapX%X0_Ord] AS '[OlapX%X0_Prt]' SET [OlapX%Y0_Lst] AS
'DESCENDANTS([vwFHPROP_dmnFH].[All dmnFH], [vwFHPROP_dmnFH].[FH1], SELF)' SET
[OlapX%Y0_Flt] AS '[OlapX%Y0_Lst]' SET [OlapX%Y0_Prt] AS '[OlapX%Y0_Flt]' SET
[OlapX%Y0_Ord] AS '[OlapX%Y0_Prt]' SET [OlapX%Y1_Lst] AS '
{[vwFHPROP_dmnProposal].[All dmnProposal]} ' SET [OlapX%Y1_Flt] AS
'[OlapX%Y1_Lst]' SET [OlapX%Y1_Prt] AS '[OlapX%Y1_Flt]' SET [OlapX%Y1_Ord] AS
'[OlapX%Y1_Prt]' SET [OlapX%X0_Fin] AS '{[OlapX%X0_Ord]}' SET [OlapX%Y0_Fin]
AS '{[OlapX%Y0_Ord]}' SET [OlapX%Y1_Fin] AS '{[OlapX%Y1_Ord]}' SET [OlapX%X]
AS '[OlapX%X0_Fin]' SET [OlapX%Y] AS 'CROSSJOIN([OlapX%Y0_Fin],
[OlapX%Y1_Fin])' SELECT NON EMPTY [OlapX%X] ON AXIS(0), NON EMPTY [OlapX%Y]
ON AXIS(1) FROM [vwFHPROP#Active] WHERE ([Measures].[msrCount],
[vwFHPROP_dmnProgress].[All dmnProgress])

With
member [Measures].[Column1] as '[vwFHPROP_dmnTime].[All
dmnTime].[2004].[8].[13]'
member [Measures].[Column2] as '[vwFHPROP_dmnFH].[FH1].[MEMBER_CAPTION]'




"David" <David (AT) discussions (DOT) microsoft.com> wrote

you probably need to use the .currentmember function

With
member [Measures].[Column1] as '[vwFHPROP_dmnTime].[All
dmnTime].CurrentMember'
member [Measures].[Column2] as '[vwFHPROP_dmnFH].[FH1].CurrentMember.Name'


"David" <David (AT) discussions (DOT) microsoft.com> wrote

I still get the same error message.


I've simplified the query as below.

SELECT
NON EMPTY {DESCENDANTS([vwFHPROP_dmnTime].[All dmnTime].[2004].[8].[13],
[vwFHPROP_dmnTime].[Day], SELF_AND_AFTER)} ON AXIS(0),
NON EMPTY CROSSJOIN({DESCENDANTS([vwFHPROP_dmnFH].[All dmnFH],
[vwFHPROP_dmnFH].[FH1], SELF)},
{{[vwFHPROP_dmnProposal].[All dmnProposal]}}) ON AXIS(1)
FROM [vwFHPROP]

If I try to add a new calculated member (e.g. test)

WITH MEMBER measures.test as 'DESCENDANTS([vwFHPROP_dmnTime].[All
dmnTime].[2004].[8].[13], [vwFHPROP_dmnTime].[Day], SELF_AND_AFTER)'

I get the following error:
token is not valid"{DESCENDANTS([vwFHPROP_dmnTime].[All
dmnTime].[2004].[8].[13], [vwFHPROP_dmnTime].[Day],^SELF_AND_AFTER^)}




"mike" wrote: