SQL Server Performance Forum – Threads Archive

Analysis Services – Left Join

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.

Check whether this is available in Optimize Schema tool on the cube.
HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

The optimize schema gives me the message "Private and Virtual dimensions cannot be optimized"

]]>