Changing MDX columns in output

#1

I'm getting demension properties like this:
DIMENSION PROPERTIES [Zone].[Level1].[Key],[Zone].[Level2].[Key]
on rows.

But in my output I get colums

[Zone].[Key] and [Zone].[Key]

and reporting services can't tell the difference?

is there anyway to:
DIMENSION PROPERTIES [Zone].[Level1].[Key] as Key1,[Zone].[Level2].[Key] as
Key2
on rows.

#2

Sorry, here's the whole query. I don't think i can do a with members as at
the top for this.

SELECT
{[Measures].[Sends]}

on axis(0),
Generate (
TopCount ( [Zone].&[Level1].children, 5, [Sends]),
TopCount (Descendants([Zone].CurrentMember, 2),3,[Sends] )

) DIMENSION PROPERTIES [Zone].[level1].[Key],[Zone].[level2].[Key] ,
[Zone].[level1].[Name], [Zone].[level3].[Name]

on axis (1)
FROM [All Communication Analysis]
"Cindy Lee" <cindylee (AT) hotmail (DOT) com> wrote

Quote:

I'm getting demension properties like this:
DIMENSION PROPERTIES [Zone].[Level1].[Key],[Zone].[Level2].[Key]
on rows.

But in my output I get colums

[Zone].[Key] and [Zone].[Key]

and reporting services can't tell the difference?

is there anyway to:
DIMENSION PROPERTIES [Zone].[Level1].[Key] as Key1,[Zone].[Level2].[Key]
as
Key2
on rows.

#3

Ok, found it

DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_KEY

"Cindy Lee" <cindylee (AT) hotmail (DOT) com> wrote

Quote:

Sorry, here's the whole query. I don't think i can do a with members as
at
the top for this.

SELECT
{[Measures].[Sends]}

on axis(0),
Generate (
TopCount ( [Zone].&[Level1].children, 5, [Sends]),
TopCount (Descendants([Zone].CurrentMember, 2),3,[Sends] )

) DIMENSION PROPERTIES [Zone].[level1].[Key],[Zone].[level2].[Key] ,
[Zone].[level1].[Name], [Zone].[level3].[Name]

on axis (1)
FROM [All Communication Analysis]
"Cindy Lee" <cindylee (AT) hotmail (DOT) com> wrote in message
news:%23MdhawvsEHA.2808 (AT) TK2MSFTNGP14 (DOT) phx.gbl...
I'm getting demension properties like this:
DIMENSION PROPERTIES [Zone].[Level1].[Key],[Zone].[Level2].[Key]
on rows.

But in my output I get colums

[Zone].[Key] and [Zone].[Key]

and reporting services can't tell the difference?

is there anyway to:
DIMENSION PROPERTIES [Zone].[Level1].[Key] as Key1,[Zone].[Level2].[Key]
as
Key2
on rows.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Changing MDX columns in output

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Changing MDX columns in output - 10-15-2004 , 04:14 PM

Re: Changing MDX columns in output - 10-15-2004 , 04:26 PM

Re: Changing MDX columns in output - 10-15-2004 , 05:21 PM