• Home
  • Services
    • Corporate End Customer Services
      • Our Capabilities
      • Business Analytics
        • Business Intelligence
        • Predictive Analytics
        • Mobile Analytics
      • Performance Management
      • Data Warehousing
      • Big Data Analytics
      • Cloud Computing
    • Channel as a Service Partner
      • Fast Tracking Success
      • VAR Success Story
  • News
  • Company
    • Partnerships
    • Our Mission
    • Value Add
    • Business Model
    • Why Choose Us
    • Careers
  • Contact Us

TM1 OLAP Engine Applications

KCM SolutionsCase StudyJanuary 13, 2014

TM1 OLAP Engine Application – Banking

TM1 OLAP Engine Applications KCM Solutions

Business Challenge

A major financial institution faced a huge challenge of trying to make revenue forecasts easily predictable. They also struggled to drive growth and performance in a market that was volatile and had many tax and accounting requirements.

  • Finance managers had a hard time trying to determine revenue forecasts from balance sheets and profit and loss statements
  • Required an application that was Sarbanes-Oxley (SOX) compliant
  • Needed to gain a better understanding of their data in a simplified and user friendly way

The client wanted this to be performed using the Cognos TM1 OLAP Engine (formerly Applix) as there was a need to provide effective real-time views of large data sets. The TM1 OLAP server provides the capability to create multiple cubes of multi-dimensional data in the background. This cuts down development time of specific cubes for users and instead the customer will have multiple cubes in the background.

KCM’s Solution

  • Analyzed the client’s data for this implementation and built custom Data Marts using Cognos Data Manager as the ETL tool
  • Carried out test runs of the data to see what was the best way to present the information
  • Designed custom portals for the different levels at the client’s organization according to SOX rules and regulations
  • Incorporated a number of complex formulas and functionalities into the application as per the client’s needs
  • Conducted end-user training to get the users familiarized with the new application

Benefits

  • Immediate answers to business questions without the need for IT, increasing efficiency
  • The Advanced forecasting capabilities of the new application helped finance managers determine revenue forecasts accurately
  • Maintenance costs were cut and fewer resources used due to more compact data storage
  • Performance time for middle management was also improved, since their analysis were queried against cubes in the background

The real value that the client obtained from this implementation was an intuitive, web-based, SOX compliant, and easy to use application. The feedback from the users was unanimously positive.

 

Learn How To Move To The Cloud Risk Free.

Save on software licenses, infrastructure, operating costs and more. Find out how your business can move to the cloud risk free.

Download "How To Cut The Risk Of Moving To The Cloud" for FREE!
Tags: Contributor, ETL, OLAP, Planning, SOX Compliant

Our Services

  • Corporate End Customer Services
  • Channel as a Service Partner

Our Expertise

  • Sales
  • Marketing
  • Finance – Financial Analytics
  • Operations – Supply Chain Management

Recent Posts

  • The Top 5 Ways Traditional IT Is Slowing You Down
  • SPSS
  • IBM Cognos TM1
  • IBM Cognos 10
  • Cognos Data Warehouse Solutions

Why KCM Solutions?

Our team of expert consultants can help turn Sales, Marketing, and Finance related data into focused insightful and actionable information that can lead to better decisions, performance and outcomes.

By focusing on the Key Performance Indicators (KPI) that matter most, organizations become better aligned, aware, agile and take a proactive approach to decision making. KCM has worked with many leading companies to increase sales, marketing, and financial effectiveness across the organization.

Recent News

  • The Top 5 Ways Traditional IT Is Slowing You Down
  • SPSS
  • IBM Cognos TM1
  • IBM Cognos 10
  • Cognos Data Warehouse Solutions

Get An Advantage

To stay up-to-date on new technologies, ways to save on license agreements, promotions, industry events and more, please fill out the form below.

Contact Us

KCM Solutions Inc.
1 Yonge Street, Suite 1801
Toronto, Ontario M5E 1W7
CANADA: (647) 361-1501
US: (661) 615-2122
info@kcm-solutions.com
Facebook
Twitter
Google+
LinkedIn
YouTube
IBM Cloud Computing Business Partners
HomeChannel as a Service PartnerCorporate CustomerContact UsPrivacy StatementTerms of UseSitemap
© 2019 All rights reserved. KCM Solutions
Website by Collabo