can we join 2 different queries? One has 10 columns and
other has 5+ columns?

Answer Posted / the_xxx

yes you can join two diff queries based on common key data
item, you cannot union them ( for union both queries must
have similar data items and order of the items)..hope this
helps.

Is This Answer Correct ?    18 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is power prompt in cognos ep7series?what is the use of this?

3201


How the Bursting happens in same report and how to Print the bursting Report?

1441


What is called Cognos powerplay?

614


1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

1691


Tell me about Dnamic and Static Dashboards?

1863






How to Reset Pagenumbers in one report.

2205


What is main advantage datawarehousing over oracle?

558


What is a Transformer?

648


What is the use of powerplay web viewer in cognos?

554


What is meant by Reportstudio shortcut?

1723


What are the main services provided by application tier?

560


What is model?

551


What is the use of powerhouse?

612


What is the difference between a cascading report and drill through report?

650


How to create model and how to test model?

604