Hi,

I have a requirement to show Top 2 members of a dimension (attribute
level). Following query works well to select top 2 members for measure
PP100.

SELECT TopCount(factor.atrribute.Members, 2, PP100) on Rows,
{Measures.Members} on Columns
From OCWCube

However, I wanted to have names of factor.attribute.members be qualified by
their parent level.

For example if factor dimension has members like following

Factor Attribute PP100
(Parent Dim) (Child Level) (Measure)
---------------------------------------
F1 A1 100
F1 A2 110
F1 A3 90
F2 A4 105
F2 A5 107
F3 A6 125

and above query selects

Attribute PP100
-------------------------
A2 110
A6 125

then I want attributes names to be fecthed as following

Attribute PP100
-------------------------
F1-A2 110
F3-A6 125

I will appreciate any help.

regards

-KulBhushan

You can create a calc that concatenates member name and parent name, but
this can't be used in place of the member.

WITH MEMBER
Measures.[LongName] AS
' MyDim.CurrentMember.Parent.Name + ' - ' +
MyDim.CurrentMember.Name '

tom @ the domain below
www.tomchester.net


"Kul" <ksharma_71 (AT) hotmail (DOT) com> wrote