MTE Based: ELM Standard Reports are now based on Tableau's Multiple Table Extract (MTE) feature. This feature ensures that the underlying design of the standard data sources is suitable for easy customizations when new fields are added in Matters, Vendors, and Invoices Apps in Onit. This design also ensures that the data sources are no longer restricted to show only Matters that have Invoices.

DW Refresh Date: The ELM Standard Reports header now shows the actual date the data was refreshed in the data warehouse. In previous versions, the date in the report header was based on the maximum of the “updated at” date in the Matters App.

Line Item Inactive Filter: The new MTE-based standard data sources have an additional filter, “Line Item Inactive.” Line items marked as inactive (Line Item Inactive value of 1) in Billing Point are not included in the data source.

DW Refresh

1. Incremental Refresh that syncs only changes from the last update to the DW. Incremental refreshes will be configured Mon-Sat, and a complete refresh will be on Sunday.
2. The DW full refresh now completes in a fraction of the current time.
3. Data Quality Validations performed with each DW Refresh alert support personnel of unexpected results for faster resolution of issues found.

The new data sources that the ELM Standard Reports are based on are:

1. ELM_MTE_Std_InvoiceLineItem
   • All Standard Reports are based on this data source.  This data source includes line item level detail and matter, vendor, and invoice level information. Below are the joins and join details

2. ELM_MTE_Std_Invoices
   • This data source design is very similar to the ELM_MTE_Std_InvoiceLineItem and includes Matter, Vendor, and Invoice information but does not include line item level information.

• Audit history for adjustments made in Billing Point and Private (custom) Staff Classifications are now available for reporting in the Tableau environment.