Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

Choosing the Data Source for your Report


Overview

Users of Jet Analytics have several options when choosing the best data source for a specific report:

  • Source ERP (NAV, GP, AX or Business Central)
  • Data Warehouse
  • Cubes

But how do you know which source to choose?  Here are a few guidelines to help you make the best decision given your requirements.

Source Pros & Cons When to Use

Source ERP

Pros

  • Familiar application database structure
  • Real-time availability of data
  • Contains all data

Cons

  • Data is unsorted and separated
  • Can have unclear naming
  • Reports may run slower due to data being split across multiple tables
  • Companies typically exist in separate instances
  • Real-time data is needed
  • Non-complex reports
    • The more tables you need, the slower it goes
    • Does it require multiple fields to calculate a single outcome?
  • Small data throughput
    • ERP systems are designed for input
    • Give priority to input vs output
  • Non-commonly used tables or fields are needed

Data Warehouse

Pros

  • Built from source data
  • Data is sorted and consolidated
  • Tables and fields from source data are consolidated into new tables
  • Multiple companies or data sources pulled into one source
  • Better named tables and fields
  • Reports can run faster due to fewer tables and smaller data set

Cons

  • Not real-time data
  • Only contains data selected from source data
  • Real-time data not required
    • Typically a 1-day delay in data
  • Preferred source for detailed reports
  • Faster execution times
  • Consolidated reporting
    • Multiple companies
    • Multiple data sources

Cubes

Pros

  • Built from data warehouse
  • Data is pre-calculated and aggregated
  • Clearly named
  • Reports with calculations run more efficiently due to pre-calculated data

 Cons

  • Not real-time data
  • Typically 1-day delay
  • Typically no detail-level information
  • Easily build Pivot Tables and dashboards
  • Fastest execution times
  • Consolidated reporting
    • Multi-company
    • Multi-data source
  • Aggregated data reporting
    • Summarized data
    • Complex calculations
  • Real-time data not needed
  • Need a PivotTable

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments