SSRS - Get TOP N Items - Filter with MDX
Jan.27, 2007 in
Geeky/Programming
In your Query Builder, you can filter a dimension using MDX, here is how you get the TOP N
TOPCOUNT({Dimension Member},N,{Measure.Value})
Comes in pretty handy for building reports.
Tags: SSRS 2005
Simlar Posts
- SSAS: Changing Object Id’s Breaks Report Builder Reports
- SSAS: Create a Calculated Measure always getting the value for "Yesterday"
- SSAS: AverageOfChildern and Semi-additive measure requires a time dimension
- SSAS 2005: Cube Perspectives Are Good, But Something Is Missing…
- SSAS 2005 - Named Sets - TopCount - Static/Dynamic and Ordering
Leave a Reply