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.

 

4 thoughts on “Rejected Record Summary

  1. Hey I am so thrilled I found your web site, I really found you
    by mistake, while I was looking on Yahoo for something else, Anyways
    I am here now and would just like to say many thanks for a incredible post and a all round interesting blog (I also
    love the theme/design), I don’t have time to go through it all at
    the minute but I have bookmarked it and also added in
    your RSS feeds, so when I have time I will be back to read more, Please do keep up the great work.

  2. This is the perfect blog for anybody who wants to find out about
    this topic. You realize a whole lot its almost hard to argue with you (not that I really will need to…HaHa).

    You certainly put a brand new spin on a subject that has been written about for years.
    Wonderful stuff, just excellent!

Leave a Reply

Your email address will not be published. Required fields are marked *