Managing and viewing the Insights dashboard

Last updated 8 April, 2019

About Insights

HPE OneSphere allows you to collect data on costs associated with your public and private provider accounts, appliances, and display them as an interactive dashboard view, or as downloadable reports or budgets. Both the dashboard view and the reports/budgets option allow you to configure data from multiple categories, including provider type, account information, region, date range, and more. Currently, HPE OneSphere only shows costs/rates in US Dollars ($).

For Amazon Web Services (AWS), the cost includes all payer accounts that you connected to HPE OneSphere as Public Billing Accounts, and any member accounts associated with those payer accounts in AWS. Cost information for these member accounts will appear in Insights whether or not you have connected those member accounts to HPE OneSphere.

For Microsoft Azure, the cost includes all enterprise accounts that you connected to HPE OneSphere as Public Billing Accounts, and any subscription accounts connected to those enterprise accounts in Azure. Cost information for these subscription accounts will appear in Insights whether or not you have connected those subscription accounts to HPE OneSphere.

For private cloud providers, the cost represents actual usage costs for the vCPU, memory, and disk usage rates defined per private cloud provider/zone.

For the appliances, the cost represents total usage cost of the bare metal including CPU cores, memory, and storage.

NOTE:

Only HPE OneSphere Administrators and Analysts have permission to access cost analytics information. HPE OneSphere users with the Project Creator and Consumer roles will not see Insights on their main menu. However, Consumer's will still be able to see costs associated with the particular project they are assigned to.

When you first click Insights, the System Default Dashboard view is displayed. Click Reports in the banner at the top of the screen to see the Reports screen. Click Budgets in the banner at the top of the screen to see the Budgets screen.

After a custom dashboard view or a report/budget is saved, it will be visible by other administrators and analysts with accounts in your HPE OneSphere management service.

About the dashboard view

Dashboards

When you first click Insights, the System Default Dashboard view is displayed. This dashboard represents the total cost for the time period shown. The total cost includes:

The System Default Dashboard view cannot be edited or deleted. You can add one or more custom dashboard views. Any custom dashboard view you add can be deleted later. Custom dashboard views contain a unique name, date range, and filter set, which can all be edited after saving your dashboard view.

The main chart on each dashboard view displays the total amount spent during the designated time period. The top figure represents the total amount spent for that period. The total spent in the previous period is located below the total spent figure and represents the previous total over the same period of time. If your dashboard is set to 90 days, the previous total will represent the previous 90 day time frame. The figures below the previous totals represent the percentage in change and the total amount changed from the previous total to the current total.

After adding multiple custom dashboards, the Dashboards screen will change to include scrolling arrows on the sides and carousel dots on the bottom of each dashboard chart, so you can easily navigate from one dashboard view to another.

Custom Dashboard Filters

The data available on each custom dashboard is defined by a set of filters. The information located in the Quick View Filters and the Report Views in each custom dashboard is also determined by how you set up your filters. For example, if you want to see costs per provider, per account, and per region, then adjust your filters in your dashboard accordingly. You can set these filters when you add or edit your custom dashboard.

If you want to experiment with different data parameters in a particular dashboard, but you do not want to make any permanent changes to how that data is arranged, do not click Save Changes. As long as you do not save your changes, any modifications you make to your dashboard view will be reset when you navigate away.

Quick View Filters

Quick view filters take the total cost for the time frame you selected, and break it down across different categories. Each category is further broken down by each item in that category, such as costs per day, per account, and per provider.

You can organize how information in each category is displayed by clicking on an individual item in a category. If you want to see how much money was spent from one account, and how much of that was spent per day in the date range you selected, click on the account you want to analyze and the information in the other categories will automatically be filtered to reflect that selection.

Clicking on the rows in these filters will cumulatively add to the existing filters. You must click Clear All to return to the default quick view filters.

Three of the available categories represent Report Views. Click on an item in one of the Report Views categories and you will be redirected to a new report on the Reports screen that you can download.

Information available in Reports Views includes:

This is one of two ways to create a report. This way allows Analysts and Administrators to make a shareable report based on the information they see in the dashboard view. If there are any anomalies in spending over a particular period, this feature allows you to quickly capture that information in a downloadable report.

Adding and configuring custom dashboards 

The Dashboard tab on the Insights screen shows the system default dashboard and any custom dashboards. The Dashboard screen is the default view when you first select Insights in the HPE OneSphere main menu.

The data available on each custom dashboard is defined by a set of filters. The information located in the Quick View Filters and the Report Views in each custom dashboard is also determined by how you set up your filters. For example, if you want to see costs per provider, per account, and per region, then adjust your filters in your dashboard accordingly. You can set these filters when you add or edit your custom dashboard.

Prerequisites

