Answer / chiru

Apart from SQL Queries... When we need to generate a report
as per above requirement, first of all drag and drop deptno
(lets assume having deptno=10, 20, 30), After that drag and
drop "workers" Query item.... After that apply grouping on
deptno Query Item.... If u apply grouping on deptno.. it
automatically gets totals of all workers group by deptno...
But as per our requirement go to cummary and apply total icon
on workers Query item...
after that again apply average option from summary on workers
Query Item...
Now u can get both average and summary for deptno wise.. i.e
when u run the report......

Answer / lakshmi reddy

select avg(depttotal) from (select sum(sal) as depttotal
from emp group by deptno)

how u will design the report if the objects are available

0 Answers   Ness Technologies,

---

How to pass parameter value into html design page?

1 Answers  

---

What is Cardinality b/w Fact to Fact?

4 Answers   IBM,

---

Hi, In My Table i am having a Column Emp ASa Fullname In My Report I WAnt First name&Lastname?how I'll Get This One?Pls Ans Me

2 Answers  

---

How can we Maintain the Cube Security by Category level and Dimension level ?

0 Answers  

---

How can we create regular dimensions & measure dimensions?

2 Answers  

---

What r the names of the reports that you prepared?

0 Answers  

---

what type of charts we create mostly in realtime? plz help

4 Answers   IBM,

---

What is Crossproduct?

2 Answers  

---

I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.

2 Answers   IBM,

---

i have a table with 3 columns country,empname,salary and i want the query for get the  name of the employees who is getting top 2 nd highest salary for individual country? Thanks in advance 

2 Answers   IBM,

---

what do you mean by parallel execution of query?

1 Answers   Mind Tree,

---