Reporting for Services Manager delivers usage and billing reports to your customers and application vendors. It includes standard reports to support standard provisioned services and a data warehouse. The Reporting service communicates directly with the SQL Server Reporting Services web service.
To generate a report, click a report link on the View Reports page. A separate window appears, displaying the report. After you generate a report, you can export it in several formats, including XML, CSV, and Excel. You can also customize the parameters of the report, including starting and ending dates and whether or not to include certain types of records. After you modify the parameters, click Generate to regenerate the report.
Reporting views are used as a source for data transferred to the data warehouse. When you generate reporting views, issues related to missing source views during data transfer are described in error messages to help you with troubleshooting.
When creating a new reporting view for a service, you will also need to ensure it can transfer data to the data warehouse. To do this, add a transfer command for the service to the data warehouse configuration file.
You can associate a billing unit with a specific plan type and include it in service billing reports. The settings with which to configure the billing unit vary with the service you select. To add billing units, you must have the Service Schema Administrator security role assigned to your account.