0 Replies Latest reply: Mar 6, 2012 12:50 PM by 922161 RSS

    TOP 10 this MDX query

    922161
      Hi!
      I made the mdx query, how ever, it is necessary to fill the fields default?

      SELECT
      NON EMPTY
      {[Measures]. [Fact movements Entries Count], [Measures]. [People Quantity]}
      ON COLUMNS,
      TopCount (

      NonEmpty (
      {(
      [Dim Prisoners]. [Establishment Macroregion]. [Establishment Macroregion]. AllMembers *
      [Dim Time]. [Year Time]. [Time Year]. AllMembers *
      [Dim Time]. [Month Name Time]. [Time Month Name]. AllMembers *
      [Dim Time]. [Month Time]. [Month Time]. AllMembers *
      [Dim criminal classification]. [Description criminal classification]. [Description criminal classification]. AllMembers
      )
      }, [Measures]. [People Quantity]), 10)

      ON ROWS
      FROM (SELECT ([Dim Prisoners]. [Establishment Macroregion]. & [Northwest])
      ON COLUMNS
      FROM (SELECT ([Dim Time]. [Month Time]. & [4]))
      ON COLUMNS
      FROM (SELECT ([Dim Time]. [Time Year]. & [2012])
      ON COLUMNS FROM [DW]))

      fields are highlighted parameters, let default values ?? for verification.