In order to view and create custom dashboards in HPE OneSphere:

  • You must have administrator or analyst permissions.

  • The administrator added one or more Public Billing Accounts to HPE OneSphere.

Procedure
  1. From the HPE OneSphere main menu, click Insights.
  2. From the Dashboard screen, click the Add  icon.
  3. In the resulting right hand panel, under Name, enter the name for your custom dashboard that will be listed on the main Dashboard screen.

    After adding multiple custom dashboards, the Dashboards screen will change to include scrolling arrows on the sides and carousel dots on the bottom of each dashboard chart, so you can easily navigate from one dashboard view to another.

  4. Click the plus icon next to Filters to bring up the Filter Manager screen.
  5. Under Field, click the search icon to display a list of available filter fields, and select the field you want to manage.
  6. Click the drop down menu next to Operator to select the condition you want to set for your filter.
  7. Enter the value you want to set for your filter in the Value field, and click Save.

    NOTE:

    Repeat steps 4-7 to add additional filters to your custom dashboard.

  8. (Optional) At the top of the dashboard window, select the date range you want to include in your custom dashboard. For a custom date range, select the dates you want to include from the calendar drop down menus.
  9. (Optional) Adjust the quick view filters in your custom dashboard to configure the data you want to display:
    1. From one of the three categories under Quick View Filters, click on an individual line item to reconfigure the data in all other Quick View Filter categories to match that item.
      If you want to see costs broken down for a specific account, click on the account in the Account Costs category, and all other categories will display costs associated with that account.
    2. To see how your adjusted Quick View Filters in a downloadable report view, click one of the line items from the categories under Reports Views.
  10. When you finish configuring your custom dashboard, click Save Changes in the top right corner.

    NOTE:

    Any changes you make to an existing custom dashboard view will be temporary unless you click Save Changes. If you want to see various ranges of data in your custom dashboard without saving different configurations, navigate away from the page before saving, and the next time you view the custom dashboard it will return to its previous configuration.

Customizing the private zone cost model

Update the private zone cost model so that the cost details shown on the Insights screen are calculated based on your environment's actual costs.

If you do not customize the cost model, costs are calculated based on the values in a Small sample HPE Synergy Bill of Materials (BOM) configuration.

Prerequisites

The administrator connected HPE OneSphere to a private cloud zone.

Procedure
  1. From the HPE OneSphere main menu, select Providers.
  2. Click Private Zones.
  3. Select the zone that you want to update.
  4. Click Update Zone.
  5. In the Update Zone panel, enable the Customize Cost Model slider button.
  6. Replace one or more default values (shown in gray) with the costs for your environment.

    The values you can update are:

    1. Annual Fixed Cost (Not available for HPE OneView zones)
    2. vCPU (per core rate/hour)
    3. Memory (per GB rate/hour)
    4. Storage (per GB rate/hour)
  7. Click Update Zone.

Insights data field mapping values

HPE OneSphere normalizes the field names collected from cloud providers, so if you are collecting from multiple providers you can see cost and usage data for all providers in the same charts, reports, and insights. For your reference, the following table lists the normalized names of HPE OneSphere system fields and the names of those fields from each provider. "N/A" indicates that data for that field is not available from the provider.

Insights data field map

HPE OneSphere field AWS source Azure source Private Cloud Description Data Type Available for Budgets?
Account ID LinkedAccount Id Subscription GUID N/A The Amazon AWS account ID is a 12-digit number used to create AWS resource names. The AWS account ID distinguishes resources from resources deployed in other AWS accounts. The Azure Subscription ID is a 32-digit GUID associated with an Azure Subscriber's Subscription or Program. STRING Yes
Account Name AccountName Subscription Name N/A Account names are text created to describe an account or subscription ID STRING Yes
Account Owner N/A Account Name N/A Account name associated with Azure Active Directory. STRING Yes
Account Owner ID N/A AccountOwner Id N/A Account ID associated with Azure Active Directory STRING Yes
Accounting Date UsageStartDate Date (from EA) or usageEndTime (from the Azure Usage API) N/A The Amazon AWS UsageStartDate is the start date and time for a particular resource or service deployment. The Azure Date or usageEndTime is the end of the usage aggregation time range. The response is grouped by the time of consumption (when the resource was actually used vs. when was it reported to the billing system). DATE No
Blended Cost BlendedCost N/A N/A AWS calculates blended costs by multiplying the blended rate for each service with an account's usage of that service. DECIMAL No
Blended Rate BlendedRate N/A N/A Blended rates are the averaged rates of the Reserved Instances and On-Demand Instances that are used by member accounts in an organization in AWS Organizations. DECIMAL No
Consumed Service N/A Consumed Service N/A Azure platform service that was consumed. STRING Yes
Cost UnBlendedCost or Cost ExtendedCost Cost The AWS UnblendedCost comes from the UnblendedRate multiplied by the UsageAmount. The Azure ExtendedCost is the estimated charge based on Consumed Quantity and Extended cost DECIMAL No
Cost Center N/A Cost Center N/A The Azure Cost Center is an optional Azure tag key. STRING Yes

