Question & Answer
Question
What is the method of defining Union, Intersect and Except in Cognos Analytics 11 Framework Manager?
Answer
Union, Intersect and Except operations can be performed at the metadata modelling level or stage.
Steps on how to define Union, Intersect and Except are as follows:
1. Open Cognos Analytics 11 Framework Manager and find the package that you want to edit.
2. Click on ‘Actions’ at the top of the program.
3. Click on ‘Define Query Set’.
4. Specify a name for the Union query subject.
5. From the drop-down list, select ‘Union’ option.
6. Select the query subject you want to Union with your first query subject.
7. Repeat steps 1-6 to create Intersect and Except.
Related Information
[{"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Framework and Map Manager v11x","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.0","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
15 June 2018
UID
swg21999403