Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Table of Contents

Info

This document describes how to configure Amazon billing data for standard accounts and resellers with partner accounts. For standard accounts see Display Amazon billing data for standard accounts.

Changes to AWS billing

...

The following changes apply to AWS billing:

  • In Abiquo 6.

...

  • 1.0

...

  • Before you upgrade, add the amazon_bucket_region as an enterprise property. The value is the code for the AWS region where your billing bucket is located (for example, us-east-1)

Abiquo 6.1.0

...

  • +, replace the price_factor enterprise property

...

  • with the Abiquo price

...

By default, the platform will process all items in the CSV file, so the partner discount (SppDiscount) value can be visible on customer dashboards. To discard items from the CSV file, on the Remote Services server, edit the abiquo.properties file and add the following property with any items to discard. 

Code Block
abiquo.ec2billing.lineItemType.ignore=SppDiscount

...

Configure properties

To configure Abiquo properties for AWS billing

By default, the platform will retrieve billing data for the last two months. To change this value, on the Abiquo Server, edit the abiquo.properties file and add the following property with the number of months to retrieve:

Code Block
abiquo.enterprise.property.billing.monthoffset=2

...

Configure AWS to supply billing data

To configure AWS to supply billing data for standard or reseller accounts, do the following steps.

  1. Create an S3 bucket, for example, "costandusagebillingreport"

    1. Within the bucket, create a folder where AWS will store your reports. Give it the name of your report, for example "costandusagebillingreport"

    2. Note the billing bucket name, for example, "costandusagebillingreport"

  2. Create a new user, such as "programmaticbilling" to create the reports

    1. Assign the AmazonS3ReadOnlyAccess the AmazonS3ReadOnlyAccess policy

    2. Activate the IAM user's access to billing information. See https://docs.aws.amazon.com/awsaccountbilling/latest/aboutv2/control-access-billing.html

    Optionally configure legacy billing reports

    1. Go to Billing → Billing preferences

    2. Open the Detailed Billing Reports [Legacy] section

    3. Select the option to Turn on the legacy Detailed Billing Reports feature to receive ongoing reports of your AWS chargesClick

  3. Configure

     and enter your S3 bucket details

    Select all of the available reports including

  4. Monthly report

  5. Detailed billing report

  6. Cost

    allocation report
  7. Detailed billing report with resources and tags

  8. Click Save preferences

  9. Configure Cost & Usage Reports

    1. Go to Cost & Usage Reports

    2. Enter the Report  name, which you will need and note the value to enter in Abiquo later, then click Next

    3. Click Configure and select the S3 bucket. Click Next, then select I have confirmed that this policy is correct.

    4. By default, Amazon will put the reports in a folder with the name format "/report-name/date-range/". Note this as the value for the report amazon_bucket_prefix in Abiquo. Click Next

    5. Review your configuration and check that the following parameters are set: 

      1. bucket name

      2. path (folder/subfolder)

      3. time detail: Hourly

      4. GZIP GZ or ZIP format

  10. The AWS account with credentials to use in Abiquo should have the permissions in the AWS permissions table below.

AWS permissions table

...

Type

...

Privileges

...

Resources

...

Price list

...

Full access

...

All resources

...

S3

...

Full: list, read

...

Multiple

...

  1. be an account with pricing and billing permissions.

    1. For partner accounts, see https://abiquo.atlassian.net/wiki/spaces/doc/pages/311370749/Obtain+AWS+credentials#Reseller-pricing-and-billing-credentials

    2. For standard accounts, see https://abiquo.atlassian.net/wiki/spaces/doc/pages/311370749/Obtain+AWS+credentials#Standard-account-pricing-and-billing-policy

...

Configure dashboard display in Abiquo

To configure billing dashboards in Abiquo for resellers, do these steps .

...

The Abiquo users should have the privileges to Display hybrid dashboard tab, View bills, and optionally to Display VM cost view widget (hybrid tab)

...

in Abiquo.

  1. Edit the enterprise and create the following enterprise properties in the AWS enterprise properties for resellers table below

AWS enterprise properties for resellers table

...

Property

...

  1. :

    1. amazon_bucket

...

Name of the S3 bucket where Amazon stores billing data.
(warning) Change value for v5.2.0. This was previously reseller ID in the yaml configuration file.

    1. : bucket_name

    2. amazon_bucket_region

...

    1. : code for the AWS region

...

    1. of the bucket

...

    1. , such asus-east-1

...

    1. amazon_report_name

...

    1. : amazon_bucket/amazon_bucket_prefix/amazon_report_name/file.csv

    2. amazon_bucket_prefix

...

    1. : amazon_bucket/ amazon_bucket_prefix /amazon_report_name/file.csv

    2. amazon_billing_compress_format

...

Compression format of the billing report file: ZIP or GZIP

...

amazon_price_factor

...

    1. : ZIP or GZ

    2. amazon_mpa

...

    1. : set to

...

    1. dedicated

...

    1. or

...

    1. no

...

    1. to use blended costs

...

    1. ; if not present or

...

    1. shared

...

    1. , use unblended costs

...

Additional configuration for resellers

This section describes additional configuration for reseller accounts.

  1. Create an additional enterprise property for resellers:

    1. amazon_discount

...

    1. : as agreed with Amazon, usually with a value such as 0.03, 0.02

...

_

Configure reseller customers in Abiquo

To configure billing dashboards in Abiquo for customers of resellers, create a price factor for the reseller. Optionally, create and apply price factors for customers.

...

  1. In Pricing view, create price factors as required for the reseller, the customers, and for a percentage of managed costs. See Manage price factors

  2. For your customer enterprises, add credentials for compute and/or billing

  3. Assign the privilege to View bills to user roles

  4. Optionally, configure Abiquo properties

    1. By default, the platform will retrieve billing data for the last two months. To change this value, on the Abiquo Server, set the following property

      abiquo.enterprise.property.billing.monthoffset=2

    2. By default, the platform will process all items in the CSV file, so the partner discount (SppDiscount) value can be visible on customer dashboards. To discard items from the CSV file, on the Remote Services server, set the following property with a list of codes of any items to discard.

      abiquo.ec2billing.parser.lineItemType.ignore=SppDiscount