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

To report this post you need to login first.

27 Comments

You must be Logged on to comment or reply to a post.

  1. 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 ?

    (0) 
    1. Nanda Kumar 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

      (0) 
      1. 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

        (0) 
      2. 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

        (0) 
          1. 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

            (0) 
  2. Sree Ravula

    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?

    (0) 
        1. Nanda Kumar 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

          (0) 
  3. Jonas Br├╝ggen

    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

    (0) 
    1. Nanda Kumar 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.

      (0) 
  4. 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


    (0) 
    1. Nanda Kumar 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

      (0) 
      1. San N

        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

        (0) 
        1. Nanda Kumar 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

          (0) 
          1. 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

            (0) 
              1. Sudarshan Reddy

                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

                (0) 
                1. Sudarshan Reddy

                  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

                  (0) 
  5. 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

    (0) 
      1. Sudarshan Reddy

        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

        (0) 
        1. Nanda Kumar 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

          (0) 
          1. Sudarshan Reddy

            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

            (0) 

Leave a Reply