Print Page - Cognos SQL, unable to convert to Native SQL

Title: Cognos SQL, unable to convert to Native SQL
Post by: cognosun on 15 Oct 2017 04:22:23 AM

Gurus,

Can anyone help me how to convert (roughly) this Cognos SQL to Oracle SQL, which is written for one derived column.

SUM(MAX(COLUMN A for COLUMN B) at COLUMN B) / COUNT ( COLUMN B at COLUMN B)
-------------

I need native SQL for the same, but with above expression, it's splitting Column B as seperate column, and sum() function is taking away decimals from the output.

Many Thanks in Advance
Joys

Title: Re: Cognos SQL, unable to convert to Native SQL
Post by: Invisi on 18 Oct 2017 06:52:43 AM

I don't know where you get this Cognos SQL from, but doesn't Cognos allow you to see the actual SQL sent to the database in Report Studio? Use that option?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: cognosun on 15 Oct 2017 04:22:23 AM