How to find the level from dimension table for a member
using MDX.

Help on how to use function <<Member>>.Level in MDX.

Thanks in advance.

There's not much more too it. Maybe this foodmart example will shed light:

WITH
MEMBER Measures.LevelName AS
'Product.CurrentMember.Level.Name'
SELECT
{Measures.LevelName} on axis(0),
Product.Members on axis(1)
FROM Sales

tom @ the domain below
www.tomchester.net


"jagan sv" <jagan_sv (AT) yahoo (DOT) com> wrote