The OlapUnderground Advanced Security Manager has the ability to port security settings between Essbase servers, save security settings for backup, and create original security settings with a user friendly interface. Using this tool, you can connect to an Essbase server in order to: create or update security settings, monitor or logoff users signed on to the server, and monitor or remove locks on the server. You can also export all security settings to a file or import security settings from an existing security export file. Further, the Advanced Security Manager’s functionality can be automated using Command Line functionality by executing the Advanced Security Manager from a DOS batch file and including Command Line Parameters.
The Essbase Advanced Security Manager was originally written by a group of anonymous Essbase developers who wished to provide utilities for simplifying certain Essbase operations. Due to increasing job responsibilities, the original developers did not have time to maintain the code. We suggested that they Open Source the software and volunteered to maintain this download page. They gave us access to the software and source code and licensed us to distribute it freely with the stipulations detailed in the license agreement which is included with the software.
On the technical side, we have made a few changes to the software including:
- Added enhancements to make it compatible with the Essbase versions listed below.
- Standardized an automated build process for all versions using the open source build tool ‘Apache Ant’.
- Created an installer to require users to accept the license (required by our legal department and the original authors) and to properly install the code, including the source code if desired.
The software versions we compiled were tested by a team of volunteers in the Essbase community. We do not offer official support for the product. However, we will try to integrate changes or fixes submitted by the community as time permits. Further, if there is an Essbase version you would like added to the list, please let us know and we will try to make that version available.
We have investigated an issue that occurs infrequently when extracting large amounts of security information and determined it is due to an Essbase API issue. This issue occurs only on Windows operating systems and is related to the way that Windows and the Essbase API utilize ports to connect to the Essbase server. We have found a fix for that issue that requires changes to the Windows registry and have documented it in a PDF file available here.
We have invested thousands of dollars of time and legal fees to make this updated software available. Please support our continued efforts by learning how Dodeca® can help you deliver applications in a fraction of the time and cost of other solutions.
More Helpful Resources:
- Applied OLAP Products Brochure
- Dodeca Excel Add-In Brochure
- Twelve Reasons Our Clients Love Dodeca
- Twelve Ways Dodeca Makes Essbase Better
- Financial Managers FAQs
- Essbase Developers FAQs
- Oracle Network Essbase Forum
- Network54/TapaTalk Essbase Forum
- Tim Tow’s Hyperion Blog
- Jason Jones’ Hyperion Blog
- Tim Faitsch’s Essbase Blog