Opening the Litmus Production Record Data Model Configurator

to create a data model in litmus production record database using the litmus production record data model configurator, the user will create the hierarchy inside the configurators sheets first before uploading it directly to the database as the solutions is designed to ideally publish the data model directly to litmus production record database, it is recommended to make sure that access to the sql server running the le productionrecord database exists for cases where users may not have direct connection to the sql server, the solution also has an offline mode in the offline mode the solution will create a sql file, which can be executed later through for example sql management studio when opening the file litmus production record data model configurator v1 0 0 xlsm , the user is typically asked to enable vba macros some organizations do by default not trust any custom code for ms excel therefore the solution might display in this case, close the solution and navigate to the files location and open its properties window in the general tab check the unblock checkbox and apply the change now open the file again and it should allow the user to enable the use of macros the solution will start the user always in the instructions sheet in case a sql server is defined in the sheet configurations the application can show a prompt to request a sql authenticated login user and password to verify if the sql server is reachable and the database le productionrecord does exist