HyperionSolutions

While running an Aggregation process or a restructure in essbase have you ever encountered either of these: EAS quits accepting logins Essbase going down time and again. Failed Data load / Failed Data Export / Failed Level 0 export All of the above together :) In all these cases, there is a huge possibility that you are facing creation of tmp files issue on your Essbase Server, specifically if you are on Linux The Temp directory contains mostly files that are required temporarily. Many programs use this to create lock files and for temporary storage of data. Do not remove files from this directory unless you know exactly what you are doing! Many of these files are important for currently running programs and deleting them may result in a system crash. Usually it won't contain more than a few KB anyway. On most systems, this directory is cleared out at boot or at shutdown by the local system. In MS-Dos  and Windows , the temporary directory is set by the environment

Below concepts involve Data Blocks in some way or the other, so to understand how Data Blocks behave it’s good to understand these concepts: Let's Begin!! Compression Clean and Dirty Blocks Fragmentation Restructure Compression: When Essbase stores blocks to disk, it can compress the data blocks using one of the following compression methods, this is based on the type of data that is being loaded into the Essbase database. Essbase provides several options for data compression: 1. Bitmap compression : This is the default compression method. Essbase stores only non-missing values and uses a bitmapping scheme. A bitmap uses one bit for each cell in the data block, whether the cell value is missing or non-missing. When a data block is not compressed, Essbase uses 8 bytes to store every non-missing cell. 2. Run-length encoding (RLE): Essbase compresses repetitive, consecutive values --any value that repeats three or more times consecutively, including

O2B Utility There are  times when we have to query the Hyperion Planning Application's relational database to get the Auditing reports, alas! we don't have an option to get them from our Planning interface. Many times we have wondered how to get the list of dimension members, data forms, there layouts, users security reports, task list status, supporting details, account annotations etc. What if there is a web based utility to take care of all this and more....!! My good friend, Rahul Sharma has taken the effort to design this utility .. Pleased to share the details on my blog: Let's start working on O2B Utility: http://hyperionplanningandmore.blogspot.in/2014/09/lets-start-working-with-o2b-utility.html What is O2B and How its useful to me ??? http://hyperionplanningandmore.blogspot.in/2014/09/what-is-o2b-and-how-its-useful-to-me.html How to deploy it to Weblogic: http://hyperionplanningandmore.blogspot.in/2014/09/deployment-of-o2b-on-webl