COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: madhancog on 15 Aug 2010 10:50:17 AM

Title: NEED suggestion in abmibuous join
Post by: madhancog on 15 Aug 2010 10:50:17 AM
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
Title: Re: NEED suggestion in abmibuous join
Post by: blom0344 on 16 Aug 2010 02:33:04 AM
If you fetch no data from the sun dim, how do you expect to get this dimension to participate in the join execution?