1. Guest Spot: Lawson's Commitment to the iSeries - A Commentary
(by Patrick Sullivan, Sullivan Partners LLC)

The IBM Midrange (System3x...AS/400..iSeries) community has always had an interesting dynamic: a fiercely loyal customer base that has received little to no marketing support from its manufacturer.

Many Midrange professionals-myself included-have surmised that if IBM had been as market savvy as, for example, Microsoft, today's Midrange line would not be considered a "dinosaur" as some IT professionals falsely still believe.

Due to IBM's lack of direction, it is no wonder that software vendors, like Lawson, questioned continuing development on the platform. It is interesting to note that Lawson was initially designed for IBM's Midrange line.

Thankfully at CUE (2003), Dean Hagar at Lawson announced the company's renewed commitment to the iSeries.

This comment was due in large part due to IBM's recent $500 million campaign to re-energize the iSeries marketing and development efforts-and signaling a commitment to the industry.

Consider the following findings:

• The iSeries was the #1 server in customer satisfaction 2003 (Nikkei Computer Magazine - 06/28/03 issue).


• 99% of Fortune 100 companies in 2002 realized benefits from the iSeries (Fortune Magazine 2003).


• The iSeries Operating system (OS/400) was engineered to be virus resistant.


• The iSeries has the most comprehensive dynamic partitioning feature of any midrange server (Forester Research 2004).


• The only server in industry to run applications from different operating environments (0S/400, Windows, Linux, Domino, XML) simultaneously on a single server.


• Websphere Portal Express allows IT departments an easier, more cost effective solution to consolidate IT and business processing needs.


• When consolidating Windows and Linux servers to the iSeries, customers see:
  
  1. A 90% reduction in downtime
     
  2. A 200% ROI on server workload
     
  3. An average savings of $180,000 per 100 users/year (IDC - July 2003 Analysis)

Report Management

SQL Server Reporting Services includes comprehensive functionality for managing reports in a wide variety of environments. Report Manager is a Web-based tool for managing reports as a Web service. Managed reports can be executed either on demand or on a specified schedule, and are cached for consistency and performance. Security can be tailored to meet a variety of needs. Users may be granted access to run reports on demand or tailor individual report subscriptions. Administrators can delegate content management functions to specific individuals for different reports.

Using the scheduling tools, you can build a rudimentary reporting/notification process. Here's an example, where the Employee List is executed and e-mailed every Friday at 1pm:

Visual Studio Integration

In addition to developing and delivering your reports, you can use SQL Server Reporting Services to integrate reports into your custom applications as well. Because Reporting Services are written as an XML-based Web service, IT organizations can embed report content in any application and make the content available to users over any Web interface. The Web model allows organizations to deploy reports to employees, customers and partners over an extranet, isolating these audiences from the complexity of the underlying data sources while providing personalized, interactive access to data that's critical to their own decisions.

Emerging Standards

Microsoft is working with other reporting software vendors, such as Crystal, Cognos, and Brio to standardize on a common ".RDL" XML-based report definition file. This will allow each vendor's products to interoperate across your various reports. The advantage is that, if you have Crystal ".rpt" reports, you could open them in Crystal, save them as ".rdl" files, and deploy them with SQL Server 2000 Reporting Services. Or vice versa.

In the meantime, SQL Reporting Services includes an import utility for converting your existing Microsoft Access reports. And there are other 3rd-party tools available for conversion of Crystal reporting into the .RDL standard.

Summary

Price alone makes SQL Server Reporting Services an obvious choice if you're running Lawson on a Windows platform. Even if you're not, you can certainly hook it up to your Oracle or DB2 databases. In addition, if you cringe at the licensing cost for Crystal Enterprise named users (which are required if you want to properly implement report security), you should consider SQL Server Reporting Services.

Send your comments to mailto:letter-comments@lawsonguru.com.
Some comments on the May 2004 issue (see http://www.danalytics.com/guru/letter/archive/2004-05.htm):
Your comments on Lawson's new support site, CUE, and whether or not Lawson could deliver on its pledge to reshape how it delivers value to its clients:
	"It's pathetic for a technical company to have a support site with a single point of entry that does not work reliably. Things happen to all of us and I understand that, but when a company places all their eggs in one basket, that basket had better be fool proof. Lawson does nothing but stress the use of their support site; GSC refers all of us to it; products, patches, and articles can only be found on this site. Lawson simply cannot afford for it to be down. They publicized a new and improved site; they claimed it was going to be easier to use and more user friendly; they promised it would be a smooth and totally transparent transition. Oops. And I think it is especially ironic that it went down the very next week after CUE where Lawson management promised a new kind of company. Not a good start."
	"After having read the May 2004 LawsonGuru Letter, I felt an urge to comment on Keri White's "Guest Spot" article. I too was in attendance last week and enjoyed the keynote speaker, Dr. Jerry Leninger. However Keri's comment where she agrees with Dr. Leninger's comment about how we should be able to improve the quality of ERP software given we can send send men and women to space misses an important point. Quality is not free. I speak from experience, having been involved in my earlier days with IBM and its work with NASA on both the ground-based and shuttle-based programs and the software engineering practices used to achieve those levels of quality. For the typical business application, decisions are made based on numerous factors but it is generally agreed that striving for "zero defects" would make the software cost-prohibitive. I do agree though that there is certainly room for improving the level of quality in most software applications today."
	"I would like to believe that Lawson will deliver on its promise (It's Time) by putting its customers at the forefront; however, as I sat there and listened, it brought me back a number of years to a point in time when I was employed by IBM. It sounded to me that Lawson was a mini-IBM - slogans, banners, posters, fluff but not much depth. From the Lawson folks I know and speak with, they are being driven hard for revenue (i.e., increase utilization and billables) which can get in the way of cultivating client relationships. I do wish them well but if history is any indication of future results, I don't believe they have the necessary culture in place (yet) to make this happen."
	"1.5 hours: The amount of time the 14-member team from our organization waited for our Lawson account managers and sales rep to show up to a pre-scheduled meeting Tuesday evening in Atlanta, before finally giving up. I hope the next 998 days are more successful than the first 2 days of Lawson's new commitment to their clients."
Regarding last month's Tip on "alt-characters", this from a Lawson consultant:
	"I liked the nice Guest Trick and Tip. One problem though: When it comes to upgrading and pulling the data from one product line to the next, chances are that the data that is not standard Lawson characters will be kicked out by the Lawson tools as an error, which will label that record as errored. So there will be manual error edits required or an in-line sed swap command required to fix them all. Either way, guess what? Additional time will be required to deal with the nifty little trick that now is not so nifty. It would be better to have a new field added to the table for the Actual British Pound symbol or what not. Or better yet why not use Design Studio to make the symbols appear on the forms themselves. Also add them into the reports via 4GL as well. There is a reason these symbols are not included in the data. I would suggest some thinking this through further before making these entries."
And Bob Beverley's reply:
	"I haven't tried upgrading with the characters, but I'm in the middle of one right now - so I will. It was the GSC that recommended the WinInt font 3 years ago, so I'd be inclined to think that chances are just as good that they will upgrade successfully. I'll let you know what I find."
[Editor's note: I have not tested this with an upgrade either, but did test it with the usual Lawson database utilities (rngdbdump/importdb, dbdump/dbload, and expsysdb/impexp), and had no problems.]