Currency Conversion using Hyperion Essbase ASO

Namaste!

Currency Conversion is an important feature for multi-entity organization., esp., if the business operates in multiple countries.

Even though an organization could span across different countries, It would be fair to say that, ultimately, numbers from different countries would have to be converted into one single reporting currency.

Usually the reporting currency would be the currency where company is head-quartered. Along with that each country has got it's own legal reporting standards too.

How this currency conversion is being handled in Hyperion suite of the products?

HFM and Hyperion Planning tools have an out-of-box features to handle the currency conversion using exchange rates that fed into application.

Hyperion Essbase has no such default feature, though we could convert an Essbase BSO Application into Currency type. It has got it's own limitations to deal with.

One of the options to achieve the currency conversion in Essbase BSO or ASO is to design custom functionality using Calculation or MDX scripts.

In this video, I have demonstrated how to design currency conversion functionality using Hyperion Essbase ASO with MDX scripting.

Happy Learning!

I have published an Advanced course on Hyperion Essbase on Udemy. Here is the coupon code. Please check it out if you are interested.

https://www.udemy.com/course/hyperion-essbase-advanced-course/?couponCode=ESBADV9

Hyperion Essbase - XREF Functionality

Namaste!

Hyperion Essbase has got many features to enhance the multi-dimensional reporting functionality.

In some of the cases few budgeting departments in an organization would require to have a separate database dedicated for their department/cost centre due to the sensitive nature of the data.


For example Payroll department may have to budget the payroll expanses using drivers like employee, grade, department etc. This budget data would have to be secured and not visible to all
other department budget owners.

Also the granularity of employee or grade wise budget would cause more sparsity and result in bigger

database/cube size. All these reasons may add up to take a call on allocation of separate database/cube for payroll budgeting.


However for a consolidating reporting purpose, it would be necessary to bring back the total payroll

cost to main database/cube.

@XREF is the most popularly used feature to transfer the data from one database/cube to another

database/cube.

I have put together a video to demonstrate the XREF functionality of Hyperion Essbase.

Happy Learning!

I have published an Advanced course on Hyperion Essbase on Udemy. Here is the coupon code. Please check it out if you are interested.

https://www.udemy.com/course/hyperion-essbase-advanced-course/?couponCode=ESBADV9