Re: Cognos Impromptu

Vikas Agnihotri wrote:

> Does anyone have experience working with Cognos Impromptu against Oracle
> 9.2?
>
> I am getting frustrated with Cognos' seeming inability to use any
> Oracle-specific advanced features. All it seems to be able to handle is
> generic table/column/view stuff.
>
> Does anyone know if I can use, for example,
> 1. refcursors
> 2. CURSOR() expressions in queries
> 3. Analytic functions
> 4. dbms_session.set_context() before running the Cognos report. This
> sets a parameter to a view that has (where c1=sys_context(...) and by
> pushing the predicate where it belongs, it makes the view run much faster)
>
> (4) above is really what is impeding me right now. Any way this can be
> done in Cognos?
>
> I find it hard to believe that the premier BI tool out there cannot
> leverage all the nice new features in Oracle.
>
> Thanks

If you want to work with REF CURSORS then you can do that with Crystal Reports ... any version after 8 or look at Oracle Reports.

Cognos is not going to ever do what you want.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)