You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Currency rates as defined within sparse versus dense dim

edited Aug 2, 2018 2:36AM in Essbase 2 comments

Summary

Currency rates as defined within sparse versus dense dim

Content

hello,

I'm setting up some currency conversion in a non-currency database in Essbase.  Currently there is 10 currencies and I'm told that this will never change (of course). The database contains 10 dims, where Account and Period are dense.  The other 8 dims are sparse (scenario, version, measure, product, entity, currency ( only 2 members local and usd), and location, and finally type)

My initial thought is to store the currency rates in the Measure dim (sparse) as such

     rate_EURO

     rate_POUND

     rate_YEN

     etc

and create an account called curr_rate in the account dim (dense).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!