MDX Query question - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Analysis Services (2000)

MDX Query question

Author

Topic

techuser
Starting Member

2 Posts

Posted - 2002-09-06 : 12:49:46

I am writing an MDX query and I want to know if there is anyway to immitate the following SQL:

SELECT fieldname AS 'newfieldnamefordisplay'
OR
SELECT 'newfieldnamefordisplay' = fieldname

My MDX looks about like this:

SELECT
{ Measures.Members,[Measures].[foo] } ON COLUMNS,
{ [foo2].[foo3].CHILDREN,
[foo2].[foo3].[MemberName]} ON ROWS
FROM [Cubename]
WHERE ([foo4].[foo5])

I would like to say something like:

SELECT
{ Measures.Members,[Measures].[foo] } ON COLUMNS,
{ [foo2].[foo3].CHILDREN,
[foo2].[foo3].[MemberName] AS 'NewName'} ON ROWS
FROM [Cubename]
WHERE ([foo4].[foo5])

I would appreciate any help. Thank you.

chadmat
The Chadinator

1974 Posts

Posted - 2002-09-06 : 13:20:45

Look up WITH MEMBER in BOL.

You can define a member, and call it whatever you want. Just define it as the ROWS member.

-Chad

techuser
Starting Member

2 Posts

Posted - 2002-09-06 : 16:25:56

Thanks. I got it to work with using:

WITH MEMBER [foo].[new name] AS '[foo1].[foo2]'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources