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