Pre-Defined Reports

Viewing Your Public Cloud Billing Reports

Viewing Your Public Cloud Billing Reports

#380550

The Densify Cloud Cost Intelligence module allows you to review your billing data through a dedicated reporting interface.

Note: Currently, collection and analysis of billing data is only supported for AWS.

Prerequisites

The following prerequisites must be addressed before you can access the Cloud Cost Intelligence module:

  • Enable the module—Cloud Cost Intelligence is a separate module that must be licensed separately and enabled by your Cloud Advisor. Contact your Cloud Advisor or support@densify.com for details.
  • Configure and initiate data collection—You must also initiate collection of your billing data. Refer to AWS Data Collection Prerequisites for an IAM Role for details on configuring and collecting billing data.
  • Join the Billing_Analyst group—Your Densify user account must be a member of the Billing_Analyst group. Once the module has been enabled, your Cloud Advisor will either create a new billing analyst user account or add your existing account to the Billing_Analyst group. See Managing Densify User Accounts.

The Densify Console has been optimized for Google Chrome so this browser is highly recommended for the richest user experience.

Accessing the Cloud Cost Intelligence Module

  1. Login into Densify using your Billing_Analyst user account.
  2. You will be prompted to select which console to open. Select Cloud Cost Intelligence module.
  3. When you log out of the Cloud Cost Intelligence module, you are returned to the Densify login page. You need to login in and select the Densify Console to access other Densify features.

Cloud Cost Intelligence Overview

Densify collects, loads and processes your AWS cost and usage report (CUR). Refer to AWS for details on the content of the cost and usage report. Refer to AWS Data Collection Prerequisites for an IAM Role for details on configuring the cost and usage report and collecting billing data.

This module provides a cost navigator and a view of your Reserved Instance usage. The Cost Navigator is displayed be default.

The data displayed in each report is based on both:

  • Selected options at the top of the page;
  • Filters located on the left side of the page.

You can customize and save a set of options that you can then access at any time, through the Reports drop down menu.

Note: The Report Library tab at the top of page is intended for future development. Depending on your specific installation you may see many reports listed here, but they are not intended to be accessed from the Cloud Cost Intelligence module. Your custom reports are available through Densify ConsoleMy Reports.

Once the billing data has been collected by Densify, the following tabs provide the tools to review your bill:

  • Chart view—Provides a chart summary of your billing data. The type of chart view is selectable.
  • Tabular View—Provides a tabular summary of the same data set.

The AWS billing data displayed is based on the options selected at the top of the page. See Grouping and Filtering Your Data, below.

Chart Type Selection

You can choose from various chart types to best suit your requirements. The chart type selection is not saved when your report options are saved.

Note: This feature is not applicable to the Reserved Instance Utilization Report.

The following chart types are provided:

  • Column, which compares values displayed as columns. Three report options are available:
    • Column—Group members are shown as individual columns.
    • Stacked Column—Group members are show as portions of a single column whose size reflects the aggregate value of the group.
    • Percent Column—Group members are show as proportions of a single column of fixed size.
  • Bar, which compares values displayed as bars. Three report options are available.
    • Column—Group members are shown as individual horizontal bars.
    • Stacked Column—Group members are show as portions of a single horizontal bar whose size reflects the aggregate value of the group.
    • Percent Column—Group members are show as proportions of a single horizontal bar of fixed size.
  • Line, which compares values displayed as points connected by lines. Two report options are available.
    • Line—Displays data points connected with straight lines.
    • Spline—Displays data points connected with a fitted curve.
  • Area, which compares values displayed as shaded areas. Two report options are available.
    • Line—Displays data points connected with a straight line and a color below the line. Groups members are displayed as transparent overlays.
    • Spline—Displays data points connected with a fitted curve and a color below the line. Groups members are displayed as transparent overlays.
  • Spider, which compares three or more values on a series of spokes. Spider charts can use columns, lines, or areas to display values.

By default, the selected data is shown in a column chart format. You can select a different type of chart at any time from the Chart Types window.

Exporting Data

You can export the content of any of the reports by clicking the export icon. You can export to PDF, CSV or paginated XLS.

Charts can only be exported to PDF format. The currently displayed chart type is exported to PDF. See Chart Type Selection for available chart types.

Zoom

You can use the zoom features to increase/decrease the report viewing area. The Cloud Cost Intelligence module's zoom features are separate from your browser zoom features.

It is highly recommended that you keep your browser zoom at 100% to avoid display issues.

Grouping and Filtering Your Data

You can use the various filtering options to define the scope of billing line items, on which to base your report, in all of the Cloud Cost Intelligence reports.

You can then save this set of options as a named report to view regularly, as data is collected and the reports are updated. You can create multiple filtered reports and save them for easy review.

A number of commonly used reports are provided in the Reports drop down menu. These reports are based on a filtered set of your billing data.

Once set, you need to save your filter selections and the resulting report as these settings are not retained when you exit the Cloud Cost Intelligence module. The selected group, period and date range are retained for each user session. i.e. if you log out and then return at some later date, these settings are saved. If another user accesses the Cloud Cost Intelligence module, their settings will be applied.

The options at the top of the console allow you to group your data:

Note: Only the timing granularity to view the data (View by) and the Period options are applicable to the Reserved Instance Utilization Report.

  • Show—Select how you want to view your cost data.
    • Amortized Cost—Amortizing is when you distribute one-time reservation costs across the billing period that is affected by that cost. That enables you to see your costs in accrual-based accounting as opposed to cash-based accounting. For example, if you pay $365 for an All Upfront RI for one year and you have a matching instance that uses that RI, that instance costs you $1 a day, amortized.
    • Blended Cost—AWS calculates blended costs as the BlendedRate multiplied by the UsageAmount of that service. The Blended rates are the averaged rates of the Reserved Instances and On-Demand Instances that are used by your accounts in an organization in AWS Organizations.
    • Unblended Cost—AWS calculates Unblended costs as the UnBlendedRate multiplied by the UsageAmount of that service. The uncombined rate for specific usage. For line items that have an RI discount applied to them, the UnblendedRate is zero. Line items with an RI discount have a UsageType of Discounted Usage.
    • Usage—The amount of usage that you incurred during the specified time period.
    • Normalized Usage—The amount of usage that you incurred, in normalized units, for size-flexible RIs. The NormalizedUsageAmount is equal to UsageAmount multiplied by NormalizationFactor. The normalization factor that is based on the instance size and a number of other factors.

    The above listed options are all AWS line items and are not unique to Densify or to the Cloud Cost Intelligence module. Refer to AWS Billing and Cost Management website for details of all the above options.

  • How to group the data—Select how you want to group your data. A group expression organizes your data based on a field or another value. See Filtering Billing Data below for a list of options.
  • The selection you make here is applied to all of the reports displayed in this console.

    When grouping by user-defined tags you must already have enabled tagging on your AWS billing data in order for the appropriate attributes to be set on the incoming billing data.

  • Timing granularity to view by—Your report can be based on daily, weekly, monthly, quarterly or yearly data. Your selection here, depends on how much data you have collected and your specific requirements.
  • All charges included in the billing period, regardless of actual charge date, are included on the time/date they are incurred. For example, if in November, the cost of AWS Support Service for the December is billed, then this cost is accounted for in November.

  • Period (date range) to include—A number of options are provided to define the date range to include in your reports.
  • By default, the date range is based on the last full period of collected data. This is the case for all time periods; however, in the case of the last quarter or year, it is based on the last full month of collected data. For example if you have selected to view your data by quarter and the last full month of data collected is March 2017, then the last quarter is Jan-Mar 2017. If you have selected to view your data by year, then the last year April 2016-Mar 2017 is displayed.

Grouping Billing Data

Filtering Billing Data

The filtering options on the left side of the console allow you to define a subset of data to review. You can then save your custom-filtered reports for later review.

When the filtering options are enabled, the filtering criteria are indicated in purple, so that you always have a clear indication that you are viewing a subset of data and what options are included in the displayed chart or table.

The following filters are available but not all filters are supported for both reports:

Table: Filtering\Grouping Options

Filter/Group/Tag

Description

Cloud Cost Navigator

RI Optimization

API Operation

Allows you to filter or group data by API operations you have performed. i.e. CreateOperation, RunInstances.

Yes

No

