Cloud Usage Data

The Cloud Usage Data screen allows you to upload and manage your monthly cloud consumption data. This screen displays monthly cloud usage data for the selected year and month. The cloud usage upload feature lets you to manually add your monthly cloud usage data by uploading cloud files provided by your cloud service providers.

Supported Cloud Platforms

The Cloud Usage Upload feature supports uploading usage data in CSV format for the following cloud providers:

• Azure

• AWS_v2

• AWS_legacy

• FOCUS

Key Benefits

The cloud consumption data is used to generate detailed reports and dashboards that offer insights into your cloud spend, cloud services, cloud resources, usage patterns, and potential cost-saving opportunities.

Mandatory fields

To successfully upload cloud usage data, each CSV file must include specific mandatory fields for each cloud provider. These fields ensure that the system can correctly process and allocate your usage data. Below are the mandatory fields for each supported provider:

How to Upload

1. Prepare Your File

   1. Ensure the file is in the CSV or XLSX format for the upload.

   2. Verify that the file includes all the mandatory fields.

2. Navigate to the Consumption Data screen

   1. Go to Admin > Yarken Designer.

   2. Under the upload section expand Consumption and select Cloud.

3. Select your cloud provider file type

   1. Click ellipsis (…) menu icon and select Add Usage Data option.

   2. Select the desired file type.

4. Upload and map the fields

   1. Drag or drop your file into the upload popup, or click browse.

   2. Map the fields and click NEXT.

5. Choose the date format for cloud spend

   • Select the Date Format that matches your file's date columns.

   • Click FINISH.

Upload Errors and Troubleshooting

If the upload fails, you will see an error message with specific details on the Data Upload Error popup. Below are some common upload errors and how to address them:

• Invalid data values - Check negative costs, or decimal separator.

• Incorrect date format - This error occurs when the date format in the file does not match with the date format defined during mapping. To resolve this:

  • Verify the date format in your file.

  • Re-upload the file and select the different date format similar to your file’s date format

  • Make sure that all the date columns should be uniform date format.

View Uploaded Data

After successful upload, navigate to the Cloud Usage Data screen and refer the donut chart of any month. The monthly tiles indicates the total cloud spend value and donut chart shows the proportional breakdown of cloud spend by individual provider.

View Uploaded Files

You can view the uploaded files from the (…) menu icon on the monthly tiles. All the uploaded files for a month are available under the UPLOADED FILES tab. From this tab, you can download, reload, automate, or delete the uploaded files. You can also view the total loaded records, the mapping field, and errors encountered during upload.

Upload Rules for Cloud Consumption Data

For cloud consumption uploads (Azure, AWS, FOCUS), the Account, Cost Center, and Vendor fields must be populated using Upload Rules. These fields are no longer available for selection during the manual upload process.

Key points:

• Cloud spend cannot be published unless Account, Cost Center, and Vendor are assigned via Upload Rules.

• Define Upload Rules for the cloud consumption source table to automatically populate these fields during file upload.

• If you have already uploaded cloud data without these rules, you may delete the existing file, define the Upload Rules, and reload the file to apply the rules.

• For any cloud data intended for AI financial tracking, the AI Service field should be considered a standard mapping requirement and must be populated using upload rules. Mapping spend to the AI Service field allows for automatic population of AI attributes in the Cloud asset type during the publish process.

For step-by-step instructions on creating Upload Rules, refer to Manage Upload Rules.

Manage Cloud Spend

The Manage Cloud Spend allows you to view the total cloud spend distribution across Providers, Account, Cost Center, Vendor, Cloud Asset, and Cloud Team. You can publish your cloud spend to the Cost Transparency model and Forecasting feature.

What is Cloud Spend Publish?

Cloud spend publishing is the process of transferring monthly cloud spend data to Cost Transparency model for analysis and reporting. It also pushes the spend data to the forecasting feature, which compares the actual and forecasted spend for a given month.

Publishing the cloud spend provides the visibility into cloud costs and their distribution across providers, accounts, cost centers, vendors, and cloud assets.

Before publishing

• Ensure Account, Cost Center, and Vendor are populated. These fields are required for Cloud publishing.

• Review Cloud Asset Name if you want spend associated with specific named Cloud assets.

• Populate AI Service before publishing Cloud spend to an AI Model.

Cloud publishing behavior

