Archive for the ‘Business Objects’ category

0812: Working with Auditing Data in the Activity Universe

August 9th, 2010

October 7th – Will be at ASUG speaking on how there is a wealth of information about your BusinessObjects system that is only available in the Auditing database.    Getting access to these questions (and answers) takes a good understanding of the auditing database and the confidence to extend the activity universe to meet your needs. With some real world examples we will show you how to get the answers to some tough questions.

http://asugew.asug.com/displaymod/detailevent.cfm?conference_id=95&event_id=18468

Multi-node BOE

July 31st, 2010

Had the great opportunity to present a webinar on some of the more complex options when configuring SAP BusinessObjects Enterprise XI 3.1.  The link is here http://jive.asug.com/docs/DOC-25624 if you are an ASUG member.

Disappointed in boe_reposcan

June 21st, 2010

After reading the document I thought that it was going to be a cool new tool for disaster recovery.  I thought that boe_reposcan would publish orphaned files left in the file repositories after a database outage.

I event spent the time to update the script syntax and find the proper location to execute the program

./boe_reposcan.sh -dbdriver oracledatabasesubsystem “-connect “UID=BO_data;PWD=b0_data;DSN=database-server;HOSTNAME=ip-address;PORT=1521” -repair -inputfrsdir “/usr/apps/bobj/bobje/data/frsinput” -outputfrsdir “/user/apps/boj/bobje/data/frsoutput” -scanfrs

But to no avail.  the program told me that my reports did not synch with the repository but I was on my own to republish them.  After all that work comparing I think a synch option would have been the perfrect match

I will add this as another item for Admin Launch for the future.

./boe_reposcan.sh -dbdriver oracledatabasesubsystem “-connect
UID=BO_NEXUS_data;PWD=b0_nex1s_data;DSN=bradpit;HOSTNAME=bradpit;PORT=1521” -inputfrsdir /usr/wbol/bobj/bobje/data/frsinput -outputfrsdir /user/sbol/boj/bobje/data/frsoutput -scanfrs

OpenDoc vs. CallReport

May 5th, 2010

We get a lot of question on how Open Document compares to Report Launch. In a conversation with our sales team I tried to summarize the vast differences. Opendoc is a single URL that can only call a single report at a time ….and for Webi can only return to the viewer or PDF

