MDX Filter Scenario

• vinodkm

  Mr or Mrs. 500

  Points: 547

  More actions

  September 12, 2014 at 3:35 am

  #296094

  I have one mdx filtration scenario, PFB he details.

  My requirement is i have to filter mdx query base on condition .. for example if Cost Center Name is equal to 'HR' then I dont want to list out some cost heads like 'Allocation Cost' in my result. PFB my normal query please help me to modify this query to get my output.

  *******************

  SELECT

  NON EMPTY

  {[Measures].[Amount]} ON COLUMNS

  ,NON EMPTY

  {

  [Cost Head].[Cost Head Name].[Cost Head Name].ALLMEMBERS

  *

  [Finance Indicator].[Fin Indicator Desc].[Fin Indicator Desc].ALLMEMBERS

  }

  ON ROWS

  FROM [Finance]

  WHERE

  (

  [Date].[Financial Year].&[2013]

  ,[Cost Head].[Exprnditure Flag].&[Revenue]

  ,[Cost Center].[Cost Center Name].&

  ---

  )

  *****************

  Thanks in advance 🙂

  Vinod