I have a cube with Customer, Item, and ServerTime dimensions and several measure groups. I'm concentrating this query on my Forecast measure. The forecast fact table is linked to the customer dimension via customer account and company id and to the item dimemsion via Item Id and company id. As long as I include the Customer Name attribute from the Customer dimension I get the correct results. When I try to query the Item dimension by itself I get only partial results. If I remove the Customer dimension from the cube and re-query then the results are correct. I have been over the linking in the dsv and the Dimension usage and have not found any problems. What could i be missing here? This is SSAS 2008 64 bit on Windows Server 2008. the OLTP db is on SQL 2005 on a separate server and I am using MOLAP.