Cognos Analytics

 View Only
  • 1.  Query Oracle System Object

    Posted Fri August 23, 2019 02:00 PM
    Hi all,

    I would like to query our Oracle instance for the time the instance was started.  The SQL string I use in SQL Developer is simple:  select startup_time from V$INSTANCE

    I'm not able to run the same query in FM, even using native SQL.  I figure it has to do with the special character but not sure how to get it working.  Perhaps needs some macro syntax?

    Thanks for the help.

    ------------------------------
    Jeremy Aude
    Channell Commercial Corporation
    Rockwall TX
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Query Oracle System Object

    Posted Sat August 24, 2019 08:25 PM
    Hi Jeremy,
    What version of Cognos are you using?
    Is there an error message shown?
    I just tried it with CA 11.1.3 and it seems to work fine as a NativeSQL statement, both in FM and Data Module UI

    Select startup_time from V$INSTANCE

    returns:
    Aug 8, 2019 2:18:10 PM

    //Henk

    ------------------------------
    HENK CAZEMIER
    ------------------------------



  • 3.  RE: Query Oracle System Object

    Posted Tue August 27, 2019 09:57 AM
    Hi Henk,

    We're on 11.0.7 (working to upgrade).  It works for me as native SQL in reporting, just not in FM:  
    BMT-MD-5002 The object 'V$INSTANCE' of type 'table or view' does not exist in the data source.

    Maybe it's a version issue?  I don't have 11.1 up to test.  I'm good with leaving it in the report for now.


    ------------------------------
    Jeremy Aude
    Channell Commercial Corporation
    Rockwall TX
    ------------------------------