Display Amazon billing data

Changes to AWS billing

Configure properties

To configure Abiquo properties for AWS billing.

1. 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:

   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, edit the abiquo.properties file and add the following property with the code of any items to discard. For example:

   abiquo.ec2billing.parser.lineItemType.ignore=SppDiscount

Configure AWS

To configure AWS to supply billing data, 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 policy

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

3. Configure Cost & Usage Reports

   1. Go to Cost & Usage Reports

   2. Enter the Report  name, which you will need 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 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. GZ or ZIP format

4. The AWS account with credentials to use in Abiquo should be a partner account with pricing and billing permissions. See https://abiquo.atlassian.net/wiki/spaces/doc/pages/311370749/Obtain+AWS+credentials#Reseller-pricing-and-billing-credentials

Configure dashboard display in Abiquo

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

1. Assign the privilege to View bills to your user roles

2. Edit the reseller enterprise and create the following enterprise properties:

   1. amazon_bucket: bucket_name

   2. amazon_bucket_region: code for the AWS region of the bucket, such as us-east-1

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

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

   5. amazon_billing_compress_format: ZIP or GZ

   6. amazon_mpa: set to dedicated or no to use blended costs; if not present or shared, use unblended costs

   7. amazon_discount: as agreed with Amazon, such as 0.03, 0.02

3. In Pricing view, create price factors for the reseller. You can also create and apply price factors for customers, as well as managed costs. See Manage price factors