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.  Custom Controls and Scriptable Reports API

    Posted 16 days ago

    Hello,

    I've been using the Scriptable Reports reports heavily since the beginning of the year.  I think this API is super powerful and gives us the ability to build amazing stuff.

    Now I am looking for information if the Scriptable Reports API will usually receive updates and future support - is there a place where I can submit suggestions and follow up its development?

    For e.g. one limitation is that there is no native API handling for something like on demand query load - the connected datasets to the custom control are always loading immediately - I want to be able to trigger the load on demand. 

    With the Scriptable reports API I've built a full on custom control prompt page - I've utilizied the full parameter pushdown and other concepts the API offers.

    In a separate custom control I've built a solution where the resulting dataset is evaluated and the unique values are being used as parameters to call an API - so effectively these custom controls can actively work as alternative to the Progress DataDirect Autnoumous Rest Driver to access APIs with front-end calls from browser.

    So yeah this Scriptable reports API and future development is of massive interest for me so I am posting here with the hopes of connecting to anyone who is responsible for it to bring in my feedback and ideas and hopefully to connect to other people who utilize it, exchange ideas, current solutions etc.



    ------------------------------
    Kris K
    ------------------------------


  • 2.  RE: Custom Controls and Scriptable Reports API

    Posted 12 days ago

    Hey Kris,

    I've done a lot with this. When it comes to getting additional data on demand what I like to do is to create a separate report and call that using CMS. 

    https://server/ibmcognos/bi/v1/disp/rds/reportData/searchPath/content/folder[@name='FolderName']/folder[@name=%22SubFolderWith'Apostraphe%22]/folder[@name='Folder%20Name']/report[@name='ReportName']?async=off&fmt=datasetJSON


    To pass parameters the best way is to use the xmlData param:

    &xmlData=<promptAnswers><promptValues><name>Date_Range</name><values><item><RangePValue><inclusive>true</inclusive><start><inclusive>true</inclusive><useValue>2025-08-01</useValue><displayValue>Aug 1 2025</displayValue></start><end><inclusive>true</inclusive><useValue>2025-08-14</useValue><displayValue>Aug 14 2025</displayValue></end></RangePValue></item></values></promptValues><item><SimplePValue> <inclusive>true</inclusive><useValue>[Employee summary].[Time] .[Time].[Year]-%26gt;[Time].[2006]</useValue> <displayValue>2006</displayValue></SimplePValue></item></values></promptValues> <promptValues><name>pRegion</name><values><item><SimplePValue><inclusive>true</inclusive> <useValue>[Employee summary].[Employee by region].[Employee by region] .[Branch region]-%26gt;[Employee by region].[740]</useValue> <displayValue>Asia Pacific</displayValue></SimplePValue></item></promptAnswers>

    Just fetch that and you get the results in a nice json payload you can use however you want. 



    ------------------------------
    Paul Mendelson Product Manager
    Product Manager
    PMsquare
    ------------------------------