mdx query

• niha.736

  Ten Centuries

  Points: 1210

  More actions

  November 22, 2012 at 5:19 am

  #271140

  Hi, for below query , i need to avoid hardcoding for any particular year, i need to get any year data which i will select later while browsing report.

  WITH MEMBER [Measures].[ParameterCaption] AS

  [Date DIM].[ISO Week Hierarchy FI].CURRENTMEMBER.MEMBER_CAPTION

  MEMBER [Measures].[ParameterValue] AS

  [Date DIM].[ISO Week Hierarchy FI].CURRENTMEMBER.UNIQUENAME

  MEMBER [Measures].[ParameterLevel] AS

  [Date DIM].[ISO Week Hierarchy FI].CurrentMember.Level.Ordinal

  SELECT {[Measures].[ParameterCaption],

  [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS ,

  filter(

  [Date DIM].[ISO Week Hierarchy FI].[ISO Week FI].ALLMEMBERS,

  Right([Measures].[ParameterCaption],4) = '2012'

  )

  ON ROWS FROM

  [POS OLAP Daily Material Sales]

  thanks,

  niharika