with


MEMBER [Measures].[Level 1 - Group(s)] AS
       [Dim Level].[Levels].Properties( "Level2 Groups" )   
     

MEMBER [Measures].[Level 2 - Owner(s)] AS
      [Dim Level].[Levels].Properties( "Level2 Owner" )
      


dimension structure is
                  

                  ID         --- member property is  Properties( "Level2 Groups" )
                  SubID      --  member property is  Properties( "Level2 Owner" )



SELECT [Measures].[Level 1 - Group(s)] ON COLUMNS,
[Dim Level].[Levels].[id].members

FROM CUBE1

ID :  1,2
SUBID  1   232,242
       2   332,442

ID          
1             GROUP NAME
  232          Owner Name
  242          Owner Name

2             GROUP NAME
  332          Owner Name
  442          Owner Name


Is it possbile write mdx for the above format,

Can we use Drilldownmember or drilldownlevel or is there any other way we can write query

thanks
v

hi vaishu, 

I don't think we can get the expected output format in SSAS. I'm curious about your requirement. Could you elaborate your business requirement with more detail? May be we can find out other way to achieve your requirement.

Serena,