TOP 10 this MDX query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

TOP 10 this MDX query

Author

Topic

bsilva.costa
Starting Member

1 Post

Posted - 2012-03-06 : 13:44:19

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.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2012-03-07 : 03:54:27

Can you please explain further what exactly you are after as it is hard to understand what you are after? Can you please include examples?

Thanks

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources