I am still learning MDX and am struggling with a query that is feeding a SSRS report. What I am trying to do is provide a data set that breaks down the measures by Product Family, Machine and then Product Code. This is a parameterized query from SSRS where
the three groupings are all multi-select parameters.
I have been experimenting with Non Empty and the NonEmpty function trying to eliminate rows that contain all NULL's for all measures. The query below does accomplish that. However, during my troubleshooting, I noticed one case when I failed to eliminate
the null rows. In that case, there was one row that had 2 columns with data. All the rest were NULL. No matter how I formulated the query I could not get that one row to show up with the others AND have the rest of the rows with NO data filtered out.
The query below I captured using the Profiler & Excel and then hacked it to give me what I wanted. The result set includes many columns that are percentages so my desire was to use the Aggregate function in the report for the grouped roll-ups to ensure
that I am getting the appropriate aggregates. Speaking of which, how do I have the rollup aggregate values restricted to only the data displayed in the report? In other words, what I am seeing is that the aggregate is for the entire grouping including items
filtered out of the report. For example, I see t
View Complete Post