HOME

TheInfoList



OR:

IBM Planning Analytics powered by TM1 (formerly IBM
Cognos Cognos Incorporated was an Ottawa, Ontario-based company making business intelligence (BI) and performance management (PM) software. Founded in 1969, at its peak Cognos employed almost 3,500 people and served more than 23,000 customers in over ...
TM1, formerly Applix TM1, formerly Sinper TM/1) is a
business performance management Business performance management (BPM) (also known as corporate performance management (CPM) enterprise performance management (EPM),) is a management approach which encompasses a set of processes and analytical tools to ensure that a business o ...
software Software consists of computer programs that instruct the Execution (computing), execution of a computer. Software also includes design documents and specifications. The history of software is closely tied to the development of digital comput ...
suite designed to implement collaborative
planning Planning is the process of thinking regarding the activities required to achieve a desired goal. Planning is based on foresight, the fundamental capacity for mental time travel. Some researchers regard the evolution of forethought - the cap ...
, budgeting and forecasting solutions, interactive "what-if" analyses, as well as analytical and reporting applications. The
database server A database server is a server which uses a database application that provides database services to other computer programs or to computers, as defined by the client–server model. Database management systems (DBMSs) frequently provide database- ...
component of the software platform retains its historical name TM1. Data is stored in in-memory multidimensional OLAP
cubes A cube or regular hexahedron is a three-dimensional space, three-dimensional solid object in geometry, which is bounded by six congruent square (geometry), square faces, a type of polyhedron. It has twelve congruent edges and eight vertices. It i ...
, generally at the "leaf" level, and consolidated on demand. In addition to data, cubes can include encoded
rules Rule or ruling may refer to: Human activity * The exercise of political or personal control by someone with authority or power * Business rule, a rule pertaining to the structure or behavior internal to a business * School rule, a rule tha ...
which define any on-demand calculations. By design, computations (typically aggregation along
dimensional In physics and mathematics, the dimension of a mathematical space (or object) is informally defined as the minimum number of coordinates needed to specify any point within it. Thus, a line has a dimension of one (1D) because only one coordi ...
hierarchies using weighted summation) on the data are performed in near real-time, without the need to precalculate, due to a highly performant database design and calculation engine. These properties also allow the data to be updated frequently and by multiple users. TM1 is an example of a class of software products which implement the principles of the
functional database model The functional database model is used to support analytics applications such as financial planning and performance management. The functional database model, or the functional model for short, is different from but complementary to the relational ...
. The IBM Planning Analytics platform, in addition to the TM1 database server, includes an ETL tool, server management and monitoring tools and a number of user front ends which provide capabilities designed for common business planning and budgeting requirements, including workflow, adjustments, commentary, etc. The vendor currently offers the software both as a standalone on-premises product and in the
SaaS Software as a service (SaaS ) is a cloud computing service model where the provider offers use of application software to a client and manages all needed physical and software resources. SaaS is usually accessed via a web application. Unlike oth ...
model on the
cloud In meteorology, a cloud is an aerosol consisting of a visible mass of miniature liquid droplets, frozen crystals, or other particles, suspended in the atmosphere of a planetary body or similar space. Water or various other chemicals may ...
.


History

While working at Exxon, Lilly Whaley suggested developing a planning system using the IBM mainframe time sharing option (TSO) to replace the previous IMS based planning system and thereby significantly reduce running costs. Manuel "Manny" Perez, who had been in IT for most of his career, took it upon himself to develop a prototype. Right away he realized that in order to provide the multidimensionality and interactivity necessary it would be necessary to keep the data structures in computer memory rather than on disk. The business potential of the planning system Perez had developed became apparent to him and he began to explore the possibilities of commercializing it. Back in early 1981, the IBM personal computer had not yet been announced and the Apple II® was not in significant use at corporations, so initially, Perez looked to implement on a public mainframe timesharing system. Just in time, the IBM personal computer was announced. It provided a low cost development environment which Manny was quick to take advantage of. When
Visicalc VisiCalc ("visible calculator") is the first spreadsheet computer program for personal computers, originally released for the Apple II by VisiCorp on October 17, 1979. It is considered the killer application for the Apple II, turning the microco ...
was released, Perez became convinced that it was the ideal user interface for his visionary product: the Functional Database. With his friend Jose Sinai formed the Sinper Corporation in early 1983 and released his initial product, TM/1 (the "TM" in TM1 stands for "Table Manager"). Sinper was purchased by Applix in 1996, which was purchased by
Cognos Cognos Incorporated was an Ottawa, Ontario-based company making business intelligence (BI) and performance management (PM) software. Founded in 1969, at its peak Cognos employed almost 3,500 people and served more than 23,000 customers in over ...
in late 2007, which was in itself acquired mere months later by IBM. With its flagship TM1 product line, Applix was the purest OLAP vendor among publicly traded independent BI vendors prior to OLAP industry consolidation in 2007, and had the greatest growth rate. On December 16, 2016 IBM released a rebranded and expanded version of the software (IBM Planning Analytics Local 2.0 'powered by' IBM TM1) with a 'restarted' version numbering. The data server component is still referred to as TM1 and retains numbering continued from prior versions, so Planning Analytics version 2.x includes TM1 version 11.x.


Current Components

* TM1 Server * Planning Analytics Workspace (a.k.a. PAW) - main web front end and development environment * Planning Analytics for Microsoft Excel (a.k.a. PAfE, formerly PAx) - main Excel front end * TM1 Web - legacy web front end * TM1 Applications - legacy web front end * TM1 Perspectives - legacy Excel front end * TM1 Architect - legacy standalone Windows front end and development environment * TM1 Performance Modeler - legacy development environment


See also

*
Business intelligence Business intelligence (BI) consists of strategies, methodologies, and technologies used by enterprises for data analysis and management of business information. Common functions of BI technologies include Financial reporting, reporting, online an ...
*
Comparison of OLAP servers The following tables compare general and technical information for a number of online analytical processing (OLAP) servers. Please see the individual products articles for further information. General information Data storage modes APIs and q ...
*
Functional Database Model The functional database model is used to support analytics applications such as financial planning and performance management. The functional database model, or the functional model for short, is different from but complementary to the relational ...


References

{{reflist


External links


Product websiteThe Official History of TM1Patent for the database designMonitor for TM1 ServerBeyond the Spreadsheet: The Story of TM1 — Documentary Film, 2020
IBM software Online analytical processing