COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: rocket21 on 10 Jun 2016 06:58:55 AM

Title: Query Results in Report
Post by: rocket21 on 10 Jun 2016 06:58:55 AM
In Cognos 10.X, when I'm building a report, I will often go to the Query Explorer, right click on a Query, and click View Tabular Data to see the results separate from the report's design.  I find this especially useful if I have Joins/Filters/etc. developed in a particular report.

I don't appear to have this option in Cognos 11.  Does anyone know where it moved to, or if there's something similar in its place?
Title: Re: Query Results in Report
Post by: raamzs on 10 Jun 2016 08:13:15 AM
Navigate to Query explorer -> select a query> right click for option Tabular data.
Attached image for reference
Title: Re: Query Results in Report
Post by: rocket21 on 15 Jun 2016 01:04:23 PM
Thank you...I see why I was confused now.

I was clicking on:
Data > Data Items > right click on Query1 (and not seeing View Tabular Data).

Instead:
Navigate > Query explorer > right click on Query1, View Tabular Data

It's a bit confusing because they're very similar in appearance and apparent functionality.