difference between join and union in reportstudio?
Answers were Sorted based on User's Feedback
Answer / palzkumar
UNION is one of the set operator, which is to apply one or more queries, that results in a projection list on which other queries can be based.
JOIN is not a set operator, but it's used to joins two queries with various relationship's cardinality.
Is This Answer Correct ? | 1 Yes | 0 No |
IN REPORT STUDIO JOIN IS USED TO JOIN TWO TABLES AND
UNION IS USED TO JOIN 2 REPORTS OR QUERIES.
SHARATH
Is This Answer Correct ? | 9 Yes | 9 No |
What are various types of gateways in cognos?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
what is symmetric key?where do u use this?
how u migrate reports to cognos 8 from previous versions
-----------------What is Singleton?
1 Answers BoA, Cap Gemini, TCS,
A list box contains 1000 records, while running the list, inside the header the content has to scroll down. Note the header should not go up?
Report studio has two SQL tabs one native SQL and another one cognos SQL which one is get more preference? which one we need to consider?
7 Answers Blue Cross Blue Shield Association, TCS,
3. Differences between Cognos Sql & Native Sql? What are their Advantages and Disadvantages?
Can we install cognos on windows 7?
Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!
what is cube size?