Tableau Enterprise: IN Inventory On Hand Today

_IN_On_Hand_Today: Tableau Enterprise Templates

This page describes DataSelf’s Tableau Enterprise customizable Templates for Inventory On Hand Today.

KPI: A key performance indicator. Examples: a Report such as "Yearly Revenue"; a Dashboard widget (e.g., the main chart from the Cash Flow Projection dashboard); a Data Source measure (e.g., Cost of Sales from the _SI_SalesInvoice Data Source); a Data Source dimension (e.g., the Customer dimension from _AR_Aging_Today that provide the list of customers with open AR).

Dashboards

A Tableau Dashboard contains one or more Tableau Worksheets and/or other objects such as webpages.

Dashboard Naming Convention:

• “Tableau Workbook name (twb file)”: “Tableau Dashboard name (view name)”

• E.g., “- Cost on Hand Today: Item” dashboard can be found in the “Item” worksheet on the “- Cost on Hand Today.twb” workbook. In Tableau Server, search for “Cost on Hand Today”, then click the “Item” view.

Dashboard List (with screenshot examples)

– Cost On Hand Today: Company (2 KPIs)
– Cost On Hand Today: Company and Item (2 KPIs)
– Cost On Hand Today: Item (2 KPIs): This dashboard has two KPIs: 1) A chart with Qty On Hand Today by Item in descending order by Qty On Hand Today; 2) A grid with the total and individual Qty On Hand Today by Item ordered alphabetically.

– Cost On Hand Today: Item Cat (2 KPIs)
– Cost On Hand Today: Whse (2 KPIs)
– Cost On Hand Today: Whse and Item (2 KPIs)
– Large Cost On Hand Today: Company (2 KPIs)
– Large Cost On Hand Today: Company and Item (2 KPIs)
– Large Cost On Hand Today: Item (2 KPIs)
– Large Cost On Hand Today: Item Cat (2 KPIs)
– Large Cost On Hand Today: Whse (2 KPIs)
– Large Cost On Hand Today: Whse and Item (2 KPIs)
– Negative Net Qty On Hand Today: Company (2 KPIs)
– Negative Net Qty On Hand Today: Company and Item (2 KPIs)
– Negative Net Qty On Hand Today: Item (2 KPIs)
– Negative Net Qty On Hand Today: Item Cat (2 KPIs)
– Negative Net Qty On Hand Today: Whse (2 KPIs)
– Negative Net Qty On Hand Today: Whse and Item (2 KPIs)
– Qty On Hand Today: Company (2 KPIs)
– Qty On Hand Today: Company and Item (2 KPIs)
– Qty On Hand Today: Item (2 KPIs)
– Qty On Hand Today: Item Cat (2 KPIs)
– Qty On Hand Today: Whse (2 KPIs)
– Qty On Hand Today: Whse and Item (2 KPIs)
– Qty On Hand Today, On PO, On SO and Net: Company (2 KPIs)
– Qty On Hand Today, On PO, On SO and Net: Company and Item (2 KPIs)
– Qty On Hand Today, On PO, On SO and Net: Item (2 KPIs)
– Qty On Hand Today, On PO, On SO and Net: Item Cat (2 KPIs)
– Qty On Hand Today, On PO, On SO and Net: Whse (2 KPIs)
– Qty On Hand Today, On PO, On SO and Net: Whse and Item Cat (2 KPIs)
– Qty On PO Today: Company (2 KPIs)
– Qty On PO Today: Company and Item (2 KPIs)
– Qty On PO Today: Item (2 KPIs)
– Qty On PO Today: Item Cat (2 KPIs)
– Qty On PO Today: Whse (2 KPIs)
– Qty On PO Today: Whse and Item (2 KPIs)
– Qty On SO Today: Company (2 KPIs)
– Qty On SO Today: Company and Item (2 KPIs)
– Qty On SO Today: Item (2 KPIs)
– Qty On SO Today: Item Cat (2 KPIs)
– Qty On SO Today: Whse (2 KPIs)
– Qty On SO Today: Whse and Item (2 KPIs)
– Top Cost On Hand: Item (2 KPIs): This dashboard has two KPIs: 1) A chart with Cost On Hand Today by Item in descending order by Cost On Hand Today; 2) A grid with the total and individual Cost On Hand Today by Item and Whse ordered alphabetically.

