These are the settings to improve the performance of overall Planning application. There are two sections.
The following are Essbase concepts and hence we are not going into the detail about them.
Dense and Sparse: Defining a dimension as dense or sparse has a huge impact on the performance.
Order of dimensions: Even the order of dimension in an outline plays an important role in an application's performance. We'll learn what is recommended and how to change the order.
Dense dimensions are the ones which have maximum probability of occurrence in the combinations of dimensions. Generally, Accounts and Period dimensions are dense in nature. Coming to the sparse dimensions, they have lesser probability of occurrence, the examples would be Entity and Custom dimensions. The correct combination of dense and sparse dimensions would give best performance.
What performance are we talking about?
The dense – sparse combination determines the data block size and this data...