What level of detail do you need? The reason I ask is because to do this, we have some ASP pages that the .NET team built to redirect to the proper BOXI report directly. In other cases, we simply link to the "home" page of the WEBI server, and since we have single sign on enabled on WEBI server it automatically logs them in and they can do whatever they want.
So we aren't doing anything as complex as letting users run queries in Remedy and output the results to business objects, we just link over to business objects reports, where they enter their search criteria on the report itself. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Thursday, February 26, 2009 11:26 AM To: arslist@ARSLIST.ORG Subject: Re: Business Objects ** We have the same thing here (BO on a separate server maintained by another reporting group). Could you provide some detail on where the links pointed to? Sorry I do not know Business Objects at all. Where is WEBI on the BO server? If this works I owe you a beer :) Thanks, Brian ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Thursday, February 26, 2009 12:15 PM To: arslist@ARSLIST.ORG Subject: Re: Business Objects ** I see. In our environment we have a separate business objects instance maintained by our reporting team that is used for multiple applications. For the ITSM apps, we bought BMC Analytics, and for our custom apps we just pull the data directly from the database in the custom universes we created. Instead of doing reporting directly from the Mid Tier, we just have links to the appropriate portions of WEBI (the web-based Business Objects environment) to pull up those reports. To the end user, it doesn't make a difference if you have BOXI installed right on the Remedy Mid Tier server or if it's on another server, if you run the full BOXI version since it's just a matter of pointing hyperlinks to the right place. Shawn Pierson From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Thursday, February 26, 2009 10:55 AM To: arslist@ARSLIST.ORG Subject: Re: Business Objects ** This has nothing to do with ITSM? It is pure ars. ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Thursday, February 26, 2009 11:38 AM To: arslist@ARSLIST.ORG Subject: Re: Business Objects ** If your company has another business objects environment, it is possible to install the ITSM universe in that environment and avoid these problems altogether. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Sokol, Brian Sent: Thursday, February 26, 2009 10:14 AM To: arslist@ARSLIST.ORG Subject: Business Objects ** I have been trying in vain for many, many months to get BO to work with our MidTier. Business Objects says it is a BMC problem and vice versa. On top of that I don't really trust our Crystal admin. Up to now I could get the reports to display but always got an error when I tried to print them. I am able to export the report to a pdf but can not print it. Now I have another problem. I just updated the report in the remedy Report form and get this error: An unexpected error has occurred com.crystaldecisions.sdk.exception.SDKException$Unexpected: An unexpected error has occurred cause:java.io.IOException: CreateProcess: "C:\Program Files\Business Objects\BusinessObjects Enterprise 11\win32_x86\plugins\desktop\CrystalEnterprise.Report\ReportAdd.exe" -report "C:\Program Files\AR System\ARWebReportViewer\reports\m11c23c11b16\6shgOZtHHZgKVndQxd8aK8q3Ak\POReport.rpt" -newrpt -discard -version 1100 -thumbnail -outfile -token z...@ag@_E\TAgWDIea[I<P0QZ9V<;YJ;JmL8fP82mY7]Q`91jlhYgd3==8SkcM=C1f=f5P:L3S0]Gd;NGai31_De<<P0QZ9V<;Yj;J -token -outfile -thumbnail 1100 -version -discard -newrpt System\ARWebReportViewer\reports\m11c23c11b16\6shgOZtHHZgKVndQxd8aK8q3Ak\POReport.rpt? Files\AR ?C:\Program -report 11\win32_x86\plugins\desktop\CrystalEnterprise.Report\ReportAdd.exe? Enterprise Objects\BusinessObjects Files\Business CreateProcess: java.io.IOException: was thrown originally exception The occurred has error="3" unexpected detail:AnmL8fP82mY7]Q`91jlhYgd3==8SkcM=C1f=f5P:L3S0]Gd;NGai31_De<</h3" The problem has to do with reportadd.exe. I assume this is copying over my new version of the report file. Our install of BOXI is on our D drive. The reportadd.exe file is located at d:\boerir2\common\3.5\bin In the error above it is looking for this file on the C drive. I also found this KB on the BMC support site: Can Business Objects XI be installed on a non-C drive to run Crystal reports in Mid-Tier? Product Environment Solution You should always install BOXI on "C:\" drive. If you don't install BOXI on "C:\" drive, you will get crystal exception such as below while running crystal reports. com.crystaldecisions.sdk.exception.SDKException$Unexpected: An unexpected error has occurred cause:java.io.IOException: CreateProcess: "C:\Program Files\Business Objects\BusinessObjects Enterprise 11\win32_x86\plugins\desktop\CrystalEnterprise.Report\ReportAdd.exe" -report So is this a Business Objects bug or a BMC bug? BMC is not referencing any kind of KB or bug note from business objects. Also has anyone experienced the problem I am having where you can display the report but not print it? Running this on ARS/Mid Tier 7.1/Win Server 2003/IIS Thanks, Brian __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ Private and confidential as detailed here<http://www.sug.com/disclaimers/default.htm#Mail>. If you cannot access hyperlink, please e-mail sender. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ Private and confidential as detailed here<http://www.sug.com/disclaimers/default.htm#Mail>. If you cannot access hyperlink, please e-mail sender. __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