– Top Cost On Hand Today: Whse (2 KPIs)
– Top Net Qty On Hand: Item (2 KPIs)
– Top Net Qty On Hand: Whse (2 KPIs)
– Top Qty On Hand Today: Item (2 KPIs)
– Top Qty On Hand Today: Whse (2 KPIs)

Reports

A Tableau Report is a Tableau Worksheet with a grid or chart. Report Naming Convention:

• Main report of a Workbook: “Tableau Workbook name (twb file)”

• Slices of the main report: “Tableau Workbook name (twb file)”: “Tableau Worksheet name (view name)”

• E.g.:

  • “Qty On Hand Today” report can be found in the “Core” worksheet on the “Qty On Hand Today.twb” workbook. In Tableau Server, search for “Qty On Hand Today”, then click the “Core” view.

  • “Qty On Hand Today: Whse” report can be found in the “Whse” worksheet on the “Qty On Hand Today.twb” workbook. In Tableau Server, search for “Qty On Hand Today”, then click the “Whse” view.

Report List (with screenshot examples)

DataSelf Analytics: Days of Stock (1 KPI)
DataSelf Analytics: Items by Whse (1 KPI)
DataSelf Analytics: Slow Moving Items (1 KPI)
DataSelf Analytics: Stuck Items (1 KPI)
Company - Cost and Qty On Hand Today: Core (1 KPI)
Company - Cost and Qty On Hand Today: Item (1 KPI)
Company - Cost and Qty On Hand Today: Item and Whse (1 KPI)
Company - Cost and Qty On Hand Today: Item Cat (1 KPI)
Company - Cost and Qty On Hand Today: Item Cat and Item (1 KPI)
Company - Cost and Qty On Hand Today: Whse (1 KPI)
Company - Cost and Qty On Hand Today: Whse and Item (1 KPI)
Company - Cost and Qty On Hand Today: Whse and Item Cat (1 KPI)
Company - Cost and Qty On Hand Today: Whse, Item Cat and Item (1 KPI)
Company - Cost and Qty On Hand, On PO and On SO Today: Core (1 KPI)
Company - Cost and Qty On Hand, On PO and On SO Today: Item (1 KPI)
Company - Cost and Qty On Hand, On PO and On SO Today: Item and Whse (1 KPI)
Company - Cost and Qty On Hand, On PO and On SO Today: Item Cat (1 KPI)
Company - Cost and Qty On Hand, On PO and On SO Today: Item Cat and Item (1 KPI)
Company - Cost and Qty On Hand, On PO and On SO Today: Whse (1 KPI)
Company - Cost and Qty On Hand, On PO and On SO Today: Whse and Item (1 KPI)
Company - Cost and Qty On Hand, On PO and On SO Today: Whse and Item Cat (1 KPI)
Company - Cost and Qty On Hand, On PO and On SO Today: Whse, Item Cat and Item (1 KPI)
Company - Cost On Hand Today: Core (1 KPI)
Company - Cost On Hand Today: Item (1 KPI)
Company - Cost On Hand Today: Item and Whse (1 KPI)
Company - Cost On Hand Today: Item Cat (1 KPI)
Company - Cost On Hand Today: Item Cat and Item (1 KPI)
Company - Cost On Hand Today: Whse (1 KPI)
Company - Cost On Hand Today: Whse and Item (1 KPI)
Company - Cost On Hand Today: Whse and Item Cat (1 KPI)
Company - Cost On Hand Today: Whse, Item Cat and Item (1 KPI)
Company - Maximum Net Qty On Hand Today: Core (1 KPI)
Company - Maximum Net Qty On Hand Today: Item (1 KPI)
Company - Maximum Net Qty On Hand Today: Item and Whse (1 KPI)
Company - Maximum Net Qty On Hand Today: Item Cat (1 KPI)
Company - Maximum Net Qty On Hand Today: Item Cat and Item (1 KPI)
Company - Maximum Net Qty On Hand Today: Whse (1 KPI)
Company - Maximum Net Qty On Hand Today: Whse and Item (1 KPI)
Company - Maximum Net Qty On Hand Today: Whse and Item Cat (1 KPI)
Company - Maximum Net Qty On Hand Today: Whse, Item Cat and Item (1 KPI)
Company - Maximum Qty On Hand Today: Core (1 KPI)
Company - Maximum Qty On Hand Today: Item (1 KPI)
Company - Maximum Qty On Hand Today: Item and Whse (1 KPI)
Company - Maximum Qty On Hand Today: Item Cat (1 KPI)
Company - Maximum Qty On Hand Today: Item Cat and Item (1 KPI)
Company - Maximum Qty On Hand Today: Whse (1 KPI)
Company - Maximum Qty On Hand Today: Whse and Item (1 KPI)
Company - Maximum Qty On Hand Today: Whse and Item Cat (1 KPI)
Company - Maximum Qty On Hand Today: Whse, Item Cat and Item (1 KPI)
Company - Minimum Cost On Hand Today: Core (1 KPI)
Company - Minimum Cost On Hand Today: Item (1 KPI)
Company - Minimum Cost On Hand Today: Item and Whse (1 KPI)
Company - Minimum Cost On Hand Today: Item Cat (1 KPI)
Company - Minimum Cost On Hand Today: Item Cat and Item (1 KPI)
Company - Minimum Cost On Hand Today: Whse (1 KPI)
Company - Minimum Cost On Hand Today: Whse and Item (1 KPI)
Company - Minimum Cost On Hand Today: Whse and Item Cat (1 KPI)
Company - Minimum Cost On Hand Today: Whse, Item Cat and Item (1 KPI)
Company - Minimum Qty On Hand Today: Core (1 KPI)
Company - Minimum Qty On Hand Today: Item (1 KPI)
Company - Minimum Qty On Hand Today: Item and Whse (1 KPI)
Company - Minimum Qty On Hand Today: Item Cat (1 KPI)
Company - Minimum Qty On Hand Today: Item Cat and Item (1 KPI)
Company - Minimum Qty On Hand Today: Whse (1 KPI)
Company - Minimum Qty On Hand Today: Whse and Item (1 KPI)
Company - Minimum Qty On Hand Today: Whse and Item Cat (1 KPI)
Company - Minimum Qty On Hand Today: Whse, Item Cat and Item (1 KPI)
Company - Qty On Hand Today: Core (1 KPI)
Company - Qty On Hand Today: Item (1 KPI)
Company - Qty On Hand Today: Item and Whse (1 KPI)
Company - Qty On Hand Today: Item Cat (1 KPI)
Company - Qty On Hand Today: Item Cat and Item (1 KPI)
Company - Qty On Hand Today: Whse (1 KPI)
Company - Qty On Hand Today: Whse and Item (1 KPI)
Company - Qty On Hand Today: Whse and Item Cat (1 KPI)
Company - Qty On Hand Today: Whse, Item Cat and Item (1 KPI)
Company - Qty On Hand, On PO and On SO Today: Core (1 KPI)
Company - Qty On Hand, On PO and On SO Today: Item (1 KPI)
Company - Qty On Hand, On PO and On SO Today: Item and Whse (1 KPI)
Company - Qty On Hand, On PO and On SO Today: Item Cat (1 KPI)
Company - Qty On Hand, On PO and On SO Today: Item Cat and Item (1 KPI)
Company - Qty On Hand, On PO and On SO Today: Whse (1 KPI)
Company - Qty On Hand, On PO and On SO Today: Whse and Item (1 KPI)
Company - Qty On Hand, On PO and On SO Today: Whse and Item Cat (1 KPI)
Company - Qty On Hand, On PO and On SO Today: Whse, Item Cat and Item (1 KPI)
Company - Qty On Hand, On PO, On SO and Net Today: Core (1 KPI)
Company - Qty On Hand, On PO, On SO and Net Today: Item (1 KPI)
Company - Qty On Hand, On PO, On SO and Net Today: Item and Whse (1 KPI)
Company - Qty On Hand, On PO, On SO and Net Today: Item Cat (1 KPI)
Company - Qty On Hand, On PO, On SO and Net Today: Item Cat and Item (1 KPI)
Company - Qty On Hand, On PO, On SO and Net Today: Whse (1 KPI)
Company - Qty On Hand, On PO, On SO and Net Today: Whse and Item (1 KPI)
Company - Qty On Hand, On PO, On SO and Net Today: Whse and Item Cat (1 KPI)
Company - Qty On Hand, On PO, On SO and Net Today: Whse, Item Cat and Item (1 KPI)
Company - Qty On Hand, On SO and Net Today: Core (1 KPI)
Company - Qty On Hand, On SO and Net Today: Item (1 KPI)
Company - Qty On Hand, On SO and Net Today: Item and Whse (1 KPI)
Company - Qty On Hand, On SO and Net Today: Item Cat (1 KPI)
Company - Qty On Hand, On SO and Net Today: Item Cat and Item (1 KPI)
Company - Qty On Hand, On SO and Net Today: Whse (1 KPI)
Company - Qty On Hand, On SO and Net Today: Whse and Item (1 KPI)
Company - Qty On Hand, On SO and Net Today: Whse and Item Cat (1 KPI)
Company - Qty On Hand, On SO and Net Today: Whse, Item Cat and Item (1 KPI)
Item - Cost and Qty On Hand Today: Core (1 KPI)
Item - Cost and Qty On Hand Today: Item Cat (1 KPI)
Item - Cost and Qty On Hand Today: Whse (1 KPI)
Item - Cost and Qty On Hand, On PO and On SO Today: Core (1 KPI)
Item - Cost and Qty On Hand, On PO and On SO Today: Item Cat (1 KPI)
Item - Cost and Qty On Hand, On PO and On SO Today: Whse (1 KPI)
Item - Cost On Hand Today: Core (1 KPI)
Item - Cost On Hand Today: Item Cat (1 KPI)
Item - Cost On Hand Today: Whse (1 KPI)
Item - Maximum Net Qty On Hand Today: Core (1 KPI)
Item - Maximum Net Qty On Hand Today: Item Cat (1 KPI)
Item - Maximum Net Qty On Hand Today: Whse (1 KPI)
Item - Maximum Qty On Hand Today: Core (1 KPI)
Item - Maximum Qty On Hand Today: Item Cat (1 KPI)
Item - Maximum Qty On Hand Today: Whse (1 KPI)
Item - Minimum Cost On Hand Today: Core (1 KPI)
Item - Minimum Cost On Hand Today: Item Cat (1 KPI)
Item - Minimum Cost On Hand Today: Whse (1 KPI)
Item - Minimum Qty On Hand Today: Core (1 KPI)
Item - Minimum Qty On Hand Today: Item Cat (1 KPI)
Item - Minimum Qty On Hand Today: Whse (1 KPI)
Item - Qty On Hand Today: Core (1 KPI): This report template has one KPI: 1) A grid with the total and individual Qty On Hand Today by Item ordered alphabetically.

