PRODUCTS
Distribution
Enterprise System
Product Brand
How does TM1 work?
TM1 provides the flexibility, interactivity and modeling power of spreadsheets, but retains the control, security and scalability of a database. Find the most important concepts, functions and benefits below.
Cubes, dimensions, hierarchies and rules are essential components of TM1. They provide a powerful framework for organizing and analyzing enterprise planning data and can help businesses gain valuable insights into their operations, performance and trends.
|
Cubes
Cubes are the central building blocks of TM1. They are multi-dimensional arrays of data that allow users to analyze and explore data from different perspectives. For example, a company might wish to summarize financial data by product, by time-period and by city to compare actual and budget expenses. |
Dimension
Dimensions are the categories or attributes by which data is organized within a cube. Dimensions provide context and meaning to the data and allow users to slice and dice data along different axes. Typical dimensions a cube might contain are time, versions, regions, products, departments and metrics. |
|---|---|
|
Hierarchies
Hierarchies are the logical organization of dimension members into a parent-child relationship. They provide a structure or organization to a dimension, allowing users to navigate and analyze KPIs at different levels of granularity or detail. For example, a time dimension hierarchy might include levels such as year, quarter, month and day. |
Rules
Rules are statements or instructions that govern the behavior of the database. Rules define how the database processes and calculates data, and how it responds to user queries and requests. Rules can be used to calculate purchase costs, exchange rates, inventory levels, inventory depletion and final production costs. |