Currency rates as defined within sparse versus dense dim
Summary
Currency rates as defined within sparse versus dense dimContent
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).
0