I have a member(s) in my dimension table and fact table that is:

JAN 2000

The following MDX
With
Member [Measures].[WhatIsUp] as '[Cal Year].currentmember.Name'

Returns: 1/1/2000

The data type for the period level of my dimension is Char.

When I browse the hierarchy in either the Dimension Editor or Cube
Editor, it displays the desired result: JAN 2000

What's going on here? How can I get CurrentMember.Name to reflect the
Current Member's Name?

Thanks in advance.

I just noticed that this only happens in the MDX Sample Application --
which makes this issue less critical for me.

I use the MDX Sample Application to fine tune my MDX before moving it
to MSRS (Since you can't even tell what you are looking at when the
data is returned in MSRS).

I wonder why the results are not consistent? It is kind of a pain
because you think you have something finished and then you realize you
don't (or vice verse).

If anyone knows the answer to this I would be interested. No hurry...