Here are some quick tips to check when tuning your BSO application: 1. Dimension Order ♦ Use the hourglass model: Largest dense to smallest dense, smallest sparse to largest sparse ♦ Attribute dimensions are always last. 2. Dense/Sparse Settings ♦ Typically, your accounts and period dimensions are classified as dense. 3....
Understanding BSO Data Storage in Essbase
Not only is Essbase a leading calculation engine, but as a multidimensional database, it is also efficient at storing data. Essbase creates data blocks and an index system in order to access and store data into a cube. The cube above contains three dimensions: Scenario Accounts Period Data values are...
Discover how our OneStream implementation services enable your organization to streamline the financial close, report with confidence, and deliver faster, more accurate insights to stakeholders.