COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: c8guru on 03 Jul 2007 12:24:47 PM

Title: Tabular Reference in C8
Post by: c8guru on 03 Jul 2007 12:24:47 PM
Has anyone tested C8 to see if the queries results are reused like they were with Tabular References?  In C8, all you can do is copy a query which I believe is supposed to work like a Tabular Reference.  However, we are not seeing any performance improvement versus creating two Queries with different filters.  Before we get into tracing the SQL at the DB level I though I would check with the forum.
Title: Re: Tabular Reference in C8
Post by: MDXpressor on 03 Jul 2007 12:30:30 PM
Actually, to use a query like a tabular reference, go to the query explorer and nest the source query directly against the delivery query.  I doubt a copy of the query would reuse the result set.
Title: Re: Tabular Reference in C8
Post by: c8guru on 03 Jul 2007 12:52:30 PM
Thanks MDXpressor.  That's what I was looking for.