This Planning Analytics sample model demonstrates good model design principles. It was built using Planning Analytics Workspace and contains examples of cubes, dimensions, hierarchies, and calculations. The ZIP file contains an associated book.
For installation instructions, see Planning Analytics sample databases and books installation guide.
You design a model in response to a business need. For example, a company wants to plan its expenses for the next 12 months by expense line. The company collects the information from a number of departments that are spread across a wide geographical area.
A model has the following basic building blocks: dimensions, cubes, and links.
Multidimensional cubes are central to the model. You create views from the cubes so that you can see just the information that you need, and you can have many different views of the same cube. For example, a regional manager might want to review data at a consolidated level, and a department manager might want to input the detailed data for their department. They use the same cube but see different views.
For more information, see Steps to building a model.