资 源 简 介
Why the Store Text In Essbase Add-In Is Useful
This Excel Add-In compresses strings so that they can be stored directly in Essbase as numbers. The Add-In exists to host the two formulas, to compress and decompress.
Traditionally, we learned that Essbase could not store text. This is because of the way the database engine is optimized for financial data. This is still true, although in version 11, Oracle has added the ability to store “typed measures,” which means dates or enumerated strings. This is nice, but an enumerated string must be defined and stored in a separate relational database. With the Store Text In Essbase Add-In, you store the string directly in Essbase. The disadvantage of this add-in, however, is that it is limited in the size of strings it can store without spanning multiple members (see the “Sample” workbook tab in the Store Text In Essbase Excel workbook on the download page for examples.)
How It Works
If you think of the