Answer / thanjairajan@gmail.com

The WITH clause may be processed as an inline view or resolved as a temporary table. The advantage of the latter is that repeated references to the subquery may be more efficient as the data is easily retrieved from the temporary table, rather than being requeried by each reference.

For example:

WITH dept_count AS (
SELECT deptno, COUNT(*) AS dept_count
FROM emp
GROUP BY deptno)
SELECT e.ename AS employee_name,
dc.dept_count AS emp_dept_count
FROM emp e,
dept_count dc
WHERE e.deptno = dc.deptno;

Answer / krishna

Specifies whether to send a request to the database using
an SQL WITH clause. When set to Yes, and if the database
supports WITH clauses, a WITH clause request is generated.
When set to No, or if the database does not support WITH
clauses, a request using derived tables is generated

Explain the different types of views used in cognos.

0 Answers  

---

difference between drill through and master detail report?

2 Answers   HCL, Zensar,

---

how u will determine the performence tune will occur either in report or system

0 Answers   Ness Technologies,

---

Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com

16 Answers  

---

what is filter?give me one example that you created a report in your project?

1 Answers   HCL, IBM,

---

------------------What is Focalpoint?

1 Answers  

---

What is slicer & dicer ? what is sub session parameter ?

2 Answers   Cap Gemini,

---

What are various types of gateways in cognos?

0 Answers  

---

how can I test reports in cagnos?

0 Answers   IBM,

---

hi, I want to create this report... List View--- -(Drop down list) Order Date From: \/ To: Customer Employee Order customer ------------------------------------------------------------ ------------------------------------------------------------ ------ customer c-name c-address c-phone c- city.................... ------------------------------------------------------------ ------------------------------------------------------------ ----- c-id c-type . . . ------------------------------------------------------------ ------------------------------------------------------------ ---- Employee .............same like one list Order.....................same like one list These are all in one page....i want u show... condtions *when i select in view type ex:employee and date as 10-05- 2007 to 10-05-2010 I need to go the employee list table and display the items .. And Iam trying in value prompt for creating of (cust,emp,ord)in a single value prompt,that will not created... and how to create 3-list and connection for those in value prompt.. Pls any one knows explain me (by step by step) of creating that report? Thanks Vannur

0 Answers  

---

what is tabular set? how can you break the report?

1 Answers   Syntel,

---

How to Create users in cognos Access Manager from 1) front end 2) back end

1 Answers   TCS,

---