Default members, MDX Scripts, Security, KPIs and Perspectives
What happens to the cube after the processing is complete but before cube is ready for the querying ? There are actually quite a few steps that should be taken in order to prepare the cube, like create calculated members and named sets, apply security, factor in actions and KPIs etc. In this article we will provide an overview of the most important steps and discuss issues directly following from how these steps are done and how the ordering of these steps is important.
Cube initialization sequence
At the very high level the following events happen before cube becomes available for querying: