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

What is the use of 'individual data source' option while using filter in query studio?

1 Answers   Thomson Reuters,

what are the applications of the tabular model ????

5 Answers   iFlex, iGate,

It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha

0 Answers  

How to use Cascade Macro in Report studio? Anybody know about Cascade Macro & and the procedure to use?

1 Answers   Niteo, AIG,

what is a bookmark? what concept we use in bookmarking? please tell me how to create bookmarks(with explore)?

2 Answers   IBM,

17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?

3 Answers   TCS,

Where do you set security levels for users in reports?

5 Answers   HCL,

we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....

1 Answers   IBM,

Can you explain new content durability?

0 Answers  

how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com

0 Answers   NEC,


4 Answers   IBM, TCS,

difference between imprompt and reportnwt1.1

2 Answers   HSBC,