NEED suggestion in abmibuous join

[madhancog]

Hi gurus,
  I have star schema model in my project.
  I need a suggestion
  i have 1 fact and 4 dimension in my scnerio,i have dimension named control dim,sun dim,accont dim and fors dim and fact deal.
  the query i need is to get the result from account dim,deal fact and sun dim,but i am getting query in this way acount dim,deal fact and control dim,how can i make sun dim to get involved in this query

Thanks in advance
k.m

[blom0344]

If you fetch no data from the sun dim, how do you expect to get this dimension to participate in the join execution?