29:
374:
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
400:
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
378:
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
379:
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.
375:
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.
390:. 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
397:
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.
340:, 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.
565:
46:
535:
355:
which provide capabilities designed for common business planning and budgeting requirements, including workflow, adjustments, commentary, etc.
637:
93:
112:
65:
293:
72:
50:
300:
79:
166:
446:
333:
61:
39:
451:
387:
344:
348:
197:
573:
324:, generally at the "leaf" level, and consolidated on demand. In addition to data, cubes can include encoded
217:
632:
441:
543:
386:
was released, Perez became convinced that it was the ideal user interface for his visionary product:
253:
17:
86:
337:
232:
352:
329:
315:
212:
471:
358:
The vendor currently offers the software both as a standalone on-premises product and in the
248:
192:
347:. The IBM Planning Analytics platform, in addition to the TM1 database server, includes an
413:
Planning
Analytics Workspace (a.k.a. PAW) - main web front end and development environment
363:
311:
416:
Planning
Analytics for Microsoft Excel (a.k.a. PAfE, formerly PAx) - main Excel front end
343:
TM1 is an example of a class of software products which implement the principles of the
325:
314:
component of the software platform retains its historical name TM1. Data is stored in
626:
597:
303:, budgeting and forecasting solutions, interactive "what-if" analyses, as well as
264:
28:
428:
TM1 Architect - legacy standalone
Windows front end and development environment
607:
131:
328:
which define any on-demand calculations. By design, computations (typically
321:
304:
241:
612:
383:
296:
618:
Beyond the
Spreadsheet: The Story of TM1 — Documentary Film, 2020
394:
in late 2007, which was in itself acquired mere months later by IBM.
391:
289:
285:
336:
hierarchies using weighted summation) on the data are performed in
318:
237:
201:
359:
205:
602:
512:
172:
IBM Planning
Analytics Local 2.0.9 / December 16, 2019
136:
22:
351:
tool, server management and monitoring tools and a number of
431:
TM1 Performance
Modeler - legacy development environment
617:
259:
247:
231:
223:
211:
191:
165:
142:
130:
53:. Unsourced material may be challenged and removed.
490:
401:Analytics version 2.x includes TM1 version 11.x.
8:
125:
485:
483:
481:
299:suite designed to implement collaborative
124:
16:"TM1" redirects here. For other uses, see
425:TM1 Perspectives - legacy Excel front end
113:Learn how and when to remove this message
492:Beyond the Spreadsheet: The Story of TM1
463:
422:TM1 Applications - legacy web front end
282:IBM Planning Analytics powered by TM1
126:IBM Planning Analytics powered by TM1
7:
51:adding citations to reliable sources
536:"Consolidations in the BI industry"
14:
570:The BI Verdict (The OLAP Report)
540:The BI Verdict (The OLAP Report)
292:TM1, formerly Sinper TM/1) is a
27:
294:business performance management
38:needs additional citations for
608:Patent for the database design
566:"Commentary: The OLAP Revival"
419:TM1 Web - legacy web front end
1:
638:Online analytical processing
564:Carsten Bange (2008-11-14).
307:and reporting applications.
603:The Official History of TM1
534:Nigel Pendse (2008-03-07).
514:The Official History of TM1
148:; 41 years ago
654:
447:Comparison of OLAP servers
15:
452:Functional Database Model
345:functional database model
187:
161:
198:Microsoft Windows Server
62:"IBM Planning Analytics"
388:the Functional Database
218:Cross-platform software
613:Monitor for TM1 Server
442:Business intelligence
319:multidimensional OLAP
174:; 4 years ago
254:Proprietary software
157:, as Sinper TM/1 1.0
47:improve this article
18:TM1 (disambiguation)
273:/planning-analytics
127:
405:Current Components
279:
278:
123:
122:
115:
97:
645:
585:
584:
582:
581:
572:. Archived from
561:
555:
554:
552:
551:
542:. Archived from
531:
525:
524:
523:
522:
509:
503:
502:
501:
500:
487:
476:
475:
474:. February 1988.
468:
275:
272:
270:
268:
266:
193:Operating system
182:
180:
175:
156:
154:
149:
128:
118:
111:
107:
104:
98:
96:
55:
31:
23:
653:
652:
648:
647:
646:
644:
643:
642:
623:
622:
598:Product website
594:
589:
588:
579:
577:
563:
562:
558:
549:
547:
533:
532:
528:
520:
518:
511:
510:
506:
498:
496:
489:
488:
479:
470:
469:
465:
460:
438:
407:
372:
353:user front ends
312:database server
263:
240:
183:
178:
176:
173:
152:
150:
147:
143:Initial release
119:
108:
102:
99:
56:
54:
44:
32:
21:
12:
11:
5:
651:
649:
641:
640:
635:
625:
624:
621:
620:
615:
610:
605:
600:
593:
592:External links
590:
587:
586:
556:
526:
504:
477:
462:
461:
459:
456:
455:
454:
449:
444:
437:
434:
433:
432:
429:
426:
423:
420:
417:
414:
411:
406:
403:
371:
368:
338:near real-time
288:TM1, formerly
284:(formerly IBM
277:
276:
261:
257:
256:
251:
245:
244:
235:
229:
228:
225:
221:
220:
215:
209:
208:
195:
189:
188:
185:
184:
171:
169:
167:Stable release
163:
162:
159:
158:
144:
140:
139:
134:
121:
120:
35:
33:
26:
13:
10:
9:
6:
4:
3:
2:
650:
639:
636:
634:
631:
630:
628:
619:
616:
614:
611:
609:
606:
604:
601:
599:
596:
595:
591:
576:on 2009-12-02
575:
571:
567:
560:
557:
546:on 2013-07-10
545:
541:
537:
530:
527:
516:
515:
508:
505:
494:
493:
486:
484:
482:
478:
473:
467:
464:
457:
453:
450:
448:
445:
443:
440:
439:
435:
430:
427:
424:
421:
418:
415:
412:
409:
408:
404:
402:
398:
395:
393:
389:
385:
380:
376:
369:
367:
365:
362:model on the
361:
356:
354:
350:
346:
341:
339:
335:
331:
327:
323:
320:
317:
313:
308:
306:
302:
298:
295:
291:
287:
283:
274:
262:
258:
255:
252:
250:
246:
243:
239:
236:
234:
230:
227:Multi-lingual
226:
222:
219:
216:
214:
210:
207:
203:
199:
196:
194:
190:
186:
170:
168:
164:
160:
145:
141:
138:
135:
133:
129:
117:
114:
106:
95:
92:
88:
85:
81:
78:
74:
71:
67:
64: –
63:
59:
58:Find sources:
52:
48:
42:
41:
36:This article
34:
30:
25:
24:
19:
633:IBM software
578:. Retrieved
574:the original
569:
559:
548:. Retrieved
544:the original
539:
529:
519:, retrieved
513:
507:
497:, retrieved
491:
466:
399:
396:
381:
377:
373:
357:
342:
309:
281:
280:
224:Available in
132:Developer(s)
109:
103:January 2015
100:
90:
83:
76:
69:
57:
45:Please help
40:verification
37:
472:"InfoWorld"
334:dimensional
330:aggregation
627:Categories
580:2010-02-20
550:2010-02-20
521:2018-05-07
517:, Cubewise
499:2021-01-18
495:, Cubewise
458:References
410:TM1 Server
305:analytical
179:2019-12-16
73:newspapers
316:in-memory
271:/products
242:Analytics
436:See also
384:Visicalc
301:planning
297:software
213:Platform
370:History
260:Website
249:License
177: (
151: (
87:scholar
392:Cognos
332:along
290:Applix
286:Cognos
89:
82:
75:
68:
60:
382:When
364:cloud
326:rules
322:cubes
238:MOLAP
202:Linux
94:JSTOR
80:books
360:SaaS
310:The
269:.com
267:.ibm
233:Type
206:UNIX
153:1983
146:1983
66:news
349:ETL
265:www
137:IBM
49:by
629::
568:.
538:.
480:^
366:.
204:,
200:,
583:.
553:.
181:)
155:)
116:)
110:(
105:)
101:(
91:·
84:·
77:·
70:·
43:.
20:.
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.