SQL Server Performance

Analysis Services - Left Join

Discussion in 'Analysis Services/Data Warehousing' started by jhaas, Oct 29, 2004.

  1. jhaas New Member

    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.
    jhaas, Oct 29, 2004
    #2

  2. satya Moderator

    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.
    satya, Nov 1, 2004
    #2

  3. jhaas New Member

    The optimize schema gives me the message "Private and Virtual dimensions cannot be optimized"
    jhaas, Nov 1, 2004
    #2

Share This Page