Item - Qty On Hand Today: Item Cat (1 KPI)
Item - Qty On Hand Today: Whse (1 KPI): This report template has one KPI: 1) A grid with the total and individual Qty On Hand Today by Item and Whse ordered alphabetically.

Item - Qty On Hand, On PO and On SO Today: Core (1 KPI)
Item - Qty On Hand, On PO and On SO Today: Item Cat (1 KPI)
Item - Qty On Hand, On PO and On SO Today: Whse (1 KPI)
Item - Qty On Hand, On PO, On SO and Net Today: Core (1 KPI)
Item - Qty On Hand, On PO, On SO and Net Today: Item Cat (1 KPI)
Item - Qty On Hand, On PO, On SO and Net Today: Whse (1 KPI)
Item - Qty On Hand, On SO and Net Today: Core (1 KPI)
Item - Qty On Hand, On SO and Net Today: Item Cat (1 KPI)
Item - Qty On Hand, On SO and Net Today: Whse (1 KPI)
Item Cat - Cost and Qty On Hand Today: Core (1 KPI)
Item Cat - Cost and Qty On Hand Today: Item (1 KPI)
Item Cat - Cost and Qty On Hand Today: Item and Whse (1 KPI)
Item Cat - Cost and Qty On Hand Today: Whse (1 KPI)
Item Cat - Cost and Qty On Hand, On PO and On SO Today: Core (1 KPI)
Item Cat - Cost and Qty On Hand, On PO and On SO Today: Item (1 KPI)
Item Cat - Cost and Qty On Hand, On PO and On SO Today: Item and Whse (1 KPI)
Item Cat - Cost and Qty On Hand, On PO and On SO Today: Whse (1 KPI)
Item Cat - Cost On Hand Today: Core (1 KPI)
Item Cat - Cost On Hand Today: Item (1 KPI)
Item Cat - Cost On Hand Today: Item and Whse (1 KPI)
Item Cat - Cost On Hand Today: Whse (1 KPI)
Item Cat - Maximum Net Qty On Hand Today: Core (1 KPI)
Item Cat - Maximum Net Qty On Hand Today: Item (1 KPI)
Item Cat - Maximum Net Qty On Hand Today: Item and Whse (1 KPI)
Item Cat - Maximum Net Qty On Hand Today: Whse (1 KPI)
Item Cat - Maximum Qty On Hand Today: Core (1 KPI)
Item Cat - Maximum Qty On Hand Today: Item (1 KPI)
Item Cat - Maximum Qty On Hand Today: Item and Whse (1 KPI)
Item Cat - Maximum Qty On Hand Today: Whse (1 KPI)
Item Cat - Minimum Cost On Hand Today: Core (1 KPI)
Item Cat - Minimum Cost On Hand Today: Item (1 KPI)
Item Cat - Minimum Cost On Hand Today: Item and Whse (1 KPI)
Item Cat - Minimum Cost On Hand Today: Whse (1 KPI)
Item Cat - Minimum Qty On Hand Today: Core (1 KPI)
Item Cat - Minimum Qty On Hand Today: Item (1 KPI)
Item Cat - Minimum Qty On Hand Today: Item and Whse (1 KPI)
Item Cat - Minimum Qty On Hand Today: Whse (1 KPI)
Item Cat - Qty On Hand Today: Core (1 KPI)
Item Cat - Qty On Hand Today: Item (1 KPI)
Item Cat - Qty On Hand Today: Item and Whse (1 KPI)
Item Cat - Qty On Hand Today: Whse (1 KPI)
Item Cat - Qty On Hand, On PO and On SO Today: Core (1 KPI)
Item Cat - Qty On Hand, On PO and On SO Today: Item (1 KPI)
Item Cat - Qty On Hand, On PO and On SO Today: Item and Whse (1 KPI)
Item Cat - Qty On Hand, On PO and On SO Today: Whse (1 KPI)
Item Cat - Qty On Hand, On PO, On SO and Net Today: Core (1 KPI)
Item Cat - Qty On Hand, On PO, On SO and Net Today: Item (1 KPI)
Item Cat - Qty On Hand, On PO, On SO and Net Today: Item and Whse (1 KPI)
Item Cat - Qty On Hand, On PO, On SO and Net Today: Whse (1 KPI)
Item Cat - Qty On Hand, On SO and Net Today: Core (1 KPI)
Item Cat - Qty On Hand, On SO and Net Today: Item (1 KPI)
Item Cat - Qty On Hand, On SO and Net Today: Item and Whse (1 KPI)
Item Cat - Qty On Hand, On SO and Net Today: Whse (1 KPI)
QA - QA IN On Hand Today: Company (1 KPI)
QA - QA IN On Hand Today: Item (1 KPI)
QA - QA IN On Hand Today: Whse (1 KPI)
QA - QA IN On Hand Today Multicurrency: Company (1 KPI)
QA - QA IN On Hand Today Multicurrency: Item (1 KPI)
QA - QA IN On Hand Today Multicurrency: Whse (1 KPI)
Whse - Cost and Qty On Hand Today: Core (1 KPI)
Whse - Cost and Qty On Hand Today: Item (1 KPI)
Whse - Cost and Qty On Hand Today: Item Cat (1 KPI)
Whse - Cost and Qty On Hand Today: Item Cat and Item (1 KPI)
Whse - Cost and Qty On Hand, On PO and On SO Today: Core (1 KPI)
Whse - Cost and Qty On Hand, On PO and On SO Today: Item (1 KPI)
Whse - Cost and Qty On Hand, On PO and On SO Today: Item Cat (1 KPI)
Whse - Cost and Qty On Hand, On PO and On SO Today: Item Cat and Item (1 KPI)
Whse - Cost On Hand Today: Core (1 KPI)
Whse - Cost On Hand Today: Item (1 KPI)
Whse - Cost On Hand Today: Item Cat (1 KPI)
Whse - Cost On Hand Today: Item Cat and Item (1 KPI)
Whse - Maximum Net Qty On Hand Today: Core (1 KPI)
Whse - Maximum Net Qty On Hand Today: Item (1 KPI)
Whse - Maximum Net Qty On Hand Today: Item Cat (1 KPI)
Whse - Maximum Net Qty On Hand Today: Item Cat and Item (1 KPI)
Whse - Maximum Qty On Hand Today: Core (1 KPI)
Whse - Maximum Qty On Hand Today: Item (1 KPI)
Whse - Maximum Qty On Hand Today: Item Cat (1 KPI)
Whse - Maximum Qty On Hand Today: Item Cat and Item (1 KPI)
Whse - Minimum Cost On Hand Today: Core (1 KPI)
Whse - Minimum Cost On Hand Today: Item (1 KPI)
Whse - Minimum Cost On Hand Today: Item Cat (1 KPI)
Whse - Minimum Cost On Hand Today: Item Cat and Item (1 KPI)
Whse - Minimum Qty On Hand Today: Core (1 KPI)
Whse - Minimum Qty On Hand Today: Item (1 KPI)
Whse - Minimum Qty On Hand Today: Item Cat (1 KPI)
Whse - Minimum Qty On Hand Today: Item Cat and Item (1 KPI)
Whse - Qty On Hand Today: Core (1 KPI)
Whse - Qty On Hand Today: Item (1 KPI)
Whse - Qty On Hand Today: Item Cat (1 KPI)
Whse - Qty On Hand Today: Item Cat and Item (1 KPI)
Whse - Qty On Hand, On PO and On SO Today: Core (1 KPI)
Whse - Qty On Hand, On PO and On SO Today: Item (1 KPI)
Whse - Qty On Hand, On PO and On SO Today: Item Cat (1 KPI)
Whse - Qty On Hand, On PO and On SO Today: Item Cat and Item (1 KPI)
Whse - Qty On Hand, On PO, On SO and Net Today: Core (1 KPI)
Whse - Qty On Hand, On PO, On SO and Net Today: Item (1 KPI)
Whse - Qty On Hand, On PO, On SO and Net Today: Item Cat (1 KPI)
Whse - Qty On Hand, On PO, On SO and Net Today: Item Cat and Item (1 KPI)
Whse - Qty On Hand, On SO and Net Today: Core (1 KPI)
Whse - Qty On Hand, On SO and Net Today: Item (1 KPI)
Whse - Qty On Hand, On SO and Net Today: Item Cat (1 KPI)
Whse - Qty On Hand, On SO and Net Today: Item Cat and Item (1 KPI)

Data Source

Data Sources allow users to easily and quickly do ad hoc analysis and customize reports, dashboards, and stories. This properly deployed Data Source will contain data from your inventory management system (e.g., ERP and/or Excel/CSV files) refreshed on a schedule (e.g., every night, hour, or minute).

A Tableau Data Source (tds or tdsx file) contains data and a data model that prepares your raw data for powerful reporting. Data Sources include dimensions, hierarchies, measures, and parameters that can be used in reporting. Data sources (tdx or tdsx files ) data come from source system’s tables (e.g., Item table from your ERP) and is modeled via Tableau Creator (Tableau Desktop and/or Prep).

Subject to change without notice. The actual templates can be slightly different than the documented ones.