SSRS filter values missing from a SSAS datasource

I recently ran into a problem where the list of values in a filter were missing for a dimension. It was due to having a fact relationship from the dimension to a very small fact table. In fact, the table was empty. I resolved it by changing the relationship to a regular relationship. Sure it will be less efficient, however the fact table is expected to be very small.

About Clay Lenhart

I am a DBA/Technical Architect for Latitude Group and love technology.
This entry was posted in SSAS, SSRS. Bookmark the permalink.

5 Responses to SSRS filter values missing from a SSAS datasource

  1. Max Wright says:

    Thanks for one’s marvelous posting! I truly enjoyed reading it, you may be a great author.I will remember to bookmark your blog and will eventually come back sometime soon. I want to encourage that you continue your great work, have a nice morning!

  2. Great write-up. I am a normal visitor of your web site and appreciate you taking the time to maintain the excellent site. I’ll be a regular visitor for a really long time.

  3. That is really attention-grabbing, You’re an excessively professional blogger. I’ve joined your rss feed and stay up for searching for extra of your great post. Also, I’ve shared your web site in my social networks

  4. Blake Smith says:

    Thanks for your article. I also think that laptop computers have become more and more popular right now, and now tend to be the only sort of computer employed in a household. The reason being at the same time they are becoming more and more economical, their computing power keeps growing to the point where they can be as robust as desktop through just a few in years past.

  5. I actually have one on order. Unfortunately, I am experiencing the same shipping delays as everyone else. I ordered mine 6/19 and confirmation email says they are on back order. Eleven days an counting as of today.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>