what is the difference between native sql and cognos sql?
- 1 Answers
- 1086 Views
- I also Faced
- E-Mail Answers
Answer / Jalaj Gupta
Native SQL refers to using standard SQL syntax for database queries directly, while Cognos SQL is IBM's proprietary query language used within the Cognos Business Intelligence platform. The main differences are that Cognos SQL provides a more user-friendly interface, supports complex calculations, and offers features such as prompt handling and data aggregation, which are not typically available in native SQL.
| Is This Answer Correct ? | 0 Yes | 0 No |
what is textsource variable
In Drill through, Reports are executing successfully when rename & run the created reports? Pls tel me the reason?
what is the procedure for scheduling conditional rendering?
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
What is dtm?
what are the components having in the report studio using interface eg:insertable objects pan,properties pan
Usage of Stored Procedures in Cognos
1 Answers General Motors GM, TCS,
write a query to display the third record from the employee table?
Q1. We have a crosstab report which is having product, region and Revenue information. Now the requirement is that we need to add a new column with the information 'High' and 'Low' just beside the Revenue column. If Revenue is high is should display as 'High' and if Revenue is low then it should display as 'Low'. Q2. If my Cube size is 2GB, now I have got the requirement to reduce it. What are the parameters I have to follow to reduce the cube size? Q3. How to get the 2nd highest salary of an employee without using any function (I mean without rownum etc.)? Q4. What is the difference between joins and scope relationship?
what are the features in cognos8ui
Diff b/w Crossproduct and Outerjoin?
------------What is Slicer memberset?
Teradata 
