Results 1 to 4 of 4

Thread: Accessing XML from Report Source of a BI Report

  1. #1
    Member
    Join Date
    Nov 2000
    Location
    Leicester, UK
    Posts
    86

    Accessing XML from Report Source of a BI Report

    Hi All

    I'm looking to be able to access the xml file - or its contents - that is created / displayed when you view the "Report Source" for BI linked report.
    I need to be able to do this in a UBE that runs after the BI job whose Report Source I am after has been run / completed.
    Normal CSV / Pdf file outputs of a typical UBE are there in the Print Queue... but this doe not seem to be the case for the xml when viewing the Report Source. It seems this is created on the fly when taking the option to view the report source, and the system command that creates this is not available in an UBE.

    Any ideas?
    Thanking in advance
    JDE 9.2 Tools Release 9.2.3.1

  2. #2
    Member nkuebelbeck's Avatar
    Join Date
    Mar 2012
    Location
    Minnesota
    Posts
    558
    F956* are the XMLP tables. the xml you want is store in a blob column somewhere.
    Analyst/Developer
    E1: 9.2 | TR: 9.2.3.5 | JAS: WebLogic | ES: OS400
    DB: DB2 | WebDev Client: Win7Pro (64 bit), VS 2013

  3. #3
    Member
    Join Date
    Mar 2009
    Location
    Phoenix, AZ USA
    Posts
    68
    There's an older thread that discussed how to uncompress the blob data in the F95630 and F95631 tables: https://www.jdelist.com/vb4/showthre...ad-F95630-Blob
    Regards,
    Kim Schmidt

    - E1 9.1.4 ,TR 9.2.2 , iSeries, DB2
    - formerly Xe, 8.0, SQL Server, Oracle

  4. #4
    Member
    Join Date
    Nov 2000
    Location
    Leicester, UK
    Posts
    86
    Thanks to the above for their replies... and to those that may have thought of a solution for me.
    In the end I believe I won't need to do it now .. as there's some existing development earlier in the process that creates the XML output for me.... it gets moved by the time I get to it / need to get to it (used by a third party...) ... but I can handle that situation.

    Thanks again.
    JDE 9.2 Tools Release 9.2.3.1

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.