Skip to Content

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

27 Comments
You must be Logged on to comment or reply to a post.
  • 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 ?

    • 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

      • 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

          • 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

  • 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?

        • 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

  • 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

    • 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.

  • 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


  • 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

      • 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

        • 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

          • 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