Rejected Record Summary

Hyperion Rejected Record Summary (rejected-record-summary) is a small Java library/command-line program for processing data from rejected record files generated during a data file load to a Hyperion Essbase OLAP cube.

As with most/all of my open source Hyperion utilities, it is the extension, elaboration, and cleanup of a concept I have used in the past in various production environments.

This program can be used on the command-line as well as a library that can be plugged easily in to your own Java projects. On the command line, this program can read from STDIN or be given a rejected record file to process. It will scan through the file and compile stats about the rejected records it finds.

Please see the detailed README on the Github repository for more information.

In a nutshell, though, this library/program can be used to process rejected record files that are produced from a data load to Hyperion. The program tracks things by member and reject count to provide a summary of what got rejected and how many times. This can be useful to use in conjunction with automation that emails a summary of a load process to certain users. Instead of attaching the raw reject file you can provide higher-level stats. The processor functionality of this library also makes it possible to build a summary of multiple reject files for more aggregated summaries of why records got rejected.

RRS is licensed under the Apache Software License version 2 as with most of my other open source utilities — so feel free to do with it as you please. As always, please let me know if you find it useful or have questions/comments/feedback.