Cognos Analytics

 View Only

  • 1.  SDK Install

    Posted Thu January 14, 2021 03:29 PM
    I am developing a Java application that needs to trigger Cognos reports.  It seems that that best way to do that is by using the SDK.  What is the easiest way to install it?  We have corporate servers that host Cognos Analytics 11.1.x, so I don't need to run it locally on my development computer.  Can I just install the SDK without installing all of Analytics?  If so, how do I obtain just the SDK?

    Doug

    ------------------------------
    Doug Williams
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: SDK Install

    Posted Fri January 15, 2021 01:57 AM
    Hi Doug, 

    SDK is part of Cognos Analytics 11.1.x installation; you don't need to download/install it separately. You can see a folder called SDK in your cognos installation directory. 
    Also, look at cognos mashup services in case that could help your scenario of calling reports from your java application. And lastly, don't forget to look at the new REST API that is included in 11.1.7 which you can consume from your application. 

    Regards


    ------------------------------
    Kiran Passumarthi
    www.linkedin.com/in/kiranpassumarthi
    ------------------------------

    Original Message


  • 3.  RE: SDK Install

    Posted Fri January 15, 2021 09:44 AM
    Hi Kiran,

    I have not installed Cognos Analytics on my computer, so I don't have access to the SDK.  We do have a corporate installation of Cognos Analytics that is available for everybody to use via the web interface.  That's why I'm wondering if I can install just the SDK without installing the Analytics package.  I've reached out to our Cognos team to see if they can give me the SDK, but I have not heard back from them yet.

    I have not looked into the mashup service yet, but I do remember seeing it mentioned in some posts.  I will look into that some more.

    I have researched the new REST API and the swagger interface, but it's not clear as to how to trigger reports using it.  I see ways to start sessions and manage items such as roles, tenants, users, etc, but I don't see a way to trigger a report.

    Doug

    ------------------------------
    Doug Williams
    ------------------------------

    Original Message


  • 4.  RE: SDK Install

    IBM Champion
    Posted Fri January 15, 2021 04:06 AM
    Cognos Analytics 11.1.x, has ability to trigger so there is no need to install SDK. 




    ------------------------------
    Adnan Sheeraz
    ------------------------------

    Original Message


  • 5.  RE: SDK Install

    Posted Fri January 15, 2021 09:19 AM
    Hi Adnan,

    Can you provide some details as to how to trigger a report using Cognos Analytics?  I am unfamiliar with Cognos and do not have Analytics installed on my system.  The reason that we need to write a Java application to trigger the report is because we have a use case where the user needs the ability to run a Cognos report that could include > 1,000,000 items to search for, and Cognos doesn't allow them to select that many (at least that's how it was explained to me).  So we will have them import a CSV file with all of the items, and then trigger the report and include the list of items.  We also need to keep track of the items for historical purposes, which we would do in our applications database.

    If Analytics were used to trigger the report, does that mean that each user would have to have Analytics on their system, or how would that work?  We do have a corporate, server-based, installation of Analytics.

    Doug

    ------------------------------
    Doug Williams
    ------------------------------

    Original Message


  • 6.  RE: SDK Install

    Posted Mon January 18, 2021 03:10 AM
    Hi Doug, 

    If this is your requirement and considering your need for maintaining historical updates, you can import the data into database tables along with the import date and in your report always consider the latest dated records in the query. A user can run the report and select other prompts, if any, during the run time of the report. 

    However, I wonder who in the world would want to select 100000 values for a prompt every time they run the report !!! If there is a hierarchy for that information then you can create cascading prompts and let them pick a few parent values that can determine what child values have to be considered for filters. 

    Regards

    ------------------------------
    Kiran Passumarthi
    www.linkedin.com/in/kiranpassumarthi
    ------------------------------

    Original Message


  • 7.  RE: SDK Install

    Posted Mon January 18, 2021 03:45 AM

    on the trigger question:

    In the Cognos Analytics install folder, there is a SDK folder that contains various sample scripts to code against CA... take a look at SDK\Java\EventTrigger for an example of starting an event by a trigger...

    The reports can be scheduled in CA using a Trigger name - give it a unique name and the Eventtrigger is basically asking CA to start all events with that name,,,

    Torben



    ------------------------------
    Torben Noer
    Offering Manager, Cognos Analytics and Planning Analytics
    IBM
    ------------------------------

    Original Message