|
The possibilities for any Hyperion Essbase cube are virtually limitless. If you’re like most companies, you have vast amounts of data in the system, simply waiting to be processed, and you can’t just throw any of it into the system and create a helpful cube. Instead, you need to do a bit of planning of you’re really going to generate the data necessary for review. Start by focusing on the users for your Hyperion Essbase cube. Think carefully about who might need access. Understanding how many people may want the information, their level of experience, and their job functions are a key part of the process. Along with that, you’ll need to consider their own objectives with the cube. Think carefully about what questions they might want it to answer and how it might be used within the decision making process. You should also consider the kinds of improvements to which your cube may lead. If you can’t come up with any, or you’re not sure how it might be used, this may not be the best topic on which to build a cube. When you feel comfortable with the topic for your cube, it’s time to start looking at things from a metrics standpoint. You’ll have to build in the measurements necessary to meet the objectives you’ve already defined for yourself. Rates, percentages, and variances will likely all be part of the setup. Once you begin to define the dimensions, you may want to make label outlines for each of them. A label outline offers the dimension name and the two parallel hierarchies. The first will list a name for the generations while the second will list out an actual example for every generation. While you’re mapping things, make certain to note the space you expect to need for each dimension. It will help you make decisions about sparse and dense configurations in terms of storage. Access also has to be part of the decision making process. Knowing more about the views that will provide them with the necessary information is another important step. Naturally this will factor into your overall objectives somewhat, but careful evaluation of the reports each user will need and the layouts that will make the information easiest to understand means your users are going to be able to grasp the overall picture of your Hyperion Essbase cube quickly and easily. Input is almost as important in the Hyperion essbase planning process. You have to think about the sources of your data as well as the formats and the size of the file you’ll be inputting. Don’t forget to factor in the frequency of input file creation, too. Load rules for your input files also need to be a part of this process. If you’ll have different sources, you may need different rules. Is your cube’s purpose up to snuff? Will the data actually serve the purpose for which you created it? This planning process may make all of the difference in the world to your time management as you work with Hyperion Essbase. Established in 1985, Codec Systems is one of the UK’s leading Hyperion Essbase implementation partners and is the current Silver Hyperion Partner of the Year. We are certified to highest level with Oracle as we currently hold a Hyperion Planning and Hyperion Essbase certification.
Related Articles -
Hyperion Essbase, Hyperion essbase planning, Codec Systems, Hyperion Essbase implementation,
| 
