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:
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.
and the parameters are evaluated and set by the BOE system. The output received for the above job:
Note that Subject %SI_NAME% has been resolved to Input Controls And Charts.
Limitation:
- 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. - 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
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 M33.104. We have to schedule Webi reports with prompt parameters. Can you please suggest a way of doing it.
Thanks,
TInku
Hi Tinku,
There is no way to schedule Webi with prompt parameters from CPS 8.0 M33.112.
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 Doris,
According to note 2128711 - SAP CPS 8.0 by Redwood: M33.116,
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
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
This is not possible at the moment.
The reports have to be scheduled from SAP CPS/BPA.
thanks
Nanda
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?
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
Thanks Nanda. I tried with tomcat server but it failed? Is there anything that I need to configure in BOE too?
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.
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 -
Please help me in sort out this.
Regards,
Sanjay Awasthi
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
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
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
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
Happy to help.
thanks
Nanda
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
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
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.
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:-
Regards,
Sudarshan
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