Articles
Reusable TRANS I-descriptor DICTionary items
"We can create keys involving complex inter-relationships between files by building them from simpler keys."
Article for the Geac October 1994 Service Plus Newsletter
Utility to Produce HTML Pages
Concise description of Intranet Reporting in UniVerse from 1996.
Intranet Reporting in UniVerse
Techniques for using an Apache webserver and Unix symbolic links to leverage standard UniVerse reports.
Article for OSDA Spring 2001 Newsletter, based on presentation notes.
UniVerse Intranet Access
Techniques for using an Apache webserver and ISINDEX to access UniVerse commands.
Article for OSDA Fall 2001 Newsletter
Using Web Forms to access UniVerse
Techniques for using an Apache webserver and web forms to access UniVerse.
Article for OSDA Winter 2002 Newsletter
A UniVerse Web tool for Phantom Control
Documentation for SpliceWorld.
Article for OSDA Spring 2002 Newsletter
Giving UniVerse Secondary Indexes a Second Chance
Setting up pointers directly to the internal B-tree index files.
Article for OSDA Fall 2002 Newsletter
Fast and Cheap Multivalue ETL - leveraging Microsoft's DTS - Part 1
Converting UniVerse files to flat files using SELECTs and extraction of fields from flat files by SQL Server DTS using ActiveX scripting.
Article for OSDA Summer 2003 Newsletter
Fast and Cheap Multivalue ETL - leveraging Microsoft's DTS - Part 2
Using SQL Server DTS to manage the ETL process and Perl and Shell scripts to take our multivalue data as far as normalized tab-delimited text.
Article for OSDA Fall 2003 Newsletter
U2 Family Application Development - Test 713 Study Notes
This is a set of notes I put together from sparse information on the Internet (Test 713 Objectives/Skills Measured on Test) and cut and paste from online and Acrobat UV documentation. Note that these notes were assembled before I took the test.
Handout for presentation to SAPUG October 16th 2003 IBM U2 Meeting
Dashboards, Analysis Mind Share, and KPIs
A concise perspective of just how these powerful business tools are put to use.
Article for International Spectrum - Sep/Oct 2005
MultiValue Reporting and Business Intelligence
Learn the difference between Operational Reporting versus Analytical Reporting.
Article for International Spectrum - Jan/Feb 2006
MultiValue Reporting and Business Intelligence
Reporting on large amounts of MultiValue data presents its own challenges. What are some of the options?
Article for International Spectrum - Jan/Feb 2007
Tailoring Performance Dashboard Content (TDWI Membership Required)
Article for The Business Intelligence Journal - Fourth Quarter 2007 - also here:
TDWI's Best of Business Intelligence, Volume 5 (Free Download)
Welcome to the fifth annual TDWI’s Best of Business Intelligence: A Year in Review. Each year we select a few of TDWI’s best, most well-received, impact-full articles, research, and information, and present them to you in this publication.
In “Tailoring Performance Dashboard Content,” our selection from the Business Intelligence Journal, Ross Morrissey describes how to design performance dashboards around the capabilities and goals of the users—not the technology provider. He draws lessons from management accounting, aviation, and software interaction design, and takes a detailed look at analysis mindshare across the organization.