COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: cognosrebel on 25 Sep 2005 11:07:18 PM

Title: Can someone tell me how to use Tabular Reference with Gosales Package
Post by: cognosrebel on 25 Sep 2005 11:07:18 PM
I have a situation where I need to call query item from Query A in Query B. I think I can do it using tabular reference. Can someone show the functionality of tabular reference...with an example from gosales package?

Thanks

Cognosrebel
Title: Re: Can someone tell me how to use Tabular Reference with Gosales Package
Post by: BIsrik on 26 Sep 2005 01:54:59 AM
try that yourself...

Srik
Title: Re: Can someone tell me how to use Tabular Reference with Gosales Package
Post by: cognosrebel on 26 Sep 2005 10:22:34 AM
I tried it and is getting a error saying Circular reference.

Ok, here is what I did. I put Product line and Product Type in Query A and Product name and product Description in Query B. Then, I put a tabular reference in query A referencing query B.

Now, in query A, I am able to see all 4 query items and tried to create a list report out of it.

I get the error saying product name and product description is having circular reference.

Hope someone can help me out here.
Title: Re: Can someone tell me how to use Tabular Reference with Gosales Package
Post by: cognosguru on 12 Oct 2005 01:39:02 PM
Hello,

I just ran into this situation and the cause of Circular Reference was the following:

Because both of the details were named Tabular Model 1 it sees it in both places and thus "goes around in circles trying to figure out which one of Tabular Model 1 to get".Ã, 

In order to solve it, rename Tabular Model 1 to a unique descriptive name.Ã,  Then it works.Ã, 

Good luck.