Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: ccbarbeau on 21 Feb 2011 10:41:26 AM

Title: 2 queries work independently, but not together
Post by: ccbarbeau on 21 Feb 2011 10:41:26 AM
Ok, this is driving me mad.

I have 2 calculated fields in FM. Both are related to a work order.

I have 2 queries, one for each field, that give me the expected results when I run them.

However, when I try to make a report that looks like: Work Order    Field 1     Field 2

The data no longer makes sense. I've tried varying the relationship in FM (using different cardinalities) but nothing seems to be giving me the result I need.

Any ideas?

Thanks,

CC
Title: Re: 2 queries work independently, but not together
Post by: RobsWalker68 on 21 Feb 2011 01:45:41 PM
Hi,

What result are you getting that doesn't make sense and what result do you expect to have?

Thanks
Title: Re: 2 queries work independently, but not together
Post by: ccbarbeau on 21 Feb 2011 01:49:56 PM
Hi,

I (well, actually my boss) found what was wrong. My link in FM was OK but I was missing one.

All is well now.

Thanks!

CC
Title: Re: 2 queries work independently, but not together
Post by: PRIT AMRIT on 21 Feb 2011 09:10:58 PM
Lucky u.. .got a technically sound BOSS around  ;D
Title: Re: 2 queries work independently, but not together
Post by: Arsenal on 22 Feb 2011 10:41:40 AM
Quote from: PRIT on 21 Feb 2011 09:10:58 PM
Lucky u.. .got a technically sound BOSS around  ;D

Not always the best thing, since BS'ing becomes harder  :P
Text only | Text with Images