0

I have a straight up question about the SSAS Is it possible to filter out Dimension Members that have no Values in Measures?

here is my Problem

Thanks in advance

gberisha
  • 291
  • 5
  • 17

1 Answers1

0

Your image looks like you are browsing using Excel. Drop-down boxes in Excel show all dimension members. You can write MDX to populate SSRS or other reporting application drop-downs with only values that are tied to a measure or measure group using Exists or NonEmpty, but Excel doesn't have a way to do this. If you are never going to have data before 7/1/2007, you can use a view or named query to only bring dates from that day forward into your cube. If you use slicers instead of drop-down boxes in Excel, it is easier to see which dimension members have no data.

mmarie
  • 5,598
  • 1
  • 18
  • 33