Skip to Content
Author's profile photo Nanda Kumar

Running BObj Web Intelligence reports from CPS – Dynamic values and Limitations

You can import Web Intelligence reports into SAP CPS from BObj Enterprise system using the SAP_BObj_ImportReportDefinitions.

After you import them, you can directly submit those WebI reports, by right clicking and selecting submit from the context menu.

You can select the format of the output and the destination of the output as either FTP or SMTP, as shown below:

9-11-2014 4-25-38 PM.png

When you select SMTP destination, you have to provide the SMTP destination details.

One of the features that was not covered in the administration guide is that, you can pass dynamic values the same way you do in BObj Enterprise.

9-11-2014 4-36-49 PM.png

and the parameters are evaluated and set by the BOE system. The output received for the above job:

9-11-2014 4-32-10 PM.png

Note that Subject %SI_NAME% has been resolved to Input Controls And Charts.

Limitation:

  1. One of the main limitations to be noted is that, the attachments cannot be renamed.
    As you can see in the above example, even though the attachment was named as OUTPUT, the attachment in the email is BOE generated name.
  2. WebI reports can be imported, but without the prompt parameters. There is no way to pass the prompt parameters.

These limitation are applicable until version M33.112(the latest available while writing this blog).

SAP has notified that this will be fixed in an upcoming patch.

According to note 2128711 – SAP CPS 8.0 by Redwood: M33.116,

  • Multiple BOBJ Report Parameter Values Should be Separately Considered
    It is now possible to use multiple values in a BOBJ report parameter

So M33.116 may have started supporting prompt parameters, but i have not tested it yet.

Readers are more than welcome to report their findings if they tested, in the comments below.

thanks

Nanda

