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
- 6200 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
how u will determine the performence tune will occur either in report or system
What do you understand by the term 'aggregate advisor?'
Why cognos decision stream is used?
Define olap designer?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
What are the components used in web tier?
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
What are the different types of reports present in cognos?
Explain the different types of views used in cognos.
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
what do u mean by bridge group? where we r using this one?
What is the difference between regular dimension and derminant?
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
faq's on cognos
Give me any example of semi and non additive measures?
