TM1 Rules

Introduction
This document is intended for use with IBM® Planning Analytics and IBM TM1® Server.
Introduction to rules
This section provides an introduction to IBM Planning Analytics cube rules, which enable you to derive cell values through calculations.
A simple rule
The remaining sections of this documentation follow the transformation of data for a fictional company called Fishcakes International, which purchases different types of fish from markets around the world and uses that fish to make fishcakes.
Exchange rates
Fishcakes International purchases fish in multiple markets using different local currencies.
Using DB Functions to Move Data Between Cubes
As you have seen, Fishcakes International tracks fish purchases by market. However, as fish moves into inventory, you no longer need to track data by market. Instead you need to transform purchase data into inventory data, and then track inventory levels, inventory age, and the total daily cost of each type of fish in inventory.
Improving Performance with Feeders
This section examines feeders, a feature of IBM Cognos® TM1 rules that can greatly enhance performance.
Moving Data and Changing Levels
In you moved data between cubes that shared some common dimensions. In many cases, cubes have dimensions that are identical except for level.
Rules for Time-Based Calculations
In this section, you learn how you can use IBM Cognos TM1 rules functions to implement a variety of sophisticated time calculations. Time-based calculations appear in nearly all TM1 applications. Budgeting, planning, forecasting, trending moving averages, and cumulative sales totals all require time calculations.
Fixed Allocations
Fishcakes International wants to know the true input costs of each of its fishcakes every day. This is not a simple matter because each fishcake uses fish of various types from different markets, with different prices every day. Sometimes fish is used several days after it is purchased.
Stocks and Flows
In this section, you look at some ways to use IBM Cognos TM1 to keep track of stocks and flows. Many applications require some form of such calculations: P&L and balance sheet applications, inventory and production costing, and loan amortization, to name just a few.
Calculating Total Product Costs
One of the primary goals of the Fishcakes International model is to figure out what it costs, on a daily basis, to produce each type of fishcake. Between the Production, FishRequired and Inventory cubes, you have all the information necessary to calculate this daily cost in the Production cube.
Using the Rules Tracer
IBM Cognos TM1 provides a tool called the Rules Tracer to assist in the development and debugging of rules.