Translate

Set Operation (UNION, EXCEPT, INTERSECT) in Cognos Framework Manager

Framework Manager supports following set operations:
  • UNION - merges data from both the queries.
  • EXCEPT - only the rows that exist in the first query which are not present in the second.
  • INTERSECT  - only the rows that are common to both the queries.

Note: In order to apply SET operation, queries must contain Same Number of Data Items, Same Data Types and in the Same Order.


Select the Query Subjects in the model --> go to Actions menu --> click on Define Query Set

 


Example:





4 comments:

Unknown said...

I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in IBM Cognos Transformer Design OLAP Models (v10.2.2) - SPVC (J2A82G-SPVC)
, kindly contact us http://www.maxmunus.com/contact
MaxMunus Offer World Class Virtual Instructor led training on in IBM Cognos Transformer Design OLAP Models (v10.2.2) - SPVC (J2A82G-SPVC). We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us:
Name : Arunkumar U
Email : arun@maxmunus.com
Skype id: training_maxmunus
Contact No.-+91-9738507310
Company Website –http://www.maxmunus.com


Unknown said...

Very Good informative Article Cognos Tm1 Online Training Hyderabad

Unknown said...

Very Good informative Article Cognos Tm1 Online Training Hyderabad

Veera Blogspot said...

Very nice post,keep Updating more Articles with us.

Thank you...

Cognos TM1 Training

Cognos TM1 Online Training Hyderabad