Hi,
I'm very new to MDX so am hopeful that this is a simple problem.
I have a cube that I query like this...
SELECT NON EMPTY { [Measures].[Fact Count] } ON COLUMNS,
NON EMPTY ( [Dim1].[Dim X].Children, [Dim1].[Dim Y].Children ) ON ROWS
FROM [Cube]
WHERE ( [Dim2].[4] )
...which works great. What I think I want to do is to replace the Dim X and Dim Y values with calculated members like this...
WITH MEMBER [Dim1].[X] AS [Dim1].[Dim X] - [Dim1].[Offset X]
MEMBER [Dim1].[Y] AS [Dim1].[Dim Y] - [Dim1].[Offset Y]
SELECT NON EMPTY { [Measures].[Fact Count] } ON COLUMNS,
NON EMPTY ( [Dim1].[X].Children, [Dim1].[Y].Children ) ON ROWS
FROM [Cube]
WHERE ( [Dim2].[4] )
...but this does not work.
Have I just got the syntax wrong or am I trying to acheive the results in the wrong way?
Thanks,
Cal
I'm very new to MDX so am hopeful that this is a simple problem.
I have a cube that I query like this...
SELECT NON EMPTY { [Measures].[Fact Count] } ON COLUMNS,
NON EMPTY ( [Dim1].[Dim X].Children, [Dim1].[Dim Y].Children ) ON ROWS
FROM [Cube]
WHERE ( [Dim2].[4] )
...which works great. What I think I want to do is to replace the Dim X and Dim Y values with calculated members like this...
WITH MEMBER [Dim1].[X] AS [Dim1].[Dim X] - [Dim1].[Offset X]
MEMBER [Dim1].[Y] AS [Dim1].[Dim Y] - [Dim1].[Offset Y]
SELECT NON EMPTY { [Measures].[Fact Count] } ON COLUMNS,
NON EMPTY ( [Dim1].[X].Children, [Dim1].[Y].Children ) ON ROWS
FROM [Cube]
WHERE ( [Dim2].[4] )
...but this does not work.
Have I just got the syntax wrong or am I trying to acheive the results in the wrong way?
Thanks,
Cal