I am using Visual Studio 2008 Analysis Services and processing the AdventureWorks database to create and process a cube. When I click on the dropdown menu for the field, I see all the fields listed, and if I choose "Show Empty Cells", I see all of the members showing up. The peculiar thing is that every customer has at least one purchase, but many are showing up as "empty" for the given member, i.e., has no Internet Sales figure attached to that name. These so-called "empty" members do show sales values when I independently verify the results by running a view against the table. The members for which I do show values are almost always correct, which means that the application is selectively excluding customers from showing up as having purchases, but accurately returning calculations for the customers it finds.
I find the entire situation quite mysterious, and your help in this matter is greatly appreciated.
Thank you, ~Peter Ferber