HPE OneSphere field AWS source Azure source Private Cloud Description Data Type Available for Budgets?
CPU Utilization CPUUtilization (InstanceId) CPUUtil. Average CPU Utilization Each AWS CPUUtilization value represents the maximum CPU utilization percentage for the specified instance for a particular six-minute time period. The Azure CPUUtil.Average is the averate CPU utiization over a selected time period. DECIMAL No
Department Name N/A Department Name N/A The Azure Department is a name within the organization that contains a group of individuals. This item within the namespace is optional. STRING Yes
Memory Available N/A Memory Available Memory (Linux) Memory Available Bytes (Windows) N/A Available memory for selected VM resources.   No
Memory Utilization N/A Calculated using the memory capacity of the application's VM catalog and the Memory Available value. Memory Utilization Calculated using the memory capacity of the application's VM catalog and the Memory Available value.   No
Meter ID N/A Meter ID Meter ID The billed meter identifier that's used to price billing usage STRING No
Meter Name Based on UsageType ​and ProductName in most cases Meter Name Meter Name The AWS UsageType provides usage detail for a specific deployed resource. For example, USW2-BoxUsage: m2.2xlarge describes an M2 High Memory Double Extra Large instance in the US West (Oregon) Region. The Azure Meter Name identifies the unit of measure for the meter being consumed STRING No
Meter Category N/A Based on Meter Category N/A Identifies the top-level service for the usage STRING Yes
Meter Sub-category N/A Based on Meter Sub-Category N/A Defines the type of Azure service that can affect the rate STRING Yes
NCS Category N/A N/A Y   STRING No
NCS Description N/A N/A Y   STRING No

HPE OneSphere field AWS source Azure source Private Cloud Description Data Type Available for Budgets?
NCS Description N/A N/A Y   STRING No
NCS Project ID N/A N/A Y Provides the ID number of a OneSphere project. STRING No
NCS Project Name N/A N/A Y Provides the name of a OneSphere Project. STRING Yes
NCS Region ID N/A N/A Y Provides the ID number of the Region for the selected Private Cloud. STRING No
NCS Region Name N/A N/A Y Provides the name of the Region for the selected Private Cloud. STRING Yes
NCS Tag environment N/A N/A Not Currently Used     No
NCS Tag line-of-business N/A N/A Not Currently Used     No
NCS Tag tier N/A N/A Not Currently Used     No
NCS Zone ID N/A N/A Y Provides the ID number of the Zone for the selected Private Cloud. STRING No
NCS Zone Name N/A N/A Y Provides the name of the Zone for the selected Private Cloud. STRING Yes
Network In MB ​NetworkIn (InstanceId) and NetworkBytesIn (CacheClusterId) NetworkIn.Total (Linux VMs only) N/A The AWS NetworkIn meter provides the number of bytes received by a VM per minute. DECIMAL No

HPE OneSphere field AWS source Azure source Private Cloud Description Data Type Available for Budgets?
Network Out MB NetworkOut (InstanceId) and Network BytesOut (Cache ClusterId) Network Out.Total (Linux VMs only) N/A The AWS NetworkIn meter provides the number of bytes sent by a VM per minute. DECIMAL No
Operating System Based on Item Description Based on Meter Sub-Category N/A ? STRING Yes
Product ProductName Product Product The AWS ProductName is the full name of the AWS service. The Azure Product is the name of the Azure service. STRING Yes
Provider Set by HPE OneSphere as "Amazon" Set by HPE OneSphere as "Azure" Set by HPE OneSphere as "NCS" The distinct cloud provider name. STRING Yes
Provider Region Based on AvailabilityZone (or UsageType if AvailabilityZone is empty) Resource Location N/A - See "NCS Region" The AWS availability zone. The Azure data center location or region. STRING Yes
Provider Type Set by HPE OneSphere as "Public Cloud" Set by HPE OneSphere as ​"Public Cloud" Set by HPE OneSphere as ​"Private" The type of a cloud service provider. STRING Yes
Provider Zone AvailabilityZone Meter Region N/A - See "NCS Zone" The AWS availability zone. The Azure region. STRING Yes
Purchase Model Set by HPE OneSphere as "Reserved," "On Demand," or "Spot" - N/A The type of AWS resource deployment. STRING Yes
Quantity UsageQuantity (or set to "1" if UsageQuantiy is empty) Consumed Quantity Quantity The total amount of usage of a resource during the selected time. For example, if a VM is allocated with 2 CPU cores and 8GB Memory and if the VM is kept running for 10 hours, the quantity would be 20 for CPU and 80 for Memory respectively. The quantity is further qualified by the "Usage Start" and "Usage End" columns. DECIMAL No
Rate UnBlendedRate or Rate ResourceRate N/A The AWS UnBlendedRate associated with the current price of a service or product. The Azure ResourcRate is associated with the current price of a service or product. DECIMAL No

