Cognos Analytics

 View Only
  • 1.  Content Store: parsing delivery options

    Posted Fri May 29, 2020 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 Mon June 01, 2020 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 Tue June 02, 2020 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
    ------------------------------



  • 4.  RE: Content Store: parsing delivery options

    Posted Mon June 01, 2020 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 Tue June 02, 2020 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
    ------------------------------



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

    Posted Wed June 03, 2020 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


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

    Posted Fri June 05, 2020 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


  • 8.  RE: Content Store: parsing delivery options

    Posted Sat June 06, 2020 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
    ------------------------------



  • 9.  RE: Content Store: parsing delivery options

    Posted Wed June 10, 2020 11:51 AM
    Thanks for this discussion

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