Hi
I'm having problems displaying a dimension member. My MDX Statement is as
follows:

WITH
MEMBER [Years].[Year 2004] as 'SUM([2004]:[2004])'
MEMBER [Years].[Year 2003] as 'SUM([2003]:[2003])'
MEMBER [Years].[Diff] as '[Year 2004]-[Year 2003]'
MEMBER [Measures].[MyProperty] as
'[Dimension1].CurrentMember.PROPERTIES("MyProperty")'
SELECT
({[Measures].AllMembers}*{[Year 2004] ,[Year 2003], [Diff]}) on columns,
[Dimension1].Children on rows
from MyCube

The Resulting Data is like this

Dimension1.member1 |
Dimension1.member2 |
etc...

Now I want to show the [MyProperty] Measure as a single column, like this

Dimension1.member1 |
Dimension1.member2 |
etc...

But Instead I get the Year2003,Year2004 and Diff Dimension all the same for
[MyProperty]

Does anyone know how to achieve this?

Greetings

Michele

Michele Gerundo wrote:
Did you try the syntax:

SELECT
...
ON COLUMNS,
[Dimension1].Children DIMENSION PROPERTIES
[Dimension1].[MyProperty]
ON ROWS
FROM
MyCube

I am not sure if the tool you are using does support showing these, I
know that the Sample application doesn't show Dimension properties in
this case.

Thank you for your solution.
I've tried this before, but the tool I'm using (ThinSlicer) doesn't show
it.

Anyway, I've solved my problem (using WITH MEMBER) and Crossjoins


"Hans van Kruijssen" <hans.vanKruijssen (AT) agilisys (DOT) com> schrieb im Newsbeitrag
news:ea2qLuDWEHA.2288 (AT) TK2MSFTNGP10 (DOT) phx.gbl...