HPE OneSphere field AWS source Azure source Private Cloud Description Data Type Available for Budgets?
Read Throughput ReadThroughput (DBInstance Identifier) N/A N/A The average number of bytes read from disk per second. INTEGER No
Reserved Instance ReservedInstance N/A N/A Describes an AWS Reserved Instance. STRING No
Resource ID ResourceId Instance ID N/A The unique ID for a deployed resource. STRING No
Resource Group N/A resource.group tag (collected via subscription access, not from the EA bill) N/A The resource group ID.   Yes
Resource Name Based on the Name tag (Instance Name) Based on ResourceId Resource Name A tag describing a resource. For private cloud, it is the name of Compute or Storage resource STRING No
Resource Type Set by HPE OneSphere as "VM" for virtual machine records and "Volume" for storage volume records Set by HPE OneSphere as "VM" for virtual machine records N/A Pre-configured by a HPE OneSphere to describe a type of resource. STRING No
Service Category Based on ProductName Based on Product Set by HPE OneSphere as "Compute" for VMs and "Storage" for block storage Displays each provisioned product's name. STRING Yes
Storage Read Bytes DiskReadBytes (InstanceId) and VolumeReadBytes (VolumeId) N/A N/A Bytes read from all instance store volumes available to the instance. The number reported is the number of bytes received during the period. INTEGER No
Storage Write Bytes DiskWriteBytes (InstanceId) and VolumeWriteBytes (VolumeId) N/A N/A Bytes written to all instance store volumes available to the instance. The number reported is the number of bytes received during the period. INTEGER No
Units Based on ProductName and ItemDescription Meter Name Set by HPE OneSphere as one of "percent, GB, cores" based on Product and Service Category This is the metering units that is most appropriate for the resource record. For example, a private cloud CPU Utilization record will have Units set to "percent" whereas the "VM CPU Count" record will have it set to "cores". STRING No

HPE OneSphere field AWS source Azure source Private Cloud Description Data Type Available for Budgets?
Usage End UsageEndDate Date (from EA) or usage EndTime (from the Azure Usage API) Set by HPE OneSphere as the last time when the resource was still allocated Service start date. TIMESTAMP No
Usage Start UsageStartDate Date (from EA) or usage StartTime (from the Azure Usage API) Set by HPE OneSphere as the earliest time in a day when the resource was still allocated Service end date. TIMESTAMP No
VM CPU Count Based on Meter (HPE OneSphere field) Based on Meter Sub-Category Set by HPE OneSphere as the number of CPU cores allocated to the VM resource (empty if the resource is not a VM)   INTEGER No
VM Disk GB Based on Meter (HPE OneSphere field) Based on Meter Sub-Category Set by HPE OneSphere as the disk amount in GB allocated to the VM resource (empty if the resource is not a VM)   DECIMAL No
VM Disk Type Based on Meter (HPE OneSphere field) Based on Meter Sub-Category N/A   STRING No
VM Family Based on Meter (HPE OneSphere field) Based on Meter Sub-Category N/A   STRING Yes

HPE OneSphere field AWS source Azure source Private Cloud Description Data Type Available for Budgets?
VM GPU Count Based on Meter (HPE OneSphere field) Based on Meter Sub-Category N/A   INTEGER No
VM Max Num Disk Based on Meter (HPE OneSphere field) Based on Meter Sub-Category N/A   INTEGER No
VM Memory GB Based on Meter (HPE OneSphere field) Based on Meter Sub-Category Set by HPE OneSphere as the memory amount in GB allocated to the VM resource (empty if the resource is not a VM)   DECIMAL No
VM Provider Series Based on Meter (HPE OneSphere field) N/A N/A   STRING No
VM Provider Type Based on Meter (HPE OneSphere field) Based on Meter Sub-Category N/A   STRING Yes
VM Size Based on Meter (HPE OneSphere field) Based on Meter Sub-Category N/A   STRING Yes
Write Throughput WriteThroughput (DBInstanceIdentifier) N/A N/A The average number of bytes written to disk per second. (bytes/second) INTEGER No

Data Type Details

Data Type Supported Aggregation Functions Decimal Precision
STRING Count, Count Distinct None
DECIMAL Count, Count Distinct Min Max Average Sum 4
INTEGER Count, Count Distinct Min Max Average Sum None
DATE None None
TIMESTAMP None None