OData Feed Overview

 

Pre-requisites

Only available in Timemaster v4.11.0+

Requires the OData Feed Web Service to be installed.

 

 

The OData Feed provides you with a mechanism to create self-service reporting of the Timemaster data.

This can be used with Microsoft PowerBI and Microsoft Excel to analyze your Timemaster data, extending the reporting available in the existing Timemaster Crystal Reports.

 

Reporting templates

The Timemaster Reporting templates are four Microsoft PowerBI templates that can be used with chargeable and free PowerBI accounts. Once connected to the Timemaster OData Feed, it presents a set of preconfigured reports to help you analyze some of your Timemaster data. These templates are samples of what can be reported on and are intended as a starting point for you to explore your own Timemaster data.

 

You can customize the reports using the PowerBI desktop application, which offers a rich set of charts and other display options. If you have a full PowerBI account you can then publish the reports for wider use within the business.

 

The latest version of the Timemaster Reporting templates can be downloaded from here. Instructions on connecting the template to the reporting data feed are detailed in the Connectivity help topic.

 

Below is a list of the current database views available;-

Name

Description

ProjectAccountTransactions

List of individual project transactions by transaction date. Time Costs, Expense Costs and Invoiced values.

ProjectExpenses

A list of all project expenses booked to a project/task by transaction date. Includes costs, charges and their statuses.

ProjectFinancials

A comprehensive list of financials data for each project.

ProjectList

A list of all the key project information including the overall client fee.

ResourceTimePlan

Hours booked against the resource plan including actual/planned hours and costs.

Staff

A list of all the key staff information.

StaffExpenses

A list of all staff expenses booked to a project/task by transaction date. Includes costs, charges and their statuses.

TaskList

A list of project tasks giving a comprehensive list of financials by each task.

TimeCharges

A list of all timesheet lines including hours, costs, recharges and their statuses

 

Related Topics

OData Feed Installation

OData Feed Connectivity

Any images shown may be representative of the previous version of Timemaster

Report a problem

Please report any errors on this page to timemastersupport@equisys.com