| 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)
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 |
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 |
...
+, replace the
price_factorenterprise property with the Abiquo price factors for Amazon. See Manage price factorsIn Abiquo 6.1.2+, you can also add a managed costs using a price factor. See Manage price factors
...
Configure AWS to supply billing data
To configure AWS to supply billing data for standard or reseller accounts, do the following steps.
Create an S3 bucket, for example,
...
costandusagebillingreport
...
Within the bucket, create a folder where AWS will store your reports. Give it the name of your report, for example
...
costandusagebillingreport
...
Note the billing bucket name, for example,
...
costandusagebillingreport
...
Create a new user, such as
...
programmaticbilling
...
to create the reports
Assign
...
the
AmazonS3ReadOnlyAccesspolicyActivate 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
...
Go to Billing → Billing preferences
...
Open the Detailed Billing Reports [Legacy] section
...
Select the option to Turn on the legacy Detailed Billing Reports feature to receive ongoing reports of your AWS charges
...
Click Configure and enter your S3 bucket details
Select all of the available reports including
...
Monthly report
...
Detailed billing report
...
...
Detailed billing report with resources and tags
...
Click Save preferences
Configure Cost & Usage Reports
Go to Cost & Usage Reports
Enter the Report name,
...
and note the value to enter in Abiquo later, then click Next
Click Configure and select the S3 bucket. Click Next, then select I have confirmed that this policy is correct.
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
...
amazon_bucket_prefixin Abiquo. Click NextReview your configuration and check that the following parameters are set:
bucket name
path (folder/subfolder)
time detail:
Hourly
...
GZ or ZIP format
The AWS account with credentials to use in Abiquo should
...
AWS permissions table
...
Type
...
Privileges
...
Resources
...
Price list
...
Full access
...
All resources
...
S3
...
Full: list, read
...
Multiple
...
be an account with pricing and billing permissions.
For partner accounts, see https://abiquo.atlassian.net/wiki/spaces/doc/pages/311370749/Obtain+AWS+credentials#Reseller-pricing-and-billing-credentials
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 in Abiquo.
...
The Abiquo users should have the privileges to Display hybrid dashboard tab, View bills, and optionally to Display VM cost view widget (hybrid tab)
...
Edit the enterprise and create the
...
AWS enterprise properties for resellers table
...
Property
...
Description
...
Previous name
...
following enterprise properties:
amazon_bucket
...
Name of the S3 bucket where Amazon stores billing data.
Change value for v5.2.0. This was previously reseller ID in the yaml configuration file.
...
billing_bucket
...
Enter the new value
: bucket_name
amazon_bucket_region
...
: code for the AWS region
...
of the bucket
...
, such as
us-east-1
...
...
amazon_report_name
...
: amazon_bucket/amazon_bucket_prefix/amazon_report_name/file.csv
...
report_name
...
amazon_bucket_prefix
...
: amazon_bucket/ amazon_bucket_prefix /amazon_report_name/file.csv
...
report_prefix
...
amazon_billing_compress_
...
format
...
:
ZIPor
...
GZamazon
...
_
...
Default provider markup for customer enterprises with no value
...
...
-
...
amazon_mpa
...
mpa: set to
dedicatedornoto use blended costs
...
; if not present or
...
shared
...
, use unblended costs
...
...
...
Additional configuration for resellers
This section describes additional configuration for reseller accounts.
Create an additional enterprise property for resellers:
amazon_discount
...
: 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
In Abiquo, edit the enterprises of the customers of the reseller and create the enterprise property (amazon_price_factor) in the AWS enterprise properties for customers of resellers table.
You can also set the default value of this property in the reseller.
AWS enterprise properties for customers of resellers table
...
Property
...
Description
...
Previous name
...
Migration for v5.2.0
...
amazon_price_factor
...
Markup or discount applied by the partner to their customer.
The default value is 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
For your customer enterprises, add credentials for compute and/or billing
Assign the privilege to
View billsto user rolesOptionally, configure Abiquo properties
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=2By 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