Creating & Uploading a new Pricing Profile

Follow the steps to upload a new Pricing Profile:

1. Download the Azure Stack Meters.xlsx file

2. Fill the sheet with required values (to be filled by Client)

3. Ensure the file should have Sheet1 only. Remove the sheet 2, sheet 3 etc.,

4. Save the file (the location should be as billing.exe)

5. Open Windows PowerShell as Administrator

6. Execute the cmdlet ‘.\Billing.exe CreateAzureStackPricingJson’

    a. It will list the excel files available in the Billing tool location

    b. Enter the file of Pricing Profile to convert as JSON one (don’t give .xlsx)

7. New Azure Stack Profile will be created in the same location:

8. To Upload the newly created pricing profile. Navigate to Azure Stack Admin Portal --> Billing --> Pricing Profile

9. Login to Billing RP VM --> IIS Manager --> Sites --> Edit the values of Configuration Editor (of Azure Stack – BillingAdminExtension & BillingRP). Give 8-digit value for uploadReadAheadSize (eg. 10485760)

 

10. Restart the Billing Agent Service

11. Apply the Pricing profile for required subscriptions

Note: Install OLEDB prior to performing the above steps

• Related Articles

• Different Type of Credits available in Cloud Assert Usage and Billing Solution

    TYPES OF CREDITS IN BILLING SOLUTION Billing solution for Microsoft Azure Stack allows the administrator to set credits for the tenants. There are five types of credits, they are as follows: Recurring Credit  One-Time Credit User Credit Unit Credit ...

• Solution for Certificate Expiry - Azure Stack

  Log into Billing RP VM (BillingVM1000). Replace '<Fill the output path>' in the below script with required path where the certificate will be generated. $DisplayName = 'BillingCert' $OutputCertPath = '<Fill the output path>\BillingCert.pfx' ...

• Use of Filter Properties and Resource Conditions while setting Metered Resource Pricing in Cloud Assert Billing Solution

  Resource Condition Resource condition is given to set different prices for the same metered resource based on the volume of raw usage units. This can be done by cloning a configured metered resource and setting a new monthly unit price for it. ...

• Error creating VM. Operation 'CreateVM DeployFromTemplateOp' failed. Exception: No space available in datastore 'Name of the Datastore'. Free space required: XX GB

  Root Cause: By default, VConnect would take certain amount (say 100 GB) of space for creating a VM. To change this, search for the value of 'IsSelectDataStoreUsingRealFreeSpace' in the 'AppSettings' Table,  it would be set as 'True' (by default), ...

• Use of Formula while setting Metered Resource pricing in Cloud Assert Usage and Billing Solution

  Use of Formula Formula are used to modify the units obtained from the raw usage data of resources before computing the price for the resource. There are two types of formula ‘Unit Formula’ and ‘Custom Formula’. i.            Unit Formula It ...