Cognos Analytics

 View Only
  • 1.  Stored Procedures

    Posted Wed August 07, 2019 09:51 AM

    Hello all,

    I'm quit new to CA and need some help.
    I'm working with CA 11.1.3 (fresh install and RedHat) and want to create reports and dashboards based on custom SQLs.

    According to the documentation, there should be a Query-icon when I start creating a new report but it isn't. Did I miss some prereqs.? Any ideas? The data source connection is" allowed for web-based modelling".

    The data source I'm using is a DB2 schema with contains a lot of tables and data. It also contains a number of stored procedures (SP), where each SP is a ready-to-use SQL-report.  Now I want to call this procedures from CA. Is that possible and if yes, how?

    Many thanks in advance!!

    BR Juergen



    ------------------------------
    Juergen Blecker
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Stored Procedures

    Posted Fri August 09, 2019 08:14 AM

    @Juergen Blecker You can use custom SQL in the data module. Steps on how to do this can be found here

    Let me know if you have any questions.



    ------------------------------
    DENNY NAREZNY
    ------------------------------