Upgrade billing dashboards

In Abiquo 5.2.0 the dashboard billing scripts have been integrated into the main platform. You will need to work on these upgrade steps at different stages of the Abiquo upgrade process.

Disable old dashboard scripts before the upgrade

In Abiquo 5.2, the billing dashboard feature has moved to the core Abiquo platform.

If you are using the billing dashboard scripts from previous versions, disable them before you continue with the upgrade.

Remove the cron jobs to run the billing scripts.

# rm /etc/cron.d/abiquo-billing-ec2
# rm /etc/cron.d/abiquo-billing-arm

Remove last bills

Delete the last bills from the previous version of the billing dashboards (from the billing_consolidation and billing_register tables).

Remove the bills for Azure and Amazon providers, for the number of months covered by the abiquo.enterprise.property.billing.monthoffset property, which has a default value of 2 months.

Later the new billing dashboard feature will regenerate these bills.

Add new billing providers such as Google Cloud Platform

To configure the billing dashboard for the Google Cloud Platform, see Display Google Cloud Platform billing data.

For full configuration of each provider dashboard, see the pages under: Display cloud provider billing data

Configure defaults with properties

As part of the upgrade process do these steps.

To configure the frequency and amount of data that Abiquo will obtain from the cloud provider

On the API server, edit the abiquo.properties file and change these properties as required:
- To change how often the platform will obtain billing data, enter a cron expression. The default expression is as follows.
```
abiquo.billing.task.cron = 0 30 0 ? * * *
```
  - If the cron expression is not compatible with Quartz, the platform will use the default.
  - This tool generates valid expressions: https://www.freeformatter.com/cron-expression-generator-quartz.html. Some other commonly used tools may generate invalid expressions.
- To configure the number of months to obtain billing data for, enter an integer months offset. The default is to get data for 2 months, but it might be interesting to go back for 6 months at least:
```
abiquo.enterprise.property.billing.monthoffset=6
```
Optionally, set the default country code for billing. On the Remote Services server, edit the abiquo.properties file and set the country_code property.
```
abiquo.billing.azure.country_code=US
```

You can also override this value in your cloud tenants with an enterprise property as required.

Check and change enterprise properties

The upgrade will automatically rename this enterprise property and you must change it for resellers

Provider	Property name	Note	Description
AWS	amazon_bucket	Replaces billing_bucket Changed value for resellers	Name of the S3 bucket where Amazon stores billing data. After the upgrade, for resellers, add the AWS billing bucket name. Note that you can copy this from the old configuration files.

The upgrade will rename the following enterprise properties as described in the Note column.
And you MUST now add them for all Azure subscriptions (they previously may have only been for standard or reseller accounts)

Provider	Property name	Note	Description
Azure	azurecompute-arm_currency_code	Replaces Currency	Required for all Azure accounts Three character currency code of the bill. Default is USD WARNING! Different from currency_code used for conversion factor
Azure	billing.azure.country_code	Replaces RegionInfo	Two character country code of the bill. Use to override the default set with abiquo.properties Add to reseller accounts
Azure	azurecompute-arm_discount	No change	Required for all Azure accounts Provider discount value Add to standard accounts Can be set to 0 for standard accounts

The upgrade will automatically rename the following enterprise properties and you shouldn't need to make any changes to them.

Provider	Property name	Note	Description
AWS	amazon_report_name	Replaces report_name	Part of the path: amazon_bucket/amazon_bucket_prefix/amazon_report_name/file.csv
AWS	amazon_bucket_prefix	Replaces report_prefix	Part of the path: amazon_bucket/amazon_bucket_prefix/amazon_report_name/file.csv

Add the following NEW enterprise properties as part of the upgrade process.

Provider	Property name	Description
AWS	amazon_billing_compress_format	For all Amazon accounts. Compression format for the billing reports. Values can be "ZIP" or "GZIP"
Azure	azurecompute-arm_only_bill_subscription	Only for enterprises with Azure plans under CSP subscriptions; NOT for resellers. Use it for enterprises that belong to a tenant with multiple subscriptions, to compute the cost of the usage of the subscription only. If the enterprise doesn’t have the property, it will compute usage + product cost
Google	dataset_id	For all account types. The ID of the big query dataset where Google will store the billing data

Remove the following enterprise properties that are deprecated as part of the upgrade
Provider Property name Description
Azure OfferDurableID Previously for CSP accounts, this was the ID of the customer in the configuration file
To enable the platform to access the billing data in the provider.
1. For each provider obtain pricing credentials. See Obtain public cloud credentials
2. Edit the Enterprise and go to Credentials → Pricing
3. Add Pricing credentials.
4. Note: When you add Pricing credentials to an enterprise with a pricing model, this will also activate price list synchronization to onboard hardware profile prices from Amazon and Azure.
  See Import hardware profile prices
Remove the old billing dashboard modules and their configuration files. See /wiki/spaces/doc/pages/311371999

Troubleshooting enterprise properties

You can check your enterprise properties against the lists on these pages: