2. What is With Clause In Cognos?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

how to perform single sign in cognos by using url?

744


What do you understand by the term 'dynamic cube'?

740


How do you call a store procedure within a transformation?

767


What is the difference between regular dimension and derminant?

1905


How to publish a package by running Java Script?

1795


What is dtm?

917


how to test reports in cognos?

784


How do we convert from Numeric to be Words?

2682


what are the special features in cognos reportnet?

807


What is a Pivot?

721


what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw

2074


Can you define snapshot?

721


Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?

4420


How can we create a dynamic column name in cognos?

717


What is meant by drill down?

729