Hello, Fact table has x number of records, when I process the cube, I don't get x number of records, some records are missing. What can I check to see where the problem is? Running SQL Server 2008 R2. Thanks.John C. Hill

Are you doing full process , partial ? Maybe new dimension are added and you did not process them. Try to do full process and see if you get them in Cube. Thankshttp://sqlage.blogspot.com/

Thanks. I am doing a full process and making sure to process the dimensions first. I tried creating a new cube by using only one dimension and fact table. That worked. I then added each new dimension table separately and processing the cube after each dimension was added. That seemed to work. Maybe there was something wrong with the cube. But at least I have a working cube now. Thanks! JohnJohn C. Hill