If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Tabular Reference in C8

Started by c8guru, 03 Jul 2007 12:24:47 PM

Previous topic - Next topic

c8guru

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.

MDXpressor

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.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

c8guru

Thanks MDXpressor.  That's what I was looking for.