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

Is it possible to create drill through access to other report from PDF report?

1 Answers   IBM,

---

Can i apply drill through on chart in report studio?

4 Answers   TCS,

---

What is Local Cache and how does it help in performance tuning

1 Answers  

---

what is sdibling function tell me the some functions

3 Answers   IBM,

---

i want to create a crosstab report where product will be on rows year on column and revenue on measure. based on the users selection in value prompt, if user select the August 15, crosstab year column should display values for aug 15, aug 14, aug 13 and aug 12 i.e for last for years but same month. how could we achieve this?

1 Answers   JPMorgan Chase,

---

---

what is the use of layout component reference

3 Answers   Satyam,

---

Explain the characteristics of cognos?

0 Answers  

---

What's the differance between each studio in cognos 8?

1 Answers   TCS,

---

What snowflake and Starschema?

2 Answers   HCL,

---

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.

0 Answers   HCL,

---

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

7 Answers  

---

In an existiing Framework model, how will you add a new column to the existing table?

6 Answers   CTS,

---