When you publish Cloud spend, Yarken creates corresponding records in the selected Spend model and retains supported Cloud context for downstream allocation, reporting, and analysis.

The publishing result depends on the source Cloud data and the publishing level you select.

Published Expenses

When Cloud spend is published to Expenses, Yarken creates corresponding Expense records for the selected month.

Published Cloud records:

• are identified with Source = Cloud,

• retain supported financial and Cloud attributes that are populated before publishing, and

• can use those attributes in supported downstream workflows such as Analytics and allocation rules.

Depending on the source data, published Expenses can include attributes such as Entity, Account, Cost Center, Vendor, Provider, Asset, AI Service, Team, and other supported Expenses attributes.

Cloud Asset creation

When the source Cloud spend includes a Cloud Asset Name, Yarken creates or associates the corresponding record under Designer > Assets > Cloud during publishing.

The Cloud Asset record includes identifying information such as:

• Cloud Asset ID

• Cloud Asset Name

Other populated Cloud Asset attributes can also be available on the asset record, including Hosting Platform and AI Service.

The published Expense record uses the corresponding Cloud Asset in the Asset field.

Unknown Cloud Asset during publishing

If Cloud Consumption records do not have a Cloud Asset, Yarken keeps that spend separate when you publish Cloud Spend.

During publishing, Yarken:

• creates one Cloud asset named Unknown for the selected year and month,

• assigns all records with a blank Cloud Asset Name to that Unknown asset,

• keeps the associated spend with the Unknown asset instead of distributing it across named Cloud assets,

• includes the Unknown asset in the Cloud Summary asset count and spend total, and

• publishes the corresponding records to Expenses with Unknown in the Asset field.

Named Cloud assets continue to use their existing asset names and publishing behavior.

Choose the distribution levels

When publishing cloud spend, the available distribution levels depend on the selected Spend model.

The Cloud Summary displays the cloud asset count, total spend, available Spend models, and the distribution levels available for each model.

For a standard Spend model, select one or more of the following distribution levels:

You can select different distribution levels for each standard Spend model.

Publish Cloud spend to an AI model

When a Spend model is configured as an AI Model, Yarken applies AI-specific Cloud publishing behavior.

• Yarken publishes only Cloud spend where AI Service and Cloud Asset are populated.

• Qualifying AI-related Cloud spend is published to Expenses in the AI model.

• Cost Pool and Tower distribution are not available for AI models.

Publish cloud spend

To publish,

1. On the Cloud Usage Data page, select the ellipsis (…) for the month you want to publish.

2. Select Manage Cloud Spend.

3. Select PUBLISH. The Cloud Summary appears.

4. Select the required Spend models.

   

5. For standard Spend models, select the required distribution levels.

6. For an AI model, review the model selection. Yarken publishes qualifying AI-related Cloud spend to Expenses.

7. Select PUBLISH SPEND.

Yarken publishes Cloud spend according to the selected model type. Standard Spend models use the selected distribution levels, while AI models receive qualifying AI-related spend in Expenses.

After publishing, go to Designer > Assets > Cloud to review the Cloud assets created for the corresponding month. If published records had a blank Cloud Asset Name, the list includes a single Unknown Cloud asset containing that spend.

Note: You cannot add or delete cloud usage data once it is published. If you want to modify the cloud usage data, you must unpublish the spend first.

Note: If chargeback has been created for a month, that month is locked across all models. Cloud Consumption cannot be published or unpublished for a locked chargeback month.

How to unpublish the cloud spend?

To unpublish,

1. Navigate to the cloud spend published month and click (…).

2. Select Manage Cloud Spend.

3. On the upper-right corner, click UNPUBLISH button.

The cloud spend is unpublished from the cost transperancy and forecast.

Note: Unpublishing affects all cloud dashboards and reports that rely on the cloud spend data.

Delete Usage Data

You can delete uploaded files if any correction is needed. When deleting the data, you can choose to delete the source file as well.

To delete,

1. On the month that you want to delete the cloud usage data, click ellipsis (…) menu icon, and select View Uploaded Files option. An UPLOADED FILES tab opens.

2. Click delete icon on file row for which you want to delete the data.

3. Confirm the deletion.

Yarken unpublishes the cloud spend from the applicable models.

Related content

• Create cloud asset using Upload Rule

• Manage Upload Rules

• Expenses

• Models Overview

• Working with models