UNION between 4 QUERY subjects ?

[sanchoniathon]

Hi,

Using Framework manager v10.1.1 and we have 3 name spaces as suggested by forums and documentation:
DataBase View
Business View
Presentation View

And under our "Business View" name space we have 2 other business views name spaces as follows:

BusinessView-US
+QuerySubject1
+QuerySubject2

BusinessView-CAN
+QuerySubject1a
+QuerySubject2a

These 2 name spaces have 2 query subjects each.
They have the same number of "query items" in them as well the same number of FILTER folders.

BusinessView-CAN has data related only to Canada.
BusinessView-US has data related only to US.


Intention: We want to make a JOIN between those 2 namespaces in order to have both Canada and United States data in the same name space in order to be able to create only 1 package based on that newly created name space.

I know we can select a query subject from one specific name space and then CTRL + SELECT the other query subject from the other namespace and:
- Click on the "ACTION" menu
- Select the "Define Query Set" sub menu
- ect ...

Question:
- I don't seem to see how to import the "FILTER" folders from each of the "query subject" name spaces Or in fact to import both query subjects of each name space.
- I don't know if this is even possible.

Thanks

[saumil287]

Hi,
If you want union of 4 querys then place all 4 in one nmspace.
The datatype, No of columns, order of dataitems should be match.
Regarding filters, the filter you need to set manually on all the query subjects.

Filter will only bring the related rows of data in a table.

So you need to filter all the query subjects(qs) and then apply a union on all 4 qs.

This will work and reports get generated properly.

Thanks & Regards
saumil sanghvi

[sanchoniathon]

Thanks Saumil,

I manage to get what i wanted. I copied the filters i need and then went inside all of them to modify its' source query item.

[sanchoniathon]

Hello,
(This is a refresh on what i've tried so far)

In Framework manager:

In Business View Layer i have a nameSpace called "USA" that contains:
2 query subjects named: "HeaderUSA" and "DetailUSA" which are already joined but in our DataBaseView Layer by using a specifc "IDHeader" + a "UniqueID" equal to 'USA'.
It contains only USA data.

In another Business View Layer i have another NameSpace called "CAN" that contains
2 other query subjects named: "HeaderCAN" and "DetailCAN" which are already joined but in our DataBaseView Layer by using a specific "IDHeader" + a "UniqueID" equal to 'CAN'.
It contains only CANADIAN data.

GOAL:
We want to make a UNION between those 2 nameSpaces in order to have them in the same package that we are planinng on deploying on cognos connection based on the newly created nameSpace.

This is what i do:
1- Create a new nameSpace called "UsaCan" in which my new query subjects from the JOIN will reside

2- I then click on query subject "HeaderUSA" from nameSpace "USA" and CTRL + Click on "HeaderCAN" from nameSpace "CAN"
3- Click on the menu: ACTIONS | DEFINE QUERY SUBJECT
4- Give a name to this new query subject like: "USA+CANHeaders"
5- I make sure the operator is a UNION
6- Make sure that the check box "Remove duplicate rows" is checked.
7- I move that newly created query subject under the new NameSpace "UsaCan" created earlier

8- I repeat same same steps but with "DetailUSA" and "DetailCAN" query subjects from nameSpaces "CAN" and "USA"

9- SO i know have 2 newly created query subject under our newlcy created nameSpace


Question:
Do i need to recreate a new JOIN here in our Business View Layer between "USA+CANHeaders" and "USA+CANDetails" as it was done in the DataBaseView Layer?

Thanks !