2 Replies Latest reply: Jul 24, 2014 8:20 AM by Vishal-Oracle RSS

    How we can filter the members based on attributes using ASO MDX

    Vishal-Oracle

      How we can filter the members based on attributes using ASO MDX?

       

      SELECT {Descendants ([1_Account],LEVELS([1_Account],0)) }

      ON COLUMNS,

      {Filter([1_Cost Center].members,[1_Cost Center].CurrentMember =[1_AllocAccountR].[85151010] )} on ROWS

      FROM Alloc1R.Alloc1R

      WHERE ([DC],[GenealogyAllocation],[ACT],[FY14],

      [2_Cost Center].[NoMember],[3_Cost Center].[NoMember], [4_Cost Center].[NoMember], [5_Cost Center_intra].[NoMember], [2_Project].[NoMember], [1_Project].[NoMember]

      )

       

      The code marked in yellow, is suppose to filter and provide output only the cost center which has 85151010 attribute tagged to it  - but this outputs all the cost centers


      Thanks,

      Vishal