Not using Multicurrency option in Hyperion Planning has its own benefits

Jade Global
July 27, 2017

Hyperion Planning applications often require multiple currencies. Hyperion Planning includes a currency option that easily allows multiple currencies to be managed. Allowing Planning to manage this, introduces a couple of limitations and costs. These can be avoided if currency is managed manually.

When the Hyperion Planning currency option is enabled, an additional 2 dimensions are required. This raises the required dimensions from 6 to 8. Most planning applications have a need for at least 2 to 3 custom dimensions. Even smaller applications suffer greatly when adding the additional 2 dimensions. So, by using the currency option, the ability to use custom dimensions is limited. By adding a few accounts to hold the currency conversion and adding one dimension that has members for all the currencies, multi-currency applications can be handled with only one additional dimension. If the currency option is not used, the currency calculations may be written more efficiently than the default calculations introduced with the currency option.

Another drawback with the currency option is that is only allows data input to the base currency. Most the applications that we have built require multiple currencies, require the input at more than base currency. Assume a retail company that has stores in a number of countries with different currencies. Salaries may be budgeted in the local currencies, but the cost of the bags used by customers to carry merchandise out of the store is budgeted in USD. The costs are distributed in USD based on units, and converted to the local currencies. Success story: Hyperion Planning Upgrade

Lastly, using the currency option, because of the number of dense dimensions, limits the number of time periods. Executing calculations is limited to using 64k of memory. Applications that use something other than month (like week, or day) can regularly hit this limit.

Add New Comment

Restricted HTML

  • Allowed HTML tags: <a href hreflang> <em> <strong> <cite> <blockquote cite> <code> <ul type> <ol start type> <li> <dl> <dt> <dd> <h2 id> <h3 id> <h4 id> <h5 id> <h6 id>
  • Lines and paragraphs break automatically.
  • Web page addresses and email addresses turn into links automatically.