DataSelf DFT+ (Dimension, Fact, Time) uses automate data modeling and AI. Application independent, automated data modeling defines standard components (e.g., ‘customers’ & ‘items’) and creates thousands of metrics.
Auto-modeling via AI takes minutes. It removes the guesswork on how to combine your ERP tables into useable data models. It’s a game-changing component that empowers your BI solution with a low total cost of ownership (TCO) and immediate ROI.
Click here to learn more about the power and flexibility of DFT+.
DFT+ currently available for DataSelf NOW
AP - AP Aging Today
Provides information about open payables, combining information from tables such as outstanding bill header, company and vendor. Payable documents are aged as of Today. Some ERP's may also list historical (now paid) invoices and their original amounts.
Star Schema: _S_AP_Aging_Today
AR - AR Aging Today
Provides information about open receivables, combining information from tables such as outstanding invoice header, company, Customer and salesperson. Payable documents are aged as of Today. Some ERP's may also list historical (now paid) invoices and their original amounts.
Star schema: _S_AR_Aging_Today
BD - Budgeting/Forecasting
Customizable templates.
GT - GL Transaction
Uses the ERP's General Ledger summary tables to provide Balance Sheet, Budgeted Income Statement (EBITDA and traditional), and Statement of Cash Flow that largely mimic official financial statement formats while still offering interactive comparison, filtering, and drilldown by date, Account Segments, key financial ratios, and drill-through to details within the _GL_Transactions data.
Provides reporting on the General Ledger journal entries as well as GL Budgets and calculated financial ratios, to the level of detail posted to the General Ledger. It can be filtered by date, source journals, and various groupings of the Chart of Accounts, including by Account Segments.
Star schema: _S_GL_Transaction
HD - Historical Data Blending
Customizable templates that work in conjunction with other templates to provide historical data blending: live data unioned with legacy or other historical data sources.
DFT+ Live and Legacy Historical Reporting (Data Migration / Blending)
PO - Purchase Order
Provides information about pending purchase orders, combining information from tables such as pending purchase order header, pending purchase order details, product, vendor and warehouse/location. Historical trends and averages reporting depends on the retention of PO history in the ERP. (Receipt history would be a customization, but that need is usually met in Inventory Transactions.)
Star schema: _S_PO_Purchase_Order
SI - Sales Invoice
Provides analysis from Accounts Receivable invoice information. It combines information from tables such as invoice header, invoice details, company, customer, product, salesperson, ship-to, and warehouse/location.
Star schema: _S_SI_Sales_Invoice
SO - Sales Order
Provides information about sales orders, combining information from tables such as sales order header, sales order details, company, customer, product, salesperson, ship-to and warehouse/location. Many ERP systems provide open and historical SO records, others only provide open SO records.
Star schema: _S_SO_Sales_Order