Cubes and the detailed planning model

The first step in implementing a detailed planning model is to create a detailed planning cube, using the New Cube Wizard. As with a financial cube, when you create a detailed planning cube, you must also define its dimensions. After the cube is complete, you will eventually post calculation results to it. Typically you create one cube for each of your detailed planning models; for example, one for personnel planning, another for CAPEX, and so on.

What are the types of detailed planning cube? The available cube types are as follows:

  • Detailed Planning (General)

    A generic cube meant to be customized for any detailed planning model.    

  • Detailed Planning (Personnel)

    Identical to the generic cube, but with all dimensions required for a personnel planning application highlighted, including employees, allocation, and geography. The Employee dimension is assigned the type Detailed Planning Object.

Can detailed planning data be copied to a finance model? Most users of detailed planning also use FP&A for performance management, such as budgeting, analysis, reporting, and so on. In this case, you have the option of posting detailed planning results to your finance model as well. The only requirement is that this model contain certain shared dimensions.

 Note:   For personnel planning, the two financial model types that the detailed planning model can communicate with by default are Generic and Financial Consolidation.