Re: Cognos Impromptu

"Vikas Agnihotri" <usenet_at_vikas.mailshell.com> wrote in message news:2qtl3dF13ckk6U1_at_uni-berlin.de...
> 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

You are asking in the wrong place. Go to http://support.cognos.com In the meanwhile- Impromptu is a report writer, not a database programming tool. It contains its own analytic functions. There are catalog settings that can be adjusted to influence the optimizer. Received on Thu Sep 16 2004 - 09:15:22 CDT