2. What is With Clause In Cognos?

Answers were Sorted based on User's Feedback

2. What is With Clause In Cognos? ..

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;

Is This Answer Correct ?    1 Yes 0 No

2. What is With Clause In Cognos? ..

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 This Answer Correct ?    1 Yes 2 No

Post New Answer

More Cognos Interview Questions

4. How many dimensions did you use in your reports?

0 Answers   IBM,

what is materialised view? why we use it in data warehousing?

5 Answers   HCL,

How do we drill through from a powerplay cube to reportnet?\

0 Answers   IBM,

1. Explain your project.

0 Answers   IBM,

What is snapshot thumbnail

3 Answers  

1.Can we create a cube in a Transformer from multiple IQD's ?if so, how? 2.Also , explain some of the best practises used ,while creating a cube in powerplay transformer.

2 Answers   Satyam,

What is set to be Cognos configuration?

0 Answers  

Wht is difference between content store and content manager?

2 Answers   Tech Mahindra, Satyam,

what is the difference between cascading prompt and drill-thru

4 Answers  

Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

0 Answers  

In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Genelally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my problem,,,,,

2 Answers   Tech Mahindra,

How you will do the estimation for a task?

1 Answers   iGate,