Charge Frequency

Allows you to filter or group data by billing frequency. i.e. hourly, daily.

Yes

No

Charge Type

Allows you to filter or group data by the type of charges included in your bill. i.e. usage, taxes, additional fees.

Yes

No

Instance Type

Allows you to filter or group data by instance type. Eg. The RI instance class, instance type, or node type, such as t2.micro, db.m4, or dc2.large.

No

Yes

Linked Accounts

Allows you to filter or group data by the linked account number or account alias.

Yes

Yes

Offering Class

Allows you to filter or group data by standard or convertible. Applicable to RIs only.

No

Yes

Payer Account

Allows you to filter or group data by the payer account number.

When there are multiple accounts, you can filter by the account name or number. The available options are based on how you configured the AWS IAM user account used for data collection.

For example, if you have a payer account for accounting purposes, you can filter on one or more of the accounts linked to the payer account. See Creating Connections from the Payer Account.

Yes

No

Platform

Allows you to filter by cloud platform. i.e. MariaDB, Red Hat Enterprise Linux (Amazon VPC},

No

Yes

Region

Allows you to filter or group data by the cloud region from which guests are hosted. The available options are determined by the selected cloud provider.

Yes

Yes

Service

Allows you to filter or group data by the type of service, such as storage, data transfer, elastic compute, etc. The available options are defined by the selected cloud provider.

Yes

No

Subscription

Allows you to filter or group data by the length of the subscription.

No

Yes

Usage Type

Allows you to filter or group data by the type of usage, such as LoadBalancer Usage, EBS: VolumeUsage.

Yes

No

Usage Unit

Allows you to filter or group data the type of usage unit, such as GB-Hrs.

Yes

No

Tags

You can filter or group by Application, Business Unit, Cost Center, Department, Owner or Project.

Yes

No

There are many ways to define your filters. The following sections provide a few examples:

Picking Items

Create a filter by selecting one or more items from one or more of the Filter or Tag menus. You can select one or more options in each of the input controls.

If no data is available for a specific filter selection box, the value "All" is used, so that if data becomes available in subsequent data collection, it will be included in these reports.

  1. Click Filters to expand the list of available filtering criteria. This list of filtering options corresponds to the grouping options. See above for descriptions.
  2. Select the option of interest and click to expand the input control. In the example, below 6 items have been selected out of the 189 available options.
  3. In the expanded input control, scroll through the list and click on the items you want to include in your report. You can select one or more items. In this example 6 items have been selected out of the 189 available options. These values are displayed on their respective tabs.
  4. Click Apply to see the results. The selected filtering criteria are applied, regardless of whether the Chart or Tabular view is selected.
  5. Click Save. Enter a descriptive name and click Save to close the dialog box and save your custom filter.

Searching and Picking Items

Create a filter by searching for a specific string and selecting one or more items from the returned list.

  1. Click Filters to expand the list of available filtering criteria.
  2. Select the option of interest and click to expand the input control.
  3. In the expanded input control, enter your text in the Search list . i.e. Create. In this example, only the API operations containing "create" are shown.
  4. There are a number of selection options:
    1. Click the first item in the list, then scroll down and Shift-click to select all the items containing the string "create".
    2. You can the click on individual items to de-select them from the filtering criteria.
    3. Click in the Search list again and delete the word "create". All items are displayed, but the items that included "create" remain selected. Click the Selected tab to see only the items that are selected.
    4. Click Invert to invert the selection. In this case, all items are selected except those items that contain "create".
    5. Click Apply at the bottom of the panel. The report shows data for API Operations that do not contain the word "create".
  5. Click Save. Enter a descriptive name and click Save to close the dialog box and save your custom filter.

You can use this same process to select criteria in each of the filter and tag input controls.

You can save your customized filter and then continue to edit it or save versions of the filter as required.

If the result set is empty, check for an incompatible combination of filters and input controls, or an incorrectly-defined advanced filter expression (data must meet all criteria in multiple filters, rather than meeting criteria in a subset of those filters).

Filter Breadcrumbs

