Not using Multicurrency option in Hyperion Planning has its own benefits


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. Learn More about: Hyperion Planning 11.1.2.3 Upgrade

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. Click here Oracle cloud services to learn more.

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.

Original Source of Blog: https://www.jadeglobal.com/resources/case-study/hyperion-planning-11123-upgrade


Comments

Post a Comment

Popular posts from this blog

Whitepaper - Mobile Application Testing

With the advent of smartphones, a mobile phone has evolved from being just a communication device to a highly sophisticated business utility equipment. With smartphones no longer remaining a conspicuous consumption, they have become an efficient tool for handling finances, managing mails & agendas, and executing other business functions. Statistics highlight that 1.6 billion smart phones are sold at a rate of 1.8 to 2 million devices a day since 2007, and 1.5 billion smartphones will be shipped in 2016 – a 5.7 percent increase from 2015 – and will reach 1.92 billion by 2020. Download whitepaper - Mobile application testing
Read more

Key Features of Oracle Financial Consolidation & Close Cloud Service (FCCS)

Image
Oracle Financial Consolidation and Close Cloud Service (FCCS) is the newest addition to the Oracle EPM Services . FCCS is a solution to streamline the accounting activities associated with the month-end financial close. FCCS leverages Oracle’s experience with financial processes. This article outlines the key areas of Oracle FCCS: Top Features of FCCS including Integrated Close Analytics and Improved User Experience The FCCS Transparent Close Processes Integrated Workflow Process-concentric Financial Close   FCCS Consolidation & Reporting Process     What Does FCCS Include?   Features of Financial Consolidation & Close Cloud Services Close and Consolidation : Cash flow, Balance sheet, Income statement, Rollovers, Call-to-Actions, and more are automatically calculated. Leverage multi-GAAP driven with full currency support, inter-company eliminations, equity eliminations, adjustments, and applications detailed dat
Read more

Tableau CRM features and Setup guide

Image
What is Tableau CRM? Many enterprises have leveraged Salesforce out-of-the-box reports and dashboards to understand their data and performance for years. However, data size has been increasing rapidly daily; analyzing the data manually has become a bigger challenge; subsequently, analytics have become more critical than ever before. Learn more about Salesforce CRM implemetation   Tableau CRM (Formerly known as Einstein Analytics) was introduced to address this challenge. It's an AI (Artificial intelligence) powered advanced analytics solution which works with any data source. The AI-powered Einstein Discovery, Einstein Analytics apps analyze billions of data combinations and provide predictive insights and prescriptive recommendations to the users. Tableau CRM provides analytic experiences in sales, service, and marketing to quickly take business decisions and actions. This platform is also optimized for mobile use. Why Tableau CRM? The key differences between Tableau C
Read more