Hello, I am running into an issue where CurrentMember DOES NOT return all
members at the lowest level. Here's my dimension Hierarchy -->
[Week].[Week].[Week Name]

I want to have it return the following when I select [Week].[Week
Name].CurrentMember
Week of 09/04/2006
Week of 09/11/2006
Week of 09/18/2006

But it is returning at the ALL level
All

Once I can return all members using CurrentMember, I should be able to use
CurrentMember.PrevMember to return Total Revenue for the previous member,
same as Lag(1). If anyone can shed some light on how to return all members
at the lowest level using CurrentMember, I would truly appreciated! If
there's an alternate way of NOT using CurrentMember, please feel free to let
me know.

-Lawrence

Below is my current MDX not returning all members at the lowest level though.

WITH MEMBER [Measures].[Growth] AS
{ ([Week].[Week].CurrentMember.PrevMember, [Measures].[Total Revenue]) }
SELECT
[Measures].[Growth] ON COLUMNS
, nonempty( [Week].[Week].[Week Name].ALLMEMBERS ) ON ROWS
FROM [GMDSummary]

replacing the column by [Measures].[Total Revenue], would you get all the
weeks then?
just want to make sure it has values on the week level.

"Lawrence" wrote:

Yes. I would get all the week members with either [Week].[Week].[Week
Name].AllMembers or [Week].[Week Name].CurrentMember.Children

Could you explain why [Week].[Week Name].CurrentMember could not produce all
the weeks? I DO NOT think I can use Children and PrevMember at the same
time, so still trying to find out how to use CurrentMember.PrevMember...

Help is appreciated!
-Lawrence

"yongli" wrote:

If you want to return all members at the level of [Week Name],

[Week].[Week].[Week Name].Members is enough. Of course, it does not contain
All member and any other calcualted members at the level. If you use
AllMembers, it also contains All member and any other calcualted members at
the [Week Name] level.

And why [Week].[Week].CurrentMember could not produce all the weeks?

Here CurrentMember function returns only Current Member pointing to the
current cell in the cube. For example, if you look at cells within the Week
of 09/04/2006, it returns only the week member not all week members.

Ohjoo


"Lawrence" <Lawrence (AT) discussions (DOT) microsoft.com> wrote