Interested to Buy Any Domain ? << Click Here >> for more details...
how to create average on totals of different departments
employees salary...? consider we have 3 dept and in each
dept 10-15 workers i need to get the totals separately for
each dept and average of there totals..help me pls
- 2 Answers
- 6342 Views
- Patni, I also Faced
- E-Mail Answers
Answer Posted / lakshmi reddy
select avg(depttotal) from (select sum(sal) as depttotal
from emp group by deptno)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Why cognos decision stream is used?
how to perform back drill through in cognos 8 what is the use of it
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
How do you improve the performance of the Cognos Analytics report
--------------Diff b/w ODS and OLAP?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
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
What is model filter?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
What is the difference between regular dimension and derminant?
What are the components of report net?
-----------------What is Direct and Conventional loading?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
What is the advantage of using shortcuts?
What is main advantage datawarehousing over oracle?
