Cognos Analytics Reporting: Query Structures/References

[dougp]

Would one of you Report Studio gurus still running 10.2.1 or 10.2.2 help me out?  I'm using 11.0.4 and testing 11.0.7, but I need to know if the behavior of the query editor in 10.2.x is what I remember.

• Create a new list report using the samples data (GO Sales).
• Add some data items to the list.
• Add a query (Query2).
• Drag Query1 to the right of Query2 to make Query1 the source for Query2.
• Open (edit) Query2.
• What appears in the Data pane?  Does Cognos restrict your options to only data items that exist in Query1?
• Add all of the data items from Query1 to Query2.
• On Page1, drag out Query2 to create a new list.
• Validate the report (it should validate).
• Run the report (it should run).
• Add a query (Query3).
• Open Query2.
• Select all of the data items and copy.
• Open Query3.
• Click into the Data Items pane and paste.
• Query3 now contains references to Query1, even though Query1 is not defined as the source for Query3.
• On Page1, drag out Query3 to create a new list.
• Run the report.  Does it fail with some sort of reference error?
• Validate the report.  Does validation fail?

For convenience, I have attached the results of developing this report in 11.0.4.  It validates and runs in 11.0.x.  Data|Source shows all of the query subjects from the package and Data|Data items shows all of the queries in the report, regardless of what query I am editing.
To open it in 10.2.x, I think you'll just need to fix the first line.

[MFGF]

What appears in the Data pane?  Does Cognos restrict your options to only data items that exist in Query1?

Hi Doug,

Yes - exactly this. I can see the items from Query 1 in the source pane.

Validate the report (it should validate).

Yes - it validates fine.

Run the report (it should run).

Yes - I see the original list fed from Query1 followed by the new list fed from Query2

Run the report.  Does it fail with some sort of reference error?

Nope. It runs and renders three lists - the first from Query1, the second from Query2 and the third from Query3.

Validate the report.  Does validation fail?

Nope. I get "The report specification is valid"

For convenience, I have attached the results of developing this report in 11.0.4.  It validates and runs in 11.0.x.  Data|Source shows all of the query subjects from the package and Data|Data items shows all of the queries in the report, regardless of what query I am editing.
To open it in 10.2.x, I think you'll just need to fix the first line.

I'll open it and take a look next. I think the report spec version needs to be 12.0 so I'll edit the xml to switch the version.

I'm doing this testing on 10.2.2 :)

MF.

[MFGF]

Hi Doug,

Your report spec opens fine (after changing the Schema to 12.0 and the Style Version to 10)

Validating the report returns "The report specification is valid"

Running the report renders all three lists.

Cheers!

MF.

[dougp]

So the behavior has always been that way.  What has changed is the display and the apparent inability to use query items from queries other than the one intended as the source.

Thank you very much for taking the time to perform this test.

[MFGF]

So the behavior has always been that way.  What has changed is the display and the apparent inability to use query items from queries other than the one intended as the source.

Thank you very much for taking the time to perform this test.

You are very welcome, sir! :)