Public Cloud TCO Configuration

Edit online

Overview

The IBM Apptio Public Cloud TCO Reports offer Finance team members, typical users of the IBM Apptio product, valuable insights into their monthly cloud spend. These reports provide a financial perspective on which public cloud services are impacting costs, identifying primary cost drivers and their effects. It also helps the Finance teams to understand trends, performance, and the necessity of FinOps practices for optimal cloud operation for the following two major cloud service providers:

Amazon Web Services (AWS)

Microsoft Azure

The following specific problems can be solved by this solution.

image

Configuration Steps

  1. (TBM Studio): Create a Project.
  2. (TBM Studio):

    Template_V120 : Install “Public Cloud TCO” component in the project.

    image

    Template_V200 : Install “Cost- Public Cloud TCO” & “Cost- Public Cloud TCO Reporting” component in the project.

    image

    Architecture

    image

    Note: Data for “cldy_monthly_aws” & “cldy_monthly_azure” can be fetched from Cloudability CDI Datalink Connector. Data for Reserved Hours can be fetched from Cloudabitlity RI reports through REST Services Datalink Connector.

    Reference Snapshot for Cloudability RI reports

    image

  3. (TBM Studio):

    Template v120 & Template v200 : Create 5 input tables (refer to the Sample screenshot) to ensure relevant details are uploaded and map these datasets to the input data tables given below

    Account Name Mapping: This refers to the list of account names retrieved from the cldy_monthly_aws and cldy_monthly_azure datasets.

    New Name: This maps or groups the AccountName values to the corresponding chart of accounts.

    If an account cannot be mapped to a New Name, the model is designed to default to the existing AccountName. image

    Business Unit Reference

    It is used to normalize various region names into standardized ones.

    image

    Cloud Tower Mapping

    It is used to map different Usage Families to their respective Cloud Tower Names.

    image

    Cost Center Listing

    It is used to map the Cost Center and Category to the master table; if not mapped, they will be marked as "Unassigned." image

    Reserved Hours

    It is used in the calculation of different metrics for Reserved Instances outlined below.

    image

    Sample for Reference:

    Name of the tables can be customer specific

    image

    Reference Mapping Sample: In the above example the mapping is done as followed:
    • Account Mapping -> Account Name Mapping
    • BU Reference Input -> Business Unit Reference
    • Cloud Tower Mapping Input -> Cloud Tower Mapping
    • CC Input -> Cost Center Listing
    • RI input -> Reserved Hours
  4. (TBM Studio): Save and Check in the changes.

    ** Additional Step for Template v120 (TBM Studio) : Map below tables to ‘IT Finance Cloud Master Data’.

    image

    Tip: Define the Data source Column = Name of the input CSP

    Ex: Map Data Source= ‘cldy_monthly_aws’ while mapping cldy_monthly_aws to IT Finance Cloud Master Data image
    Note: In Template_v200, these tables are already mapped to the ‘IT Finance Master Data’.
  5. (TBM Studio):

Template v120 & Template v200 : Open ‘IT Finance Cloud’ and verify the cost allocations.

Cost

image

**This screenshot is for reference purpose and the cost allocations may vary as per the data

Cloud Credits

image

**This screenshot is for reference purpose and the cost allocations may vary as per the data

Reporting Structure

image

Key Element Description

1. Financial and Operational Summary of Cloud for Cost YTD including any Credits applicable
2. Additional metadata makes it self-intuitive, aligns taxonomy and makes it easy to comprehend.

3. The cost trending across different Cloud Services (AWS & Microsoft Azure).

4. The cost trends by business attributes such as Provider, Cost Centre, Account Name, etc.

image

Description

1. The Report enhances about the services driving the cost direction.

2. The effectiveness of the Cloud Purchase model and how it compares to Best-in-Class benchmarks.

3. The trend of the unit rate in relation to changes in consumption.

4. Detailed breakdown of Costs, consumption and unit rates across Service Providers

Drilldown Reports

Drill down further to understand the Business & Technical drivers for each of the reports.
  • The factors driving the service cost, including which account is responsible and the corresponding amount.
  • The business service/application that drove the change.

Cloud Cost - Details

image

CPU Hours - Details

image

Storage - Details

image