Assigned tags

      28 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Marc Rosson
      Marc Rosson

      Have you been able to schedule WebI BICS connection reports?  Cannot get them to import with parms. If we manually add the parms, we cannot get the values to get picked up by WebI.   Working with Waldorf, but so far no luck in scheduling dynamic parameterized WebI BICS reports.  Have you done this before ?

      Author's profile photo Nanda Kumar
      Nanda Kumar
      Blog Post Author

      Hi Marc,

      There is a limitation on CPS 8 (at least until patch M33.112) that WebI reports cannot be imported with their prompt parameters. Adding them manually does't work either.

      thanks

      Nanda

      Author's profile photo tinku cheerla
      tinku cheerla

      Hi Nanda,

      We are on M33.104. We have to schedule Webi reports with prompt parameters. Can you please suggest a way of doing it.

      Thanks,

      TInku

      Author's profile photo Nanda Kumar
      Nanda Kumar
      Blog Post Author

      Hi Tinku,

      There is no way to schedule Webi with prompt parameters from CPS 8.0 M33.112.

      thanks

      Nanda

      Author's profile photo Doris Payne
      Doris Payne

      Hi Nanda,

      We are on version M33.116-90989. The Webi BICS prompts do not import in our version, and I have attempted to manually add them but unsuccessful in getting BOB to recognize them. I have been successful in importing Webi based on .unv to import and have been able to automatically schedule these reports.

      Do you know fi M33.166-90989 should be able to support Webi BICS prompts?

      Thanks,

      Doris

      Author's profile photo Nanda Kumar
      Nanda Kumar
      Blog Post Author

      Hi Doris,

      According to note 2128711 - SAP CPS 8.0 by Redwood: M33.116,

      • Multiple BOBJ Report Parameter Values Should be Separately Considered
        It is now possible to use multiple values in a BOBJ report parameter

      there is no mention of support for WebI BICS reports, i recommend creating an OSS incident to get the answer.

      thanks

      Nanda

      Author's profile photo tinku cheerla
      tinku cheerla

      Hi Nanda,

      Our BW team wants to use BOBJ scheduler to schedule the webi reports but they want to monitor them from CPS, Can you please advise how can we monitor the webi reports from CPS which are scheduled using BOBJ scheduler . We are on Build M33.104.

      Thanks,

      Tinku

      Author's profile photo Nanda Kumar
      Nanda Kumar
      Blog Post Author

      This is not possible at the moment.

      The reports have to be scheduled from SAP CPS/BPA.

      thanks

      Nanda

      Author's profile photo Former Member
      Former Member

      Hi Nanda,

      Steps I followed to connect to BOBJ system as per the CPS Admin Document are as follows:

      1. Select Environment > SAP > New SAP System

      2. In Tab, SAP System -

           - Name;

           - J2EE URL (http://<BOBJ HOST (Server Name)>: <Port> (Check connection - get "Valid connection String")

           - App. Server Load balancing - checked

           - Job Handling - All

           - Time Zone - CET

           - Application - SAP Businses Objects

      3. In Tab, J2EE

           Type - BOBJ

           User Name / Password - Admin User Id / Pswd of BOE     

      The connection failed with error - "No BIPlatform or DataServices"

      can you please help me if I am missing something and correct the configuration between BOBJ and CPS?

      Author's profile photo Nanda Kumar
      Nanda Kumar
      Blog Post Author

      hi Sree,

      what is the BOBJ Url are you providing?

      It should not be 6400 port. The URL should be hitting your tomcat server.

      for example, with default settings the URL will be like http://myhostname:8080

      Try and let me know.

      thanks

      Nanda

      Author's profile photo Former Member
      Former Member

      Thanks Nanda. I tried with tomcat server but it failed? Is there anything that I need to configure in BOE too?

      Author's profile photo Nanda Kumar
      Nanda Kumar
      Blog Post Author

      No, you do not need any configuration in BOE.

      Just make sure the user in BOE has administrator access.

      When you go to the same url in a browser, you should see something like this. Then it is the correct URL.

      11-11-2015 9-56-19 AM.png

      Can you please provide screenshot of your URL with the error you are facing.

      thanks

      Nanda

      Author's profile photo Former Member
      Former Member

      Hi Nanda,

      we're currently using BO to Schedule our Crystal-Reports. Since we're querying a Database, we have to fill out the connection Tab in our BusinessObjects Launchpad.

      When we import a normal report into SAP-BPA, we are able to schedule it just fine, if we try to schedule a report with a DB-Query, the schedule always fails with the error

      "connection not possible: wrong login credentials".

      do you know where we can store the credentials?

      Thanks!
      Jonas

      Author's profile photo Nanda Kumar
      Nanda Kumar
      Blog Post Author

      hi Jonas,

      Credentials can be stored under Security tab. But in your case, the problem may be with the type of report you are running. I recommend creating an OSS incident with SAP.

      Let us know if you are able to find a solution.

      Author's profile photo Sanjay Awasthi
      Sanjay Awasthi

      Hi Nanda,

      We are working on setup connection between CPS M33.79 and BOBJ 4.0 ( BO ) by the below process:

      1. Select Environment > SAP > New SAP System

      2. In Tab, SAP System -

           - Name;

           - J2EE URL (http://<BOBJ HOST (Server Name)>: <Port> (Check connection - get "Valid connection String")

      [ Here I am giving Tomcat Path]

           - App. Server Load balancing - checked

           - Job Handling - All

           - Time Zone -

           - Application -

      3. In Tab, J2EE

           Type - BOBJ

           User Name / Password - Admin User Id / Pswd of BOE     

      The connection failed with error - Connection Failed: java.lang.NullPointerException


      Please help me in sort out this.

      Regards,

      Sanjay Awasthi


      Author's profile photo Nanda Kumar
      Nanda Kumar
      Blog Post Author

      hi Sanjay,

      Null Pointer exception may be caused by a bug, can you please provide the complete the error stack trace?

      Your CPS build is pretty old, so i recommend checking the OSS notes and creating an incident with SAP.

      thanks

      Nanda

      Author's profile photo Former Member
      Former Member

      Hi Nanda,

      Do we have any recent updates on scheduling BO reports (webi) through Redwood CPS tool?I mean the webi reports with prompt values. Passing the prompt parameter values to Redwood and trigger them.

      Thanks

      San

      Author's profile photo Nanda Kumar
      Nanda Kumar
      Blog Post Author

      hi San N,

      I did not test it, but according to 2217259 - SAP Business Process Automathion by Redwood, Version 9.0.15.1, BPA build 9.0.15.1 has added 6 additional data service parameters, and also as per 2182216 - SAP Business Process Automathion by Redwood, Version 9.0.14.1 they have improved Support for Webi parameters with multiple data providers. So you might want to upgrade to check them out.

      I will update the blog, if test it.

      thanks

      Nanda

      Author's profile photo Sanjay Awasthi
      Sanjay Awasthi

      Hi Nanda,

      Yes. It was due due to a bug in M 33.79 and fixed from version M 33.90.

      1899257 - SAP CPS 8.0 by Redwood: M33.90   Potential NPE in BOBJ Connector when Login Response Contained aNamespace :-   A potential NPE has been fixed which prevented a BOBJprocess server from connecting to a BOBJ system.

      I have upgrade it to M 33.120 and it works for me.

      Thanks for your reply.

      Regards,

      Sanjay Awasthi

      Author's profile photo Nanda Kumar
      Nanda Kumar
      Blog Post Author

      Happy to help.

      thanks

      Nanda

      Author's profile photo Former Member
      Former Member

      Hi,

      We are not able to import and run the Bobj reportin CPS Redwood BPA(9.0.16.2) from SAP Business Objects using below methods..

      SAP_Bobj_ImportreportDefinitions -  When importing bobj reoprt using this status is completed.

      SAP_BObj_ReportRun - But when running report it is ending with error.PFA.

      Please advise...

      Regards,

      Sudarshan

      Author's profile photo Former Member
      Former Member

      Hi Nanda,

      We are not able to find the reports after import job ran completed in CPS BPA 9.0.Could you please let us know where can we find the imported Webi reports? and how to submit them?

      Regards,

      Sudarshan

      Author's profile photo Vikram Kankam
      Vikram Kankam

      Hi Nanda,

      We have import Web Intelligence reports into SAP BPA  9 from BObj Enterprise system using the SAP_BObj_ImportReportDefinitions.

      After  import them, we  submit the WebI reports via SAP_BOBJ_ReportRun, it completes successfully, but we don't see the parameter/option to select format nor smtp to the send email to user .

      Could you please explain how were you able to get those parameters to select the format and SMTP options .

      Appreciate your immediate response.

      Thanks,

      Vikram

      Author's profile photo Former Member
      Former Member

      ReportParameterValues.JPG

      Author's profile photo Former Member
      Former Member

      Hi Gerden,

      Could you please provide how to get Report Parameter values into CPS BPA.We are able to see Prompt Parameters  and sending mail through SMTP successfully.

      ReportParameterValues.JPG

      Author's profile photo Nanda Kumar
      Nanda Kumar
      Blog Post Author

      Have you checked the documentation, whether it is support for all BOE reports?

      I recommend creating an incident with SAP for a faster answer.

      thanks

      nanda

      Author's profile photo Former Member
      Former Member

      Hi Nanda,

      We are giving Below parameters in "In Parameter Mappings"  "Text Tab" below.(Even not saving as it is in Text Tab) But Output is not getting in Email as it is.It is getting in one line continuously.PFA. Could you please provide solution..P.F.A.

      We need exact Email output as below:-

      Name:2000_FCST_SAT_PIR_DELETE STEP-1

      Job:2000_FCST_SAT_PIR_DELETE STEP-1

      Program: RM60RR20

      Variant: 2000_PIR_DELBK

      Triggered from Redwood messaging.

      But getting Email output as below:-

      Text.jpg

      Regards,

      Sudarshan

      Author's profile photo Aparna Mariserla
      Aparna Mariserla

      Hi Nanda,

      Can we schedule AO reports (BOBJ)  using BPA redwood ? im getting an error “Report null is not schedulable” can you please help ?

      Regards,

      Aparna