Manage price factors

This page describes how to create price factors to set markups and discounts for cloud providers and private cloud.
To remove a discount applied for a reseller to bill a cloud tenant, e.g., in Azure, use the enterprise property for the provider discount. See Display Azure billing data

You can assign price factors by enterprise, by reseller and customers, or by provider. For Azure and AWS you can also create more specific price factors.

By default, no price factors apply and that is the same as adding a price factor of 1.

To add a markup of 10%, enter a price factor with a value of 1.1.

To exclude an item from billing, add a price factor with a value of 0 using the API

Privileges: View price factors, Manage price factors

View price factors

To view price factors:

Log in with a user that has the same scope as the creator of the price factors
Go to Pricing → Price factors

Create a price factor

To create a price factor:

Go to Pricing → Price factors
On the providers list, click + add
Select the Provider. For private cloud, the provider is ONPREMISE
For Azure and AWS, you can also select the Bill type and Product ID
For Enterprise associations, select the type of association, which can be All, Reseller, or Key node. For reseller pricing, you would usually set the base price of the reseller first.
For Reseller or Key node, select the Enterprise
For the Enterprise association, enter the Value, which is the markup or discount.
- For example, to use a markup of 10%, enter 1.1 and to add a discount of 10%, enter 0.9.
- To exclude a product, you can set a value of 0 using the API.
Click Add.
Select and add more enterprise associations as required. (You can also edit the price factor later to add more then.)
Click Save

When you create a price factor, the platform will assign your user scope to it, and only users with the same scope will be able to view and manage the price factor.

Azure price factor types table

For Azure, you can apply more specific price factors to apply to different resources at bill type and product level.

Azure price factor type	Applies to
azurecompute-arm_price_factor	All resources
azurecompute-arm_price_factor.bill_type	Resources of the specific category
azurecompute-arm_price_factor.bill_type.productId	Resources of the specific category and product ID

Azure bill types table

Azure bill type	Description
License based services	Products from the view “OnliceServices” with product type “OnlineServicesNCE”. Only the new commerce ones from the CSP license based services pricing sheet. (https://docs.microsoft.com/en-us/partner-center/develop/get-a-list-of-products#rest-request )
Marketplace	All the products for which the publisher is different from Microsoft or Microsoft Corporation
Azure plan	Entries retrieved by usage line items
Reserved instances	Products from target view “AzureReservations”
Software	Products from target view “Software”
Managed	Managed will be an extra line that consists of X percent of total Azure plan cost (used to define the factor to be applied to Azure plan costs to calculate the managed cost).

AWS bill types table

AWS has the following bill types as explained in their documentation for bill/BillType.
Reference: https://docs.aws.amazon.com/cur/latest/userguide/billing-columns.html#billing-details-B

Bill type	Description
Anniversary	Line items for services that you used during the month
Purchase	Line items for upfront service fees
Refund	Line items for refunds

AWS product names

AWS has many product names. Here are some examples given in their documentation for product/ProductName

Reference: https://docs.aws.amazon.com/cur/latest/userguide/product-columns.html#product-details-P

AWS Backup, AWS Config, Amazon Registrar, Amazon Elastic File System, Amazon Elastic Compute Cloud, AWS Marketplace

Ignore AWS billing entries

AWS billing files contain charges and refunds. Abiquo lets you ignore billing items, which is helpful for excluding refunds from billing data.

To ignore billing entries with specific billtype and product name:

Log in to Abiquo server as administrator
Go to the /opt/abiquo/config/ folder
Create a file with an appropriate name, such as aws-refund-product-ignore.csv
Enter a list of bill types and product names separated by a colon, for example:
Refund:AWS Premium Support
Refund:EC2 Reserved Instances
Edit the abiquo.properties file

Set the abiquo property with the file location, for example:

abiquo.ec2billing.parser.billType.productName.ignore.path=/opt/abiquo/config/aws-refund-product-ignore.csv