none
member property values in drilldown option

    Question

  • 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
    Friday, July 05, 2013 10:34 PM

All replies

  • 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, 

    Tuesday, July 09, 2013 9:13 AM