Amazon Web Services Case Study

Amazon Logo

Company Profile

Amazon Web Services (AWS) is a dynamic, growing business unit within Amazon.com. AWS is a secure cloud services platform, offering compute power, database storage, content delivery and other functionality to help organizations scale and grow. Millions of customers, from AirBnB to MLB, trust AWS Cloud products and solutions to build sophisticated applications with increased flexibility, scalability and reliability.

Business Situation

As a brief overview, TM1 is a robust financial planning & analytics platform that is extremely flexible and scalable. Amazon has been successfully using TM1 for high-level financial planning and consolidation for the entire corporate entity for four years. In addition, over the last three plus years, CarpeDatum has architected and developed a number of TM1 solutions for Amazon Web Services including; detailed expense and capital planning for their computing infrastructure, sophisticated capacity planning, detailed usage and revenue planning, consolidated P&L’s for SEC reporting, and a sophisticated cost allocation system that allows AWS to generate P&L’s for 50+ different products.

AWS simply needed another solution that was able to extract TM1 data into its other reporting tools they wanted a solution that could:

  1. Extract and get to data without a turbo integrator developer
  2. Flexibly design their own extracts without a need for TM1 TI Dev
  3. Maintain views overtime and create news ones in an intelligent system
  4. Translates multi-dimensional data into relational format

Technical Situation

Amazon has over 20 TM1 instances and has 14 developers. They needed a flexible solution where they could extract TM1 data into a variety of other systems without Admin.
AWS’s biggest situation was that they had Dev’s spend several weeks on 1 dimension or 1 extract. TM1Connect allows that work to be done in minutes.


 © 2019 CarpeDatum Consulting, Inc.

TM1CONNECT IS POWERED BY CARPEDATUM CONSULTING, INC. IBM, COGNOS, TM1 AND THE PREMIER BUSINESS PARTNER EMBLEM ARE TRADEMARKS OR REGISTERED TRADEMARKS OF INTERNATIONAL BUSINESS MACHINES. TABLEAU AND THE TABLEAU PARTNER EMBLEM ARE REGISTERED TRADEMARKS OF TABLEAU SOFTWARE. QLIK AND THE QLIK PARTNER EMBLEM ARE REGISTERED TRADEMARKS OF QLIKTECH INTERNATIONAL. MICROSOFT AND THE MICROSOFT GOLD PARTNER EMBLEM ARE REGISTERED TRADEMARKS OR MICROSOFT CORPORATION.

#TM1DataEverywhere