Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  Java table functions using Dynamic Query Extensibility

    Posted 03/24/20 12:08 PM
    Hi Team,

    Would need a help if anybody have used the feature of Java table function using Dynamic Query Extensibility in Cognos Analytics. I have gone through the developer guide in SDK but have few queries. I am wondering once the java table function is defined and imported the jar file to the cognos analytics, how and where it will be exposed to the report authors. If it is from custom sql, what will be the data source to select in the properties of the Custom SQL? Any detailed steps or document is highly appreciated. Thanks in advance

    ------------------------------
    Sesidhar A
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Java table functions using Dynamic Query Extensibility

    Posted 03/26/20 09:23 AM
    Please see the following:
    https://www.ibm.com/support/knowledgecenter/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.dg_dqe.doc/c_dg_dqe_write_table.html

    As per the above, your custom table function can be invoked from anywhere in Cognos where you can enter your own custom Cognos SQL, e.g., FM, report authoring, or data modules.  You can choose any data source for the custom sql.

    ------------------------------
    Jason Tavoularis
    ------------------------------