The cube I have created in analysis services loses data as I add dimensions. I have verified that the dimensions are not missing any information. I believe the problem is with the joins. I would like to change the default to a 'left outer join' this works when I test it through query analyzer. How do you change the join properties in analysis services? Or how do you view the SQL stmt for the cube? Thanks to anyone who can point me in the right direction. John.