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

How to repeatly use the data items of a query for other queries?

Started by lookingforK, 21 Nov 2012 04:11:24 PM

Previous topic - Next topic

lookingforK

Hi,

I am using Cognos Report Studio 8.4 to create a report that has 3 sections.

I used query1 object for the 1st section. Query1 object includes some data items, e.g.:
Store Size (*)
Sales This Week
Sales Last Week
Sales YTD
...

I used query2 object for the 2nd section. Query2 object includes the same data items except the (*) one, e.g.:
Product Class Type (*)
Sales This Week
Sales Last Week
Sales YTD
...

I used query3 object for the 3rd section. Query3 object includes the same data items except the (*) one, e.g.:
Region (*)
Sales This Week
Sales Last Week
Sales YTD
...

So, it's time-consuming and inefficient to create 3 queries and all their data items because they share the common items.

Can I just created Query1 and reference it to Query 2 and Query 3?
If it is possible, how should I do?

Thank you in advance.

cognostechie

Since the measures are the same, you can put all of this in one query. Consider a Crosstab where you put all Sales measures in Columns and put Store Size, Product Type and Regions in rows (after each other, not within each other).

If you need to show them seperately in three sections, use three Lists/Crosstabs, point all of them to the same query and put the Store Size in one, Region in the 2nd one etc.