m ST ez Me Sao MAZ meje - k s š siti. s D x 1 : | d "- a i — s LI bš — i x % dj Č z | d | nal pa This 1s the last of a ihree-parl tive information systems and, de- - ze : ia J me 1 1 Kal "a: 1 h ee - pije u . . LJ Sa ! ka LJ ' $ | O O | S - la : z ii - make a ka ab : čla ; PR Gate H ne ki ( | 4 ' z Le . Jugi ne] ' seča | E m Nea kako V Perje, h . f a] m m", jam s A K 1 so 4 - toe mi mi F te? LEE bi F 1 a of a decision sup- teb system DSS) is to get the right infor- mation to the right people at the right time. Decision sup- tools in deci- MARTIN port systems are powerful sion-making. Their role is to help manag- ers gather facts about the internal oper- ation of the organization as well as about competitors and external events. The tools permit managers and analysts to build detailed financial models, ana- . lyze these models and use this tion to make decisions. "2 DSS tools are typically used by finan- cial analysts, business managers, budget managers, product managers and brand managers. They support sophisticated fi-' nancial-analysis functions, including ex- '' ploratory data analysis, time-series anal- ysis, forecasting, causal models, cross- sectional analysis and advanced analyti- ' cal tools. DSS products should provide the ana- ' lyst with the facilities necessary to fully: , implement a DSS application. The par- ticular type of application and the indi- ; vidual users determine the mix and depth of the facilities reguired in a sin- je gle product. The available DSS products vary widely in terms of facilities. : The reguired features of a DSS data manager are different from those of a production database-management sys- tem. Very often a DSS application uses more than one type of data, and the types of data in an application tend to change over time. As a result, the data-management fa- cilities of a DSS tool must be very ro- bust. For some applications, a two-di- mensional spreadsheet is adeguate. But to manage both time-series and cross- . € A DSS tool sectional data simultaneously, many DSS products incorporate a multidi- mensional data manager that allows the user to manage both types of data and view or analyze the data across. any dimension or combination of di- mensions. In addition, these products provide fa- cilities for performing consolidations along any dimension and to analyze or report specific user views. To correctly manipulate the data, the DSS must, maintain the associations be- tween data elements, referred to as the. data model. Many of the mainframe DSS products provide automatic navigation tools that ensure that the integrity of the data is maintained, usually through the use of an active dictionary that con- trols all access to the physical database A criticism of spreadsheets, such as Lotus 1-2-3, has been that they do not use a data dictionary. This can lead to data disintegration: A user could easily operate on monthly information as if it were guarterly data. Micro products informa-. 3 PO W FEKNAPPLIGATION DEVELOPMENT APPLIED INTELLIGENCE such as Javelin and pcExpress incorpo- rate an understanding of business opera- . tions and planning and provide data dic- tionaries that govern access to the data. A DSS tool must be able to manage the diverse types of data and provide data-entry and editing capabilities. To do so, the data must first be loaded into the DSS data manager, as illustrated. Data for a DSS application generally comes from many internal and external sources, some of which: are not machine readable. se The facilities incorporated,in DSS products to handle these diverse types of data vary greatly. Micro spreadsheet products allow the user to import data om ih, | Internal Data e Accounting — sl How Decision Support Systems Are Structlired The PC Is Executives' Window ji Into Company Operations | External Data e [)ow Jones. | € CompuServe Information cility with any DSS product is an inte- grated guery language that is flexible enough to allow the user to specify sim- ple, unstructured reguests. These re-. guests tie in directly to the data dictio nary (if there is one) to ensure that the guery is processed correctly. Virtually all DSS products provide some degree of report-generation capa- bility, but perhaps more important is the ability to generate graphs. The actu- al process of graphical analysis can it- self provide a different insight into re- ported data and can act as a data-re- duction mechanism for guick assimila- tion of information. These advantages have made graphics a key ingredient of Hi k Mainframe Sofiwlre Data Manager ||, Data Model | ||. Menu Systerri (ii Communications, | l l PC Software. e Ouery and Reporls e Graphics. ie e Financial Modelirig | | s Statistical Library, o Communications 8 Menu System | | User Interface , |. . | : OE; : 1 diki Maryelen Zawatski must be able to manage diverse types of data and - provide data-entry and editing capabilities. Data for a DSS from other spreadsheets, from standard databases (such as dBASE ID or text: These products generally do not provide data screening, error checking, check-. point/restart or audit facilities or tools for user-defined menus, forms, screen! - painters or edit checking. - ERETI because of their origins, mainframe DSS products do not have the same limi- tations as the spreadsheet products in - the area of data entry and editing. Most mainframe DSS products provide some |. sort of standard file definition and input mechanism, and many are able to di: . rectly read external databases such as. ' DB2, SAL/DS, IMS and Focus. :: : Perhaps the single most important fa- application comes from many internal and external sources. DSS and EIS applications. With the growing acceptance of the microcomputer as a DSS workstation, graphics are also being used more fre- guently as a dominant user interface. Using a touch-screen or pointing device, the analyst, enters responses without us- ing the keyboard. By pointing to an icon or an entry in a list, the user can con- trol the operations of the system. The continued acceptance of graphical inter- face standards, such as the OS/2 Presen- tation Manager, GEM or Topview, will enable more products to provide such Unfortunately, the field of decision support has commonly been eguated | The James Martin Productivity Series, MAY 8, 1989 with financial modeling or financial analysis, In financial analysis, the user generally manipulates data using a se- ries of mathematical operations and built-in financial functions (such as in- ternal rate of return, present value, payback and growth rate) to better un- derstand the relationships between the data. A financial model allows the user to consistently represent relationships between data elements. p Build, Analyze Models To Make Decisions While almost all DSS products have fi- nancial analysis and modeling facilities, the implementation of the modeling lan- guages differs greatly. The simplest implementation of a fi- nancial model allows the user to devel- op a model in the form of a financial re- port. The financial report, becomes the user's view of the financial model. More robust, modeling languages allow the user to reference data views not con- tained in the final report. Procedural logic, such as "if-then-else" or "do while," can be specified as part of a data relationship. Also, more robust DSS products have facilities for multi- level consolidations and the automatic coriversion of currency data using differ- ent exchange rates. One component in the DSS architec- ture that varies the most, from product to product is the statistical library. Sta- tistical functions available in DSS prod- ucts range from simple mathematical functions (sguare root, absolute value, minimum, maximum and so on) and simple descriptive statistics (mean, me- dian, percentile and so on) to simple correlation and regression, time-series projections, cross-sectional analysis and forecasting routines. A robust DSS product provides the developer with alternative ways to in- teract with an application. Ideally, user interaction should be controlled by the use of a mouse or some other pointing device. Another common method of in- teraction is natural English. Vendors now provide various levels of Support for mainframe and micro inte- gration. The continued acceptance of the micro as a user workstation has encour- aged mainframe DSS vendors to im ple- ment their products in the micro envi- ronment and provide communication ca- pabilities to the mainframe product. Vendors of micro products are also in- cluding facilities for connecting to main- frames and for data transfers between the mainframe and popular micro products. Next week I'll begin a series of arti- cles on IBM's AS/400 family of vii Computers as a strategically vital ele- — ment of IBM's Systems Application Ar- chitecture for implementing the distrib- uted systems of the '90s. B an information service updated . terly, is available through High Pro ductivity Software Inc., of Marble- head, Mass. (800) 242-1240. matton on seminars, please co the United States and Canada) Tech-. Transfer Institute, 741 10th St, — | OO Santa Monica, Calif. 90402 (213) 394. For infor-. ; contact (in || ka, 8305. In Europe, contact Savant 2 ZZ | New St., Carnforth, Lancs, LA5 9BX United Kingdom (0524) 734 poo: ne de — s [oi ai Čla k, 5 pa 4 » Z b— a, " j ui. mah Ji Hi. um i h Perič z Pet ——, NR sm j Pa