Archive for the ‘Business Objects’ category

Reminders on what we focus on

April 7th, 2009

This lat week I was reading some of my favorite blogs and some new ones as well. I ran across some great posts that serve as reminders to those of us working in the BI world. This may be clear cut stuff, but it is always nice to get some reminders.

1. Why we report in the first place:

This is a nice post on the purpose of BI- In Business Intelligence is for making Business Decisions the folks over at Intelligence Matrix give us a great example and reminder.

2. A great post over at Beye Network about a new Journal and the definition of Business Intelligence. This is a great new resource and one fantastic post.

3. This is a wonderful post on the right way to look at BOE and publishing reports. Crystal Reports version control is interesting.

4. And this one is just funny. I guess SAP is restricting the porn access for Crystal Reports??? What, well read more here: Ken Hamady say no more porn

Until next time, enjoy these reads.

Crystal report version control

April 4th, 2009

BOE handles report migration in a slightly different way than a JSP file for example. Reports are primarily identified by a GUID and not solely on the name. Also the directory in which an object is referenced plays a large role so report objects should be kept in a maximum of two structures. One for unit testing and one for synchronization per the steps below.

In summary
1) Reports should be kept on a network share or subversion with version numbers in the file name and in the report properties.
2) Once reports are modified they should be published (File menu –> save as –> enterprise) to a TEST folder on level down from the main folder in the BOE Repository on the TEST BOE Server.
3) This version will have a new version number in the report properties and in the description.
4) The TEST Report Launch application that points to the TEST BOE Server and will see that folder within the application. The reports can then be tested. If they work sufficiently the Report should be published to the main folder from designer (File menu –> save as –> enterprise) without the version number in the title but still with the version number in the report properties. This replaces the existing report on the UAT server but PRESERVES the unique id that keeps the reports in sync with Prod BOE. UAT or system testing by a fellow team member can occur with the report in this main folder location.
5) This report in the designer can then also be checked into the network share or subversion.
6) Then the import wizard will migrate between the main folders in TEST with PROD. The DEV folder where the versioned reports are kept is not migrated to production.

Other points
a) As discussed the best practice no one should ever publish a report directly to PROD, nor have the rights to do so. It is protected and serviced only through proper administration. This supports the checks and balances that ensures that testing is properly completed and that roll-backs are easier.
b) Reports are not moved. Reports are published per the steps above so that if there is an issue identified during testing the prior version is already available online and clearly versioned so that it can be reverted on the TEST server without any affect on production. In the event that this reverted report needs to be imported to production the steps above will ensure that the proper version is in sync between environments.
c) This means that reports are not developed or published directly to the BOE PROD server keeping it pristine.

Kevin McManus
www.mcmanussoft.com

SAP AG staying on top of Crystal and BOBJ

March 28th, 2009

Check out this press release from SAP Business Objects and McManus Software + Consulting. Looks like they have released the Crystal Developer Advantage license to help ISV’s like McManus. They have a suite called Launch Applications and they are pretty cool. Everything from extending reporting to web applications to real time auditing of your BOBJ environment.

Here is the press release:

http://www.b-eye-network.com/channels/1543/view/9950

Oh, and about this blog. We will scour the blogosphere for anyhting and everything that is news int he Crystal Reports and Web Intelligence world.

Have fun!

Stop before you develop with the Business Objects Enterprise SDK

March 22nd, 2009

I am verry passionate about not developing new code for something when it already exists in an application or widget form that can be absorbed without additional coding. With that premise I will be sharing some of the options that can be added to the Business Objects Enterprise system using the Report Launch framework. The marketing folks say that all the features are too much to put on the web site in detail so as I document these features please feel fre to coment and ask questions. My hope is that with so many features that someone will come accross this blog and find the one they need.

http://www.mcmanussoft.com/ReportLaunch.htm