"Missing" Data / Data Not Making It Into AS2005 Cube

All of the data in one of my fact tables in the relational db doesn't seem to be making into the cube. However, all of the data from our sales fact table is indeed making into the cube.

There is no filtering going on in the Named Query in the DSV that brings in this data. What could it be? The table's relationship? Dimension Usage?

I also developed a small test cube and was able to see all of the data. I would hate the thought of having to rebuild/redevelop the cube from scratch.

I've tried everything that I could think of.

Any thoughts?

Hello. One possible explanation can be that the service account, running SSAS2005, do not have permissions in your relational db. Are all you fact tables in the same database /data warehouse? Do you have several data source systems?

Regards

Thomas Ivarsson

|||I think I'm making progress on the troubleshooting.

I just deleted a lot of the dimensions in the Dimension Usage tab for this particular measure group. In doing so, all of the data is now there.

I will slowly add the dimension relationships back to see which one is the cause and then will try to understand why that is the case.|||I figured it out.