- Bookmark
- Share
- Documentation
- prev
- next
Objective
This solution aims to allow customers to create Data Model configurations for Litmus Production Record Database using Microsoft Excel.
Using Microsoft Excel allows users to make use of all the functionality they are comfortable with and know from MS Excel to quickly fill in large numbers of rows and columns.
Further does it allow to make use if the capability to run MS Excel Macros for automation and creating a better customer experience.
The solution makes use of the Litmus Production Record Database inbuild function for adding and modifying a data model.
Example Use Case
Litmus Production Record Data Model Configurator is used to create Data Models for Litmus Production Record Database.
A Data Model makes it possible to store production record data to Litmus Production Record Database.
There they can used for a wide range of purposes such as using them to record data for a production record event such as:
-
- Downtime Events
- Production Traceability Events
- Maintenance or Turnaround
- work processes or steps
- Alarms and events
- Quality Events
Production Record Event data recorded by Litmus Production Record Database can be used for visualization and analytics such as SPC charts.
Basic Attributes
-
Solution Versionv1.0.0
-
Relevant Non Litmus SoftwareMicrosoft Excel
-
Approximate Size1MB
-
Technologies usedExcel VBA
-
Skill LevelAdvanced
Product Category
Knowledge Prerequisites
Litmus Production Record Data Model Configurator is a supporting solution to Litmus Production Record Database.
To successful make use if this solution, users will need to have a base understanding of the Concepts behind Litmus Production Record Database such as the data model configuration used to store and process event data inside Litmus Production Record Database.
Installation Guide
How to deploy Litmus Production Record Data Model Configurator
This section will provide instructions on how to deploy Litmus Production Record Data Model Configurator.
Requirements
- Litmus Production Record Database is installed
- A SQL Authentication User and password is available
- The SQL Server is reachable via its IP / the IP for the SQL Server is known
- Microsoft Excel capable of executing macros
Please check out the Documentation Portal.
Additional Information
Documentation for this solution are available on the Solutions documentation page.
Version Information
-
Solution Version