Changing the Essbase Query Timeout Setting

If you're receiving an error along the lines of the following, it is likely because your query governor setting is too low --

Error executing query Error internal JAPI

Error:[Cannot perform cube view operation ESSbase Error(1024016): Request [xxxx] from user [xxxx] was terminated since it exceeded the time limit

Moving Calculation Rules with LCM

Life Cycle Management (LCM) is a wonderful tool for archiving, migrating and just plain managing artifacts -- such as outlines, forms, reports, etc. This post isn't a tutorial on how to use LCM (I'll leave that for another day). But it is a keep-this-in-mind post for when you're using LCM to deal with calculation rules.

Calculation Manager

The methodology for manipulating data within a planning application is to use the Calculation Manager(1) found within the Hyperion Workspace. The navigation path to access the manager is:

Navigate->Administer->Calculation Manager

References

(1) The Oracle-published administrator's guide for the Calculation Manager is Oracle Hyperion Calculation Manager Designer's Guide.

Moving Data - EBS Target Requirements

Often one of the primary purposes for creating a planning application in Hyperion is to transfer the budget information back into the organization's ERP system(s). One such system is Oracle's eBusiness Suite (EBS). While there are integration tools designed to help streamline the process of connecting the ERP and EPM systems, it can be very helpful to understand the process from the ground-up before wrapping it with a pretty user interface.

This series of posts will start at the target system and investigate how data is imported into the system manually. Then we will build upon that understanding to see how the layers of integration work to map the connection between the Hyperion planning application and the ERP system, allowing an automated integration between the two system. We will use the EBS ERP system for our study, but the process is the same regardless of the ERP system.