BI Data Sources
With this functionality you can get or create default Analysis Cubes
How to Initialize BI Data Sources
- Go to BI Data Sources
- On the action bar click on Init BI Data Sources
- All available BI Data source will be initialized
Tip
You can also create a BI Data Source without a predefined Data Source. Create a new BI Data source, select the correct Field Type (for e.g. Decimal) and configure the function set(s).
Available BI Data Source
| BI Data Source | Description |
|---|---|
| BATCH INVT | Inventory per Batch |
| CUST SALES | Customer revenue per period |
| CUSTOMS B/L | Customs Bill of Lading Analysis |
| EMBALLAGE-ARTIKELEN | Package Overview |
| ITEM SALES/PURCH | Item Sales/Purchases per period |
| OCEANOVERVIEW | Calculate Ocean Overview |
| PICKING OVERVIEW | Overview of (outstanding) Picking Quantity |
| SCAN EMPLOYEE | Scan Employee |
| SHOW DATA SOURCE | Show Data Source |
| TRIP OVERVIEW | Trip Overview |
| TSB OVERVIEW | Timeslot Booking Overview |
| UPDATE DATA SOURCE | Update Data Source |
| VAL CHARGES | VAL Charge Overview |
| VAL MACHINE | VAL Machine Analysis List |
| VAL MANUAL | VAL Manual Orders |
| VAL ORDERS | VAL Order Analyselijst |
| VENDOR PURCHASES | Vendor purchases per period |
| WORKLD SCAN EMP | Workload Scan Employee |
| WORKLOAD | Workload Overview |
| WORKLOAD PICK | Workload Pick |
| WORKLOAD WHSE ACT | Workload Whse Actions |
| WORKLOADPICK STRGY | Workload Pick Strategy |
Overview of (outstanding) Picking Quantity
Function: "WMS BI Calculation Functions" - Function 470 (PICKING OVERVIEW)
This Data Source includes the following fields
| Field | Description | |
|---|---|---|
| 1 | Units to Pick | Outstanding pick quantity for this customer |
| 2 | Units Picked | Quantity already picked for this customer, incl Posted Lines |
| 3 | Units Total | Total Pick Quantity |
| 4 | Lines to Pick | Outstanding pick lines for this customer |
| 5 | Lines Picked | Lines already picked for this customer, incl Posted Lines |
| 6 | Lines Total | Total Pick Lines |
| 7 | Orders to Pick | Outstanding pick orders for this customer |
| 8 | Orders Picked | Orders already picked for this customer |
| 9 | Orders Total | Total Orders for this customer, incl Posted Orders |
| 10 | Units Tomorrow | Pick Units tomorrow |
| 11 | Lines Tomorrow | Pick Lines tomorrow |
| 12 | Orders Tomorrow | Pick Orders tomorrow |
| 13 | Units After | Pick Units after tomorrow |
| 14 | Lines After | Pick Lines after tomorrow |
| 15 | Orders After | Pick Orders after tomorrow |
| 16 | Carriers to Receive | Number of Carriers/Pallets to Receive |
| 17 | Carriers Received | Number of Carriers which are already Received |
| 18 | Carriers to Receive Tomorrow | Number of Carriers to receive tomorrow |
| 19 | Carriers to Receive After | Number of Carriers to receive after tomorrow |
| 20 | Carriers to Ship | Number of Carriers to ship |
| 21 | Carriers Shipped | Number of Carriers already shipped |
| 22 | Carriers to Ship Tomorrow | Number of Carriers to ship tomorrow |
| 23 | Carriers to Ship After | Carriers to Ship after tomorrow |