-------------Diff b/w Union and Unionall?
Answer Posted / abd hfz
UNION gives result set of only distinct values from both
tables where as UNION ALL selects all values including
duplicates.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
Explain the characteristics of cognos?
Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?
How do you call a store procedure within a transformation?
How can I schedule reports in cognos?
-----------------What is Direct and Conventional loading?
Can you define materialized view?
---------------Tell me about DWH Concepts?
What you mean by drill across?
What do you understand by the cognos?
Explain difference between powerplay transformer and power play reports?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.