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.
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.
Thank you cognostechie.