The breadcrumbs show you the details of the filters that have been applied to the displayed report. Each applied filter and its settings are shown at the top of the report.

  • One item—If a filter has been selected and only one of the filtering criteria has been applied, that filter name and current setting are displayed.
  • Two items—If a filter has been selected and two setting have been applied, both settings are listed. The resulting data set contains one or the other of the applied settings.
  • Three or more items—If a filter has been selected and 3 or more of the filtering criteria has been applied, the number of criteria pllied is dsplayed.

Reserved Instance Utilization Report

Open this report from the Cloud Cost Intelligence drop down menu:

This report shows you the percentage utilization of your reserved instances (RIs). The bars show you the percentage utilization of your purchased RIs. The line across the top indicates 100% utilization. This report shows you how effectively you are using your RIs.

You can filter the scope of systems on which the report is based, using the filtering options on the left side of the page. See Filtering Billing Data, above for details on selecting and applying filters.

Pre-Defined Reports Tab

The Reports drop down allows you view a number of reports with option set already created and saved. The data set is not filtered. Adjust the filtering criteria as required.

There are View By and Period selectors specific to set for these reports that can be adjusted for your use case. You can also adjust the filtering criteria as required. You can then save your report with a new name.

The following reports are available from this menu:

Table: Pre-Defined Reports for Cost Navigator

Report Name

Description

Show (Metric)

Group By

Period

Costs by Account (Daily - MTD)

Unblended Costs grouped by Linked Account shown for each day of the previous month.

Unblended Cost

Linked Account

Previous Month to Date

Costs by Account (Monthly)

Unblended Costs grouped by Linked Account showing month over month spend. The last 5 months and month-to-date for the current month are displayed.

Unblended Cost

Linked Account

Previous 6 Months

Costs by Account (Quarterly)

Unblended Costs grouped by Linked Account showing quarter over quarter spend. The last 4 completed quarters are displayed.

Unblended Cost

Linked Account

Previous 4 Quarters

Costs by Account (Yearly)

Unblended Costs grouped by Linked Account showing year over year spend. All available data is displayed with year-to-date shown for the current year.

Unblended Cost

Linked Account

Previous 2 Years

Costs by Charge Type (Daily)

Unblended Costs grouped by Charge Type shown for each day of the previous month.

Unblended Cost

Charge Type

Previous Month to Date

Costs by Charge Type (Monthly)

Unblended Costs grouped by Charge Type showing month over month spend. The last 5 months and month-to-date for the current month are displayed.

Unblended Cost

Charge Type

Previous 6 Months

Costs by Charge Type (Quarterly)

Unblended Costs grouped by Charge Type showing quarter over quarter spend. The last 4 completed quarters are displayed.

Unblended Cost

Charge Type

Previous 4 Quarters

Costs by Charge Type (Yearly)

Unblended Costs grouped by Charge Type showing year over year spend. All available data is displayed with year-to-date shown for the current year.

Unblended Cost

Charge Type

Previous 2 Years

Costs by Service (Daily - MTD)

Unblended Costs grouped by Service shown for each day of the previous month.

Unblended Cost

Service

Month to Date

Costs by Service(Monthly)

Unblended Costs grouped by Service showing month over month spend. The last 5 months and month-to-date for the current month are displayed.

Unblended Cost

Service

Previous 6 Months

Costs by Service(Quarterly)

Unblended Costs grouped by Service showing quarter over quarter spend. The last 4 completed quarters are displayed.

Unblended Cost

Service

Previous 4 Quarters

Costs by Service (Yearly)

Unblended Costs grouped by Service showing year over year spend. All available data is displayed with year-to-date shown for the current year.

Unblended Cost

Service

Previous 2 Years

Table: Pre-Defined Reports for Reserved Instance Utilization

Report Name

Description

Group By

Period

EC2 RI Utilization (Daily)

Percentage of your EC2 Reserved instances that are used daily.

Services=AmazonEC2

Previous Month to Date

EC2 RI Utilization (Monthly)

Percentage of your EC2 Reserved instances that are used monthly.

Services=AmazonEC2

Previous Month

RDS RI Utilization (Daily)

Percentage of your RDS Reserved instances that are used daily.

Services=AmazonRDS

Last 7 Days

RDS RI Utilization (Monthly)

Percentage of your RDS Reserved instances that are used monthly

Services=AmazonRDS

Previous 12 Months