Report Launch’s “call report” is an application that will provide a consistent ways of calling both Crystal and Web Intelligence reports using single sign on.

  • On- demand refresh
  • On demand scheduling
  • Report List
  • Last Scheduled Instance
  • Last Bursted Instance
  • List of Historical Scheduled Instances
  • List of Historical Bursted Instances
  • It can also support the following formats

  • PDF
  • XLS
  • PPT
  • CSV
  • TXT
  • HTML
  • XML
  • These are the basics. There are also more complex features for complex solutions.

  • Cached Results
  • Report Parts by Name
  • On the fly Dimensional Slicing
  • - Challenge us with something you need and I can tell you if CallReport already handles that.

    Kevin McManus

    What I Do

    March 22nd, 2010

    What we do: Some asked recently for what was going on related to our tools. Here is a summary
    At a 50K foot level we have 5 tools

    1) Report Launch allows you to embed Crystal and Webi reports from any application without needing the SDK.

    2) Dashboard Launch (You will have to see this). Caches webi content and many other things for really fast dashboards. SAP certified too

    3) Admin Launch – bleeding edge web based BOE administration tool that you can train to do what you need it to do for you (beta just started).

    4) Audit Launch : Export extends BOE auditing for advanced analysis by syncing CMC attributes into an extended audit database. Audit Launch Import syncs security from 3rd party apps into BOE

    5) Activity Launch – allows you to create business activity monitoring events into report schedules and trach when a batch of schedules completes so you can continue the notification or event process

    All of our software is 100& web based on Java SDK so it runs on Windows, Unix, and Linux

    Java or .NET

    January 1st, 2010

    Recent Question: Do you have any recommendations on installing the .NET (IIS) vs Java (Tomcat) versions? I liked the ease with which we implemented the SSO hack in IIS on our XI R2 server but I’m not if we can do the same on the 3.1 version. Also I remember that on sometime the .Net versions sometimes did not have all the functionality as the Java version is that still true?

    Answer:I usually lean towards whatever web platform that IT has optimization expertise in. If they don’t have optimization expertise in either then for several reasons, I usually do the Java.

    However for SSO the IIS setup is less steps than the Java version. The IIS pass through can still be done but is not a great solution if you are doing things like scheduling out reports with email links back to the system and still wanting SSO.

    If you do go with Java,Normally I work with people to setup the Vintella Kerberos SSO so that there is only one web platform running on the server rather than the pass through.

    Split and Search

    October 22nd, 2009

    Presented at the GBN conference on a way to provide users the way to enter a comma delimited list of values into a prompt and then use a database function to split those values in order to return the list as a table that can be used in joins.

    WHERE rs_tb_cms_groups.group_ID IN ( SELECT rs_tb_cms_groups.group_ID FROM @Prompt(‘Group
    Name ‘,’A’,{‘California’,’New York’},mono,constrained,not_persistent,))

    If anyone wants the full article including the Oracle and SQL server code please contact Kevin McManus at answers@mcmanusconsulting.com

    Business Objects Bursting SDK – Part 2

    June 19th, 2009

    Whether you choose single or multiple report bursting, eventually you will want to deliver the results to your users, and if you are delivering a custom application solution, that means understanding the object model around publications.

    A publication object appears in a BOE folder just like a report does, and like a report, it too has historical instances. But whereas a report instance represents a snapshot of the report with data, a publication instance is a container that further holds (you guessed it) the report instances themselves.

    The great thing about BOE publication architecture is that the report instances held in a publication instance are automatically filtered to the report instances the currently logged in user has been “bursted.” In other words, it makes no difference if a user has rights to the folder in which the publication resides; he/she must have been named (or at least the user group to which he/she belongs must have been named) as a burst recipient in the publication. » Read more: Business Objects Bursting SDK – Part 2

    How to use Crystal Report ActiveX viewer in your Tomcat J2EE application

    June 10th, 2009

    If you ask the SAP developer support, they will say it’s not supported. However, there are complex Crystal Reports that renders properly in ActiveX viewer.

    The only option right now is to use InfoView’s URL reporting. This is ok but there are a few places where this can get you into trouble. For example, let say your J2EE application is on the DMZ and your BOE server is inside of your corporate network. The firewall will only let certain ports (e.g. 6400) and no http requests. In case of URL reporting, you would have to call <BOE server>:<http port>/businessobjects/viewrpt.cwr from your J2EE applications. This will not work. In most cases, opening http port so that ActiveX viewer would work is not an option.

    Here’s how to setup URL reporting as a part of you own application.

    1)  copy crystalreportviewers folder from infoview /businessobjects/viewers folder and place it in the root of your J2EE application

    2)  copy WEB-INF/lib/reportsourcebridge.jar from InfoView application and place it in WEB-INF/lib folder of your J2EE applicaiton

    3)  Edit WEB-INF/web.xml to include

    <context-param>
    <param-name>crystal_image_uri</param-name>
    <param-value>/crystalreportviewers115</param-value>
    </context-param>

    <servlet>
    <servlet-name>viewrpt</servlet-name>
    <description>
    Reportsource bridge used to support Java applet viewer and ActiveX viewer.
    </description>
    <servlet-class>com.businessobjects.crystalreports.reportsourcebridge.ReportSourceBridge</servlet-class>
    <load-on-startup>1</load-on-startup>
    </servlet>

    <servlet-mapping>
    <servlet-name>viewrpt</servlet-name>
    <url-pattern>/viewrpt.cwr</url-pattern>
    </servlet-mapping>

    4)  Restart Tomcat

    5)  You should be able to access URL reporting from <your J2EE application>/viewrpt.cwr

    Taking Crystal reporting to the Edge

    June 8th, 2009

    At face value this may look like a BOBJ marketing play on words. It is true that by implementing Edge, you can accomplish some of what will be discussed in this article. This is no sales pitch and that is not the point of the title. By taking Crystal reporting to the Edge, we mean:

    1. Empowering report users to manipulate and store parameter sets.
    2. Eliminating the need to leave applications to get reporting.
    3. Delivering reports via web applications to people within and outside an organization.

    Let’s address these points one at a time.

    Parameter manipulation is one of the more tedious and essential parts of examining data. If you are still delivering reports in a static format, it is time to move to a viewer. Many report viewers including BOBJ’s free viewer allow for parameter sorts and drill downs. This frees up report designers to focus on bigger things than a slight change in product sets or financial categories that as they add up take days out of the year. Another critical thing to look for is the report viewer’s ability to manage complex and dynamic cascading parameter sets.

    Once you deliver parameter manipulation prepare for the next expectation. If usually comes within days if not minutes of new empowerment. Users are going to want to store these parameters so they can pull them up on demand. Quickly they learn what it takes for a report to me changed to meet their needs, and just as quickly it is forgotten that someone else used to do it for them. Make sure that any report viewer you deliver allows users to store their parameter sets quickly and easily.

    The next point is one of the most challenging both strategically and financially. Users want their reports on demand and in the same program that they use for day to day activity. Sure, most systems have their own reporting, but it is in a silo and, well, what did you buy Crystal for in the first place?

    The complication is that you have to develop integration into the application. This can be a costly and complicated process as you struggle to manage the development of a secure connection. There are some third party tools that will work. The Crystal Developer Advantage team did a presentation in February with McManus Software. Their Report Launch product puts Crystal reports in any web application with a single line of HTML code. This eliminates the need to develop and they seem to have a low price.

    This brings us to the final point; internet access to reporting is critical as more companies and more consumers expect to have on demand access to detailed business intelligence. To empower external viewers to view data from within systems, security is essential. Either upgrading to CR server or a BOE product will answer these requirements, but often this limits you to licensing within the tools. If you are using 3rd party security or want to use a system that manages permissions at an application level, you will need to develop or find a 3rd party tool like McManus Launch.

    As you start moving your reports to the Edge and really begin to enable on demand report consumption, think about these three points. Proper execution will make every report more effective. Missteps will cost you your most valuable commodity…time.