Steps to building a model

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.

Dimensions give the cubes structure. A cube must have a minimum of two dimensions, but the total number of dimensions a cube can have is determined by its use. A cube that stores data can have many dimensions. A cube that is viewed by a user should have enough dimensions to define the data, but not so many dimensions that the cube is difficult to navigate. You can use hierarchies to reduce the number of dimensions in a model, while giving you the option to see alternative rollups of data.

You can quickly add business logic such as links, by creating rules.

You make the data available to other colleagues by creating books and adding views, scorecards, visualizations, graphics, and videos, and then sharing the book with them.

Design dimensions

To make the data available for input and analysis, you must first create dimensions. Some examples of dimensions are Chart of Accounts, Products, Time, and Versions.

Find out more in Dimensions in Planning Analytics Workspace.

Create hierarchies

Use hierarchies to simplify your model design. A hierarchy acts as a virtual dimension, enabling you to see alternative rollups of the same view without creating additional dimensions. This makes a model easier to maintain.

Find out more in Hierarchies.

Create cubes

Use dimensions to build cubes. A cube is a store of data within a model. It is multidimensional and contains rows, columns, and any number of pages. Some examples of cubes are sales planning or expense analysis.

Find out more in Cubes.

Create rules and processes

You can create rules for calculations, and processes for managing and maintaining the model. Processes can then be grouped into chores for coordinated and automated execution.

Find out more in Rules, TurboIntegrator processes, and TurboIntegrator chores.