RE: MDX CurrentMember.Name Problem

#1

Hello,

try to query the name via ....Currentmember.Properties("Name")

HTH
Jörg

WITH
MEMBER [MEASURES].[Dimension Name] as
'[Customers].CurrentMember.Properties("Name")'
MEMBER [MEASURES].[Dimension Level] as '[customers].CurrentMember.UniqueName'
SELECT
{[MEASURES].[Dimension Name],[MEASURES].[Dimension Level]} on columns,
{[Customers].Members} ON ROWS
FROM [Sales]

"J Aure" wrote:

Quote:

I'm trying to use a query like the following:

WITH
MEMBER [MEASURES].[Dimension Name] as '[Dimension].CurrentMember.Name'
MEMBER [MEASURES].[Dimension Level] as '[Dimension].CurrentMember.UniqueName'
SELECT
{[MEASURES].[Dimension Name],[MEASURES].[Dimension Level]} on columns,
{[Dimension].Members} ON ROWS
FROM [Cube]

The problem with this is that, for some reason, a couple of the members are
returning blank values as their names within the dimension.

Has anyone else encountered this problem before? Is there a solution?

Thanks!

Joe

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

RE: MDX CurrentMember.Name Problem

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

RE: MDX CurrentMember.Name Problem - 08-27-2004 , 05:47 AM