This discussion is archived
0 Replies Latest reply: Mar 6, 2012 10:50 AM by 922161 RSS

TOP 10 this MDX query

922161 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points