An Essbase application contains two types of data: the input data, that are loaded from relational tables or text files during database load, and calculated data, that are calculated starting from the input data during the database calculation. Both types of data are stored in cells of a data structure called a data block. For each unique combination of sparse dimension members, Essbase creates: a data block that contains data of all combinations of members in the dense dimensions. an index entry for that block. In this sample we have two sparse dimensions (Market and Product) and three dense dimensions (Scenario, Time, Accounts): For each data block, Essbase associates a unique number, called block…