How to list LCM Jobs in SAP BO WebIntelligence

This post shows one possible way to create the list of SAP BO LCM jobs using the SAP BO BI Universe in SBOPRepositoryExplorer.

 

Prerequisites:

Some required components:

  1. SAP BO BI 4.x Platform;
  2. XML file with predefined CMS query;
  3. IDT to configure SBOPRepositoryExplorer connection and the universe;
  4. WebIntelligence to create the document.

For this example I’m using SAP BO BI 4.1 SP2.

 

Create CMS query for LCM Jobs:

We can create an XML file with next content:

  1. <?xml version=’1.0′ encoding=‘ISO-8859-15′?>  
  2. <Tables xmlns=“https://www.w3.org/2011/SBOPTables�?>  
  3. <Table>  
  4.     <TableName>LCMJOBS</TableName>  
  5.     <TableDescription>LCM Jobs</TableDescription>  
  6.     <BOQuery>SELECT SI_ID,  
  7.                     SI_CUID,  
  8.                     SI_NAME,  
  9.                     SI_DESCRIPTION,  
  10.                     SI_OWNER,  
  11.                     SI_OWNERID,  
  12.                     SI_PARENTID,  
  13.                     SI_PARENT_CUID,  
  14.                     SI_PARENT_FOLDER,  
  15.                     SI_PARENT_FOLDER_CUID,  
  16.                     SI_RECURRING,  
  17.                     SI_CREATION_TIME,  
  18.                     SI_DESTINATION_CMS_NAME,  
  19.                     SI_DOC_SENDER,  
  20.                     SI_ENDTIME,  
  21.                     SI_FLAGS,  
  22.                     SI_INSTANCE,  
  23.                     SI_JOB_EXPORT_FILE_NAME,  
  24.                     SI_JOB_STATUS,  
  25.                     SI_NEW_JOB_ID,  
  26.                     SI_SCHEDULE_STATUS,  
  27.                     SI_SOURCE_CMS_NAME,  
  28.                     SI_STARTTIME,  
  29.                     SI_STATUSINFO,  
  30.                     SI_UPDATE_TS  
  31.                 FROM  
  32.                     CI_INFOOBJECTS  
  33.                 WHERE  
  34.                     SI_KIND=‘LCMJob’</BOQuery>  
  35.     <BOFields>SI_ID,  
  36.               SI_CUID,  
  37.               SI_NAME,  
  38.               SI_DESCRIPTION,  
  39.               SI_OWNER,  
  40.               SI_OWNERID,  
  41.               SI_PARENTID,  
  42.               SI_PARENT_CUID,  
  43.               SI_PARENT_FOLDER,  
  44.               SI_PARENT_FOLDER_CUID,  
  45.               SI_RECURRING,  
  46.               SI_CREATION_TIME,  
  47.               SI_DESTINATION_CMS_NAME,  
  48.               SI_DOC_SENDER,  
  49.               SI_ENDTIME,  
  50.               SI_FLAGS,  
  51.               SI_INSTANCE,  
  52.               SI_JOB_EXPORT_FILE_NAME,  
  53.               SI_JOB_STATUS,  
  54.               SI_NEW_JOB_ID,  
  55.               SI_SCHEDULE_STATUS,  
  56.               SI_SOURCE_CMS_NAME,  
  57.               SI_STARTTIME,  
  58.               SI_STATUSINFO,  
  59.               SI_UPDATE_TS</BOFields>  
  60.     <DatabaseFieldTypes>INTEGER,  
  61.                         VARCHAR(100),  
  62.                         VARCHAR(256),  
  63.                         VARCHAR(256),  
  64.                         VARCHAR(50),  
  65.                         INTEGER,  
  66.                         INTEGER,  
  67.                         VARCHAR(100),  
  68.                         INTEGER,  
  69.                         VARCHAR(100),  
  70.                         BIT,  
  71.                         TIMESTAMP,  
  72.                         VARCHAR(256),  
  73.                         VARCHAR(50),  
  74.                         TIMESTAMP,  
  75.                         INTEGER,  
  76.                         BIT,  
  77.                         VARCHAR(256),  
  78.                         VARCHAR(256),  
  79.                         INTEGER,  
  80.                         INTEGER,  
  81.                         VARCHAR(256),  
  82.                         TIMESTAMP,  
  83.                         VARCHAR(256),  
  84.                         TIMESTAMP</DatabaseFieldTypes>  
  85.     <BOFunction>NOFUNC,  
  86.                 NOFUNC,  
  87.                 NOFUNC,  
  88.                 NOFUNC,  
  89.                 NOFUNC,  
  90.                 NOFUNC,  
  91.                 NOFUNC,  
  92.                 NOFUNC,  
  93.                 NOFUNC,  
  94.                 NOFUNC,  
  95.                 NOFUNC,  
  96.                 NOFUNC,  
  97.                 NOFUNC,  
  98.                 NOFUNC,  
  99.                 NOFUNC,  
  100.                 NOFUNC,  
  101.                 NOFUNC,  
  102.                 NOFUNC,  
  103.                 NOFUNC,  
  104.                 NOFUNC,  
  105.                 NOFUNC,  
  106.                 NOFUNC,  
  107.                 NOFUNC,  
  108.                 NOFUNC,  
  109.                 NOFUNC,  
  110.                 NOFUNC</BOFunction>      
  111. </Table>  
  112. </Tables>  

Configure Universe Connection attaching the XML file:

To attach our XML file definition to our universe we must create an universe connection in IDT into a project, for example:

SBOPRepositoryExplorer_IDT_LCMJobs

SBOPRepositoryExplorer_IDT2_LCMJobs

 SBOPRepositoryExplorer_IDT2_LCMJobs

SBOPRepositoryExplorer_IDT3_LCMJobs

 

Create the Universe:

After connection configured we can create the Data Foundation and Business Layer:

SBOPRepositoryExplorer_IDT4_LCMJobs

SBOPRepositoryExplorer_IDT5_LCMJobs

Test the Universe:

When universe is already created we can do a test before publish to CMS:

SBOPRepositoryExplorer_IDT6_LCMJobs

 

Publish Universe to CMS:

After test we can publish to CMS:

SBOPRepositoryExplorer_IDT7_LCMJobs

 

Create report in BI LaunchPad with WebI:

After published the universe we can use in WRC and in BI LaunchPad:

SBOPRepositoryExplorer_QUERYPANLE1_LCMJobs

and the report can be like:

SBOPRepositoryExplorer_WEBI1_LCMJobs

Thanks and enjoy.

Jorge Sousa

 


Leave a Reply

Subscribe

  • Facebook
  • Twitter
  • Google+
  • RSS Feed
  • YouTube