Home > Cloud Cruiser 3 > Viewing financial data > Data analysis in Microsoft Excel

Data analysis in Microsoft Excel

Table of contents
No headers

The Cloud Cruiser database contains views that allow you to more easily analyze loaded charges from within Microsoft Excel with an Office Data Connection. After relating the ReportSummary view to the ReportAccountStruct0 view by their AccountUID columns in Excel, you are able to create a PivotTable that shows charges for a desired level of your account structure.

This functionality requires Microsoft Excel 2010 or later. Connecting Excel covers connecting both Excel 2010 and Excel 2013 to a SQL Server database, but you can also connect Excel if your installation of Cloud Cruiser uses an Oracle database.

This section contains the following articles:

Last modified

Tags

Classifications

This page has no classifications.
© Copyright 2018 Hewlett Packard Enterprise Development LP