Need to correct below MDX query.

• saurabh.deshpande

  SSCommitted

  Points: 1738

  More actions

  October 17, 2012 at 5:49 am

  #151106

  Hi,

  I need to write MDX query to calculate GLOBAL_BALANCE (For MTD & For given date). I used below query. It is working for MTD but not working for "given date". Please help to correct the query.

  WITH

  MEMBER Measures.DTD as (StrToMember([@Posted Date]),

  [Measures].[Global Balance])

  SELECT {

  [Measures].[Global Balance]

  ,[Measures].[DTD] } ON COLUMNS,

  NON EMPTY { (

  [Location Enterprise].[Operations Name].[Operations Name]*

  [Location Enterprise].[Region Name].[Region Name]*

  [GL Code Combination].[BR Account Type].[BR Account Type]

  ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS

  FROM ( SELECT ( [Period].[Period Hierarchy].[Period Year].&[2.011E3] ) ON COLUMNS

  FROM ( SELECT ( [GL Code Combination].[BR PL Impact].[BR PL Impact]) ON COLUMNS

  FROM ( SELECT ( [GL Code Combination].[BR Line].[BR Line]) ON COLUMNS

  FROM ( SELECT ( [GL Code Combination].[BR Impact].[BR Impact]) ON COLUMNS

  FROM ( SELECT ( [Location Enterprise].[District Full Name].[District Full Name]) ON COLUMNS

  FROM ( SELECT ( [Location Enterprise].[FC Name].[FC Name]) ON COLUMNS

  FROM ( SELECT ( [Location Enterprise].[Region Name].[Region Name]) ON COLUMNS

  FROM ( SELECT ( [Location Enterprise].[Operations Name] ) ON COLUMNS

  FROM [SSAS_CUBE])))))))) WHERE (

  {[GL Code Combination].[Enabled Flag].&[Y]},

  {[Location Enterprise].[Source Id].&[EBS]},

  {[Location Enterprise].[Enabled Flag].&[Y]},

  {[Department Enterprise].[Source Id].&[EBS]},

  {[Department Enterprise].[Enabled Flag].&[Y]})