IBM Apptio

IBM Apptio

A place for Apptio product users to learn, connect, share and grow together.

 View Only
Back to Library

AWS Billing Reports in Apptio 

Fri November 17, 2017 12:58 PM

Overview of AWS Billing Reports

AWS currently offers several different sources of billing data, each with it's own characteristics and uses.  For a more detailed view into the billing reports offered by AWS, please refer to AWS' documentation here: Understanding Your Usage with Billing Reports - AWS Billing and Cost Management 

Billing Reports Used Within Apptio

While Apptio can support data from a large variety of sources, we offer purpose-built integrations around a subset of AWS' billing reports.  Currently, Apptio has built integrations with the following billing reports:

Cost Allocation Report

This is AWS' monthly-grain bill that includes all the billing details (e.g. AWS product, usage quantity, cost, etc) as well as tags selected to be included in bills.  Apptio leverages the Cost Allocation Report to drive public cloud monthly TCO reporting.

Detailed Billing Report with Resources and Tags

This is AWS' hourly-grain bill that, similar to the Cost Allocation Report, includes both billing details as well as tags.  Apptio leverages the Detailed Billing Report with Resources and Tags to drive the recently released (Nov, 2017) Daily Costs reporting in Cloud Cost Management where you can see month-to-date costs as of the current day, as well as daily and even hourly trending of AWS costs. 

 

*Important note about the Detailed Billing Report with Resources and Tags - This bill can become excessively large (100m+ rows per month) resulting from the combination of the hourly detail along with the inherent detail in AWS billing.  As your organization's AWS spend increases, the size of this bill may be too large to bring into Apptio as a native .csv file. 

 

With Apptio's 12.3.3 release and the latest Datalink version, you will see a Detailed Billing Report with Resources and Tags (automatic transform) option.  This new AWS connector option will allow you to ingest the Detailed Billing Report with Resources and Tags in a new format on which the Daily Costs reporting is built.  This new format, while serving as the foundation for the daily reports in Cloud Cost Management, is not currently available for transforms or modeling in TBM Studio.  The Cost Allocation report is still the source for monthly billing.

 

What about the AWS Cost and Usage Report (CUR)?

AWS has a newer billing report that is the go forward standard for AWS bills.  Apptio is currently working on integrating with the CUR and has plans to provide a CUR-based connector in an upcoming release. 


#public cloud
#aws

#APACUserConference



#CostingStandard(CT-Foundation)
#AWS
#CloudServices
#Reports
#Costing

Statistics
0 Favorited
2 Views
0 Files
0 Shares
0 Downloads

Comments

Apptio Community Member
Wed December 19, 2018 02:56 PM

Thanks, Matt... the CUR will be supported in our upcoming 12.6 release slotted for early January.  We will enable the ingestion of the CUR via the new Multi-Cloud Connector due to be available in Datalink at the same time as 12.6.  With the CUR, you will get the following benefits/capabilities:

  • Independence from the to-be-deprecated Cost Allocation Report and Detailed Billing Report
  • Reserved Instance inventory across all accounts and products as part of the CUR eliminating the need to ingest RIs via separate connectors
  • Ability to see Resource Id level granularity of costs and consumption (not available in the Cost Allocation Report)
  • Improved consistency of costs across services - e.g. the DBR included used RI costs in the Unblended Cost column for EC2, but not for other services

Along with the CUR, 12.6 will include some CUR-related features including:

  • A Cloud Mapping Transform Pipeline Step - allowing you to use both direct mapping as well as Tablematch lookup functionality to derive Apptio attributes (e.g. Business Unit, Application, among others) from billing account data and tags.
  • The Multi-Cloud Connector - a single connector for all cloud data.  The initial version will focus on AWS and Azure billing only with plans to extend to other providers and other data in upcoming versions.

#CostingStandard(CT-Foundation)

Matt Temple
Wed December 19, 2018 02:42 PM

I'm getting more eager to have the CUR supported as colleagues are pressing for its adoption over the pending deprecation of the CAR.

 

@Randall Tennant @Andrew Lee @Brett Yates any hints or feedback you can share would be appreciated. ;-)


#CostingStandard(CT-Foundation)

Apptio Community Member
Tue December 18, 2018 07:39 PM

is this new report supported by Apptio now?


#CostingStandard(CT-Foundation)