Abiquo Documentation Cookies Policy

Our Documentation website uses cookies to improve your experience. Please visit our Cookie Policy page for more information about cookies and how we use them.


Documentation

Skip to end of metadata
Go to start of metadata

"Changes to Resource Consumption and Cost Report in Abiquo 3.10"

In Abiquo 3.10+ this report now uses pricing per datacenter from the enterprise pricing model.

We will update the documentation for this report shortly  

 

This report is used to show the resources consumed by an Enterprise, and their associated costs. By clicking on the relevant name in the report, it is possible to drill-through to breakdown an individual Enterprise’s resource usage to Virtual Datacenter, Virtual Appliance, and Virtual Machine granularity, showing the cost breakdowns for each.
This report uses the Abiquo accounting data to determine resource usage. And it uses the Enterprise's Abiquo pricing template to calculate the costs. The result is always in hours.

 

Input Parameters
ParameterDescriptionNotes
Start DateThe beginning of the date range for the reportDefault start date is the first day of the previous month
End DateThe end of the report date range for the report. The report uses data for all the days up to but not including this dateDefault end date is the first day of the current month
Report Content

The report is tabular in format, giving a breakdown of the resource usage and cost in pairs of columns for each resource type, with appropriate totals for combined resources. The following is a breakdown of the resources included in the report, and a description of their consumed units:

ResourceDescription
CPUThe number of VM CPUs, per hour. For example, a 1 CPU VM running for a whole day will consume 24 CPU units
MemoryThe amount of Memory consumed by VMs, in GB per hour. For example, a VM with 4GB of RAM running for a whole day will consume 96 RAM resources
External StorageThe amount of external (Network attached) volume storage allocated, in GB per hour. Note that External Storage is charged for even when it is not in use by any VM. For example, a 10GB external volume will consume 240 External Storage units in 24 hours.
VLANThe number of ‘Internal/Private’ VLANs being used, per hour. For example, a VDC with a single VLAN will consume 24 VLAN units in one day
Public IPThe number of Public IP addresses allocated, per hour. Note that Public IPs are charged for even when it is not in use by any VM
Images

The number of Abiquo Apps Library virtual machine templates (or images) being used by VMs, per hour. Note that the cost for Apps Library templates varies, and is dependent on the Cost Code associated with the template and its corresponding cost in an Abiquo pricing template. For example, a VM using a template from the Apps Library will consume 24 units if running for the whole day, but the cost of those units will depend on the template’s Cost Code

Calculations

The Report columns are calculated as follows:

  • Consume = Report hours * Accounting usage * Accounting granularity hours conversion factor 
  • Cost = Consume * Pricing cost / Pricing hours conversion factor

Accounting granularity hours conversion factorConverts accounting granularity to hours, e.g. if accounting granularity is month, it is 30 * 24. See Calculation notes below

Pricing hours conversion factor: Converts pricing charging period to hours. The minimum charging period is day. The same ratios are used as in the Accounting granuliarty hours conversion factor.

For example we will calculate the CPU Consume and CPU Cost in the following report.

During the 24 hour period of the report, the enterprise Abiquo used 40 CPUs and the accounting period granularity is HOUR, so to calculate the Consume, we use:

Report hours * Accounting usage * Accounting period granularity hours conversion factor = Consume

    24       *        40        *                         1                             = 960

The following pricing model is assigned to the enterprise Abiquo.

The CPU is charged at 0.0027 USD and the charging period is Day. Therefore the Cost is calculated as:

Consume x Pricing cost / Pricing hours conversion factor = Cost

  960   x    0.0027    /               24                = 0.0108

In the report, this value is rounded to 2 decimal places, i.e. 0.11.

The Pricing hours conversion factor is the same as the Accounting period granularity hours conversion factor. See Calculation notes below.

Calculation notes

To find the Accounting granularity of your system you can use the following MySQL query:

MariaDB [kinton_accounting]> select * from ACCOUNTING_CONFIG_VW;
+--------------------+-------------+--------------------+ ...
| ACCOUNTING_ENABLED | PERIOD_SIZE | PERIOD_GRANULARITY | ...
+--------------------+-------------+--------------------+
|                  1 | DAY         | HOUR               | ...
+--------------------+-------------+--------------------+ ...
1 row in set (0.00 sec)

The Accounting period granularity hours conversion factor is:

Accounting PeriodAccounting period granularity hours conversion factor
HOUR1
DAY

24

WEEK7 * 24
MONTH30 * 24

 

PDF Sample Report

This sample report contains the first five pages and the last totals page of a longer report.

  • No labels