Serviceability
What is application serviceability?
“Serviceability (also known as supportability,) is one of the -ilities or aspects (from IBM’s RAS(U) (Reliability, Availability, Serviceability, and Usability)). It refers to the ability of application support personnel to install, configure, and monitor an application, identify exceptions or faults, debug or isolate faults to root cause analysis, and provide maintenance in pursuit of keeping an application current and/or solving a problem and restoring the product into service. Incorporating serviceability facilitating features typically results in more efficient product maintenance and reduces operational costs and maintains business continuity.”
Serviceability Levels
An application serviceability audit should be conducted and have the objective of classifying all support procedures within the application as having either a low, medium or high serviceability level.
Characteristics of Low and medium serviceability procedures are:
- Require manual intervention to initiate
- Require manual intervention during processing
- Require manual intervention to verify (complete)
- Are overly complex
- Are not repeatable without significant manual intervention
- Are “tightly coupled” to other areas or procedures within the application or other applications
- Require specific skillsets or skill levels
- Are not documented
Characteristics of High serviceability procedures are:
- Are fully automated
- Require zero or limited manual intervention
- Are encapsulated within a distinct area of the application
- Are easily repeated if required
- Are documented
Application Procedure Areas
All application serviceability procedures will fall into one of the following areas:
- Data Initialization and Manipulation
- Administrative Maintenance
- Setting Assumptions
- Validation
Data Initialization and Manipulation
Data initialization and Manipulation refers to procedures that clear data from, transform or update data within or load data into an application. All applications absorb data. Data absorption is categorized as one of the following:
- Generic (i.e. the regular refresh of a current period of activity)
- Upon-request (i.e. a one-time request to address a specific need)
Generic Absorption
The Future of Big Data
With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.
Because generic Absorption procedures are “expected” – meaning that they occur at predetermined intervals and have expected parameters – all generic absorption procedures should be able to be automated, scheduled and documented. These procedures can then be classified as highly serviceability.
Upon-Request
Upon-Request procedures are usually un-documented and not scheduled and therefore have a low serviceability level; however these requests will be on a case-by-case basis and will usually be performed by a systems administrator, as needed. These requests are understandable outside the consideration of an application serviceability audit.
A simple example of a data initialization and manipulation procedures to be reviewed during a typical audit might be a procedure to maintain application Meta data:
Dimension Metadata File Data Load
- Get an updated metadata file for the application dimensions from enterprise source system.
- Verify that the files are in the proper format with the correct name (Dim Internal Order.csv).
- Place file in the .\MetaData folder on the server.
- Run the appropriate TurboIntergrator process to update the dimension.
The audit team should review this procedure and provide feedback:
Serviceability Level:
Recommendations:
The generation and loading of external data should be an automated and scheduled process to avoid the manual dependency to initiate, and process and to avoid administrative errors. An automated process will eliminate errors in file formatting, naming and placement.
Administrative Maintenance
Administrative Maintenance procedures include the management of governance mechanisms within an application to keep the application synchronized with appropriate business processes. These procedures should:
- Be straight-forward and easily understandable
- Well documented
- Easily reversible
- Have minimal impact to system availability during the procedure
The following might be an example of a generic administrative maintenance procedure that would be audited:
Update Input Cubes with Actuals and Open the Forecast
Actual Sales Activity must be pushed to the Input cubes so users can being forecasting. The administrator might:
- Set run parameters such as last actuals year and month and then run a TurboIntegrator process. Once the process completes, the administrator will inform the users that they can now update forecasts using provided.
The audit team would provide feedback:
Serviceability Level:
Recommendations:
This is a straight forward procedure however it is recommended that a reversal or “back out” procedure be defined. In addition system impact should be calculated for the procedure for current and future system states. Consider automating the update process so that users are either altered with an email or perhaps a visual cue that the forecast is now “input enabled”.
Setting Assumptions
Setting Assumptions refers to setting parameters that control how the system and/or application users should interpret information within the system. An example is the following:
Updating the “Last Actuals” Period
In this simple example, the applications administrator follows a 3 step process:
- Open file Update Last Actuals Period on the TM1 server (Applications -> Admin).
- Verify that the dropdown has the correct new Last Actuals Period.
- Click button Run to update the Last Actuals Period process.
A serviceability audit might respond with the following feedback:
Serviceability Level:
Recommendations:
Consider automating this step as part of the actuals load process.
Validation
Validation procedures are tasks or procedures that verify the authenticity or accuracy of the information within an application or that preparedness of parameters, structures or assumptions are at a sufficient state to proceed.
File Verifications is a typical example. When data files are being manually created and loaded, file formats, names and placements are at risk of error. Meta data files, activity (actuals) files, etc. are all at risk. At serviceability audit would respond with the following feedback:
Serviceability Level:
Recommendations:
File verification should not be required if the process of generating and loading the files are automated. The recommendation is to automate all file processing procedures to eliminate the need for file verifications.
Conclusions
Even an application that is a soundly-constructed may have low serviceability. Some typical actionable items identified by a serviceability audit may be:
- Reduce the level of administrative intervention. Most of the application service requirements should be “lights out”, automated processing.
- Automate all data processes (i.e. file creations, placement, loads and updates to TM1).
- All automated processes should include failure check points that automatically alert the system administrators of intervention needs.
- Create a sequence and dependency diagram. Most of the procedures reviewed during the audit are interconnected (Actuals loading => Actuals (cube to cube) pushes => Forecast initiation => variance reporting, etc.) and may be able to be linked into single scheduled processes. In addition, this document will clarify the general operations of the system as it relates to business processes.
- Create an administrative dashboard showing all application statuses and parameters allowing an administrator to view and adjust each through a single point of reference. This makes it easy to quickly determine the overall health of the application or where intervention may be required before it affects the availability of the application. The use of graphical status indicators is recommended.
- Modify reports to be “As Of” reports showing current states -rather than dependent upon a data push.
- Develop and maintain sufficient application user guides and run books and store them in the TM1 applications folder for easy access.
- Develop an application performance monitoring routine.