Configuring Products¶

Prerequisite¶

To enable proper Performance KPI calculations, refer to section Products & Design Speed in the OEE Basics chapter.

Before configuring "Product Collections" & "Products", it is important to understand the basic concepts from section Products & Design Speed.

With product collections, you can create groups of products that you can later assign to a specific machine or line asset. This is helpful if you are running the same products on different lines but with different design speeds. For example, if you are having twice the same equipment, one can produce the same product at a faster rate. In this section, you will learn how to set up collections and subsequent products.

User interface¶

The user interface of "Products" is as shown below:

① Navigates to the "Configuration" tab
② Opens a new screen to add or edit or delete a product unit
③ Imports a new "Product Collection"
④ Adds a new "Product Collection"
⑤ Edits the existing "Product Collection"
⑥ Exports the selected product collection
⑦ Deletes the existing “Product Collection”
⑧ Navigates to the next step
⑧ Displays the current step
⑨ Navigates to the previous step

Procedure¶

To create a new product collection, proceed as follows:

1. From the navigation tab, click "Configuration" and select "Products".
   
2. In "Products", click "Add Product Collection". A new page is displayed.
   
3. Add "Name" and "Description" for the product collection. After entering this data, the product collection is auto-saved and you can start to add products.
   
4. Click "Add Product" to add a new product. A new page will be displayed. The page offers two options, products can be added either with a Design Speed or Cycle Time.
   

5. Enter "Name", "Description", select "Type" and enter "Design Speed" or "Cycle Time", "Unit", "Time interval" and "Product Code".
   Given below is an example scenario:

   • Name: Orange Lemonade 1L
   • Description: Orange Lemonade 1L
   • Type: Speed
   • Design Speed: 6500.00
   • Unit: Pcs
   • Time interval: per Hour
   • Product Code: OL1L
     

   Input Field	Data type or Units
   Name	STRING
   Design Speed	INT or DOUBLE
   Unit	String (for example, kg, pcs, etc.)
   Time Interval	HOUR, MINUTE or SECOND
   Product Code	STRING or INT

6. After adding the product information, click "Back to Product Collection" button to get back to the collection. The newly created product as a list item in the product collection.

The product collection list shows all the individual products created in the collection and showing the following information for each product:

• Name
• Description
• Code
• Design Speed
  

The product collection also features a search bar, so that you can filter the list for the desired product.

Excel Import and Export¶

For product collections, Insights Hub OEE also features an excel import and export to speed up the configuration of multiple products for different machines and lines. To import a product collection, Insights Hub OEE requires an excel template that needs to be filled in properly by the user. The template will be described in the following sections.

Excel Template Description¶

The template creation for a product collection is straightforward. As a first step, you need to create the following columns:

• Name
• Description
• Design Speed
• Unit
• Time Interval
• Product Code
• Speed Type
  

After creation, the template will look like the following graphic:

Now, for every product that you want to set up, you need to create a single row in the excel template. In the example above, already three products are created with the different design speeds. For the individual columns some constraints apply:

• Name: The name must start with a character, followed by characters, digit, hyphen, underscore, dot, comma or white space. The maximum length is 50.
• Description: The description must start with a character, followed by characters, digits or any of _ - , . ; : ! " ' § $ % / ( ) @ + *. The maximum length is 50.
• Design Speed: The design speed must be a positive number (Double or INT).
• Unit: The unit must start with a character, followed by characters, digit, hyphen, underscore, dot, comma or white space. The maximum length is 10.
• Time Interval: The time interval must be either HOUR, MINUTE or SECOND.
• Product Code: The product code is of the datatype string and must have a length between 1 – 64 characters.
• Speed Type: Enter "SPEED" for Design Speed or "CYCLE_TIME" for Cycle Time.
  

After the completion of your product collection, save the file as an .xlsx file to the desired ___location.

Import Wizard¶

The following section describes the steps to import a product collection in Insights Hub OEE. To start the import, navigate to the configuration by clicking the gear icon in the navigation bar on the left side. Then, select the "Products" to reach the import wizard.

In the upper right corner, click the "Import button". The import wizard will be displayed.

Enter the product collection name and description. Click next at the bottom of the wizard to proceed to the next step.

In this screen, click the "Upload" button. Another pop-up will be displayed that which allows you to select a file. Select a file of the type .xlsx.

Once you selected the file, click next and the file is being uploaded and analyzed by Insights Hub OEE. The last screen will show you some details of the identified products in a table view.

If warnings or errors are detected, e.g., your template does not provide the mandatory header cells, they will also be shown on the last page of the import wizard. Then, you have the chance to fix issues in the file and go back to the second step and to reselect the file again. In case of errors, you can not start the import. To finalize the import, click the "Import" button.

Export of a Product Collection¶

To export a product collection, click "Product overview" page. On each existing product collection, you can find three different icons to manage the item, edit, export and delete. Click "Download" button to export the product collection. It will automatically be saved as an .xlsx file to your default download folder on your system.