Hi,
Im fairly new to MDX and have the query that I need now. I dont really want to go back and modify the query as its alot of work getting the result i needed initially. Anyways:
I have my matrix up and running and sorted descendingly on the sum(value) I just want to show the top 5 rows, is there anyway to do this within the reporting side without having to go back to the query?
Thanks
Cipriani
Unforunately, I cannot think of anyway to force only the first five rows to show unless you modify the query to return only five rows. Can you just add a "SELECT TOP 5" to your SQL someplace? I know it's a pain, but it's the only foolproof way.
The filter function may work for you as well (just set a filter in the properties of your matrix). But, you have to have a condition in the dataset that you are filtering on (I tried RowNumber but that doesn't work). So I'm afraid either route will require some modification of your SQL.
The other pitfall here is that you'll have to add all your sorting conditions to the SQL; otherwise the first five rows may not be the five you want.
If you want some help with the SQL I can do that. Just post back with the code you're having trouble with. Maybe we can help sort it out for you.
"The Enrichment Center is required to remind you that first you will be baked, then there will be cake." - GLaDOS
Posting Permissions 
LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks