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.  Content Store: parsing delivery options

    Posted 05/29/20 12:05 PM
    Hi All,

    Business has requested a list (report) showing all schedules details (name, when, what, format, etc..). I am trying to extract the information from the content store.

    So far, I see that most of the information is available in "cmobjprops26", in the field "delivoptions".
    I'm currently trying to parse the XML contained in this field. I do manage to use this technique in Cognos for other purposes but in this case, I'm facing the following error message: "namespace prefix "xsi" is not declared".
    I've been trying with: xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" but it is not recognized.
    I don't know which namespace (xmlns) should be referenced for this "xsi". Can you please help?

    Thanks!

    PS: any other way of extracting the schedule details from the database would be welcome.

    ------------------------------
    Cosme POUSSET
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Content Store: parsing delivery options

    Posted 06/01/20 10:52 AM
    I don't have answer to your question, but have some general questions about how to extract similar information from Cognos.  I've had request from management requesting information like: 1) Who gets which reports?  2) How many reports per day/week/month are delivered?  3)  Can you chart for me report delivery by hour of day?  Report delivery by day of week?

    Are there Cognos tools or ways of providing answers to these type of questions without having a programming background?

    ------------------------------
    jerome roberts
    ------------------------------



  • 3.  RE: Content Store: parsing delivery options

    Posted 06/02/20 10:51 AM
    Hi Jerome,

    As mentioned by Hemal Patel, I think that you should look into the things provided by Motio.

    Cheers

    ------------------------------
    Cosme POUSSET
    ------------------------------

    Original Message


  • 4.  RE: Content Store: parsing delivery options

    Posted 06/01/20 03:59 PM
    ​Hi Cosme,

    I think you should try Motio PI free version and you would be able to get this information easily.

    Best,
    Hemal

    ------------------------------
    Hemal Patel
    ------------------------------



  • 5.  RE: Content Store: parsing delivery options

    Posted 06/02/20 10:54 AM
    Hi,

    I can't use things related to Motio here, as I need something that I can use directly in SQL, PL/SQL code, etc  ..

    KR
    Cosme

    ------------------------------
    Cosme POUSSET
    ------------------------------

    Original Message


  • 6.  RE: Content Store: parsing delivery options
    Best Answer

    Posted 06/03/20 03:03 AM
      |   view attached
    Hi,

    You will find, in attached file, 2 complex queries I developed (one for Oracle and the other for SQL Server 2016+). They display information as path, last execution date, output format, param values list, recipients list (to, cc and bcc), etc...

    CMOBJPROPS26.DELIVOPTIONS seems to contain a list of 5 fields separated by semicolon :
    - delivery option name
    - property enum
    - delivery option type
    - number of characters of the last field
    - content of delivery option in XML format

    In my samples, I extract XML part of toAddress, ccAddress and bccAdress delivery options.
    After namespace cleaning, I could parse XML.

    I think we can go further. It's a beginning ;-)

    Have a good day,


    ------------------------------
    DAVID MOULIN
    Analytics expert
    Micropole
    Levallois-Perret
    ------------------------------

    Attachment(s)

    txt
    obj_information.txt   22 KB 1 version
    Original Message


  • 7.  RE: Content Store: parsing delivery options
    Best Answer

    Posted 06/05/20 09:41 AM
      |   view attached
    Hi,

    In attached file, SQL Server queries to parse CMOBJPROPS26.DELIVOPTIONS column.
    It remains to parse XML fragment of each option.

    Have a nice weekend,

    ------------------------------
    DAVID MOULIN
    Analytics expert
    Micropole
    Levallois-Perret
    ------------------------------

    Attachment(s)

    txt
    runOptions.txt   864 B 1 version
    Original Message


  • 8.  RE: Content Store: parsing delivery options

    Posted 06/06/20 06:48 AM
    Hi David,

    Thanks for your answers and sharing useful information. This is very interesting.
    Sorry for my late answer, but I had other urgent topics to solve in the meantime.
    Meanwhile, I found my solution, but I would keep an eye on your code in case what I implemented appears to be not "perfect".

    Thanks!

    ------------------------------
    Cosme POUSSET
    ------------------------------

    Original Message


  • 9.  RE: Content Store: parsing delivery options

    Posted 06/10/20 11:51 AM
    Thanks for this discussion

    ------------------------------
    https://coolmathunblocked.weebly.com/
    https://8ballpoolbilliards.weebly.com/
    ------------------------------

    Original Message


Related Content