2. Defining the Data Model Name and number of Hierarchy Levels

the main purpose of the sheet nodeoptions , is to define the name of the data model as well as the number of hierarchy levels of the data model naming the data model the name of the data model is provided through the cell labeled node name the configurator will verify the node name for invalid ascii characters to learn more about which ascii characters are allowed, review the section restrictions on ascii characters allowed to be used the configurator also validates the length of the string invalid ascii characters if an invalid character is found, a prompt is shown to the user invalid characters are marked in red as spaces are not a visible character, they can't be marked in red, so the user can make use of the comment added to the cell as well invalid string length to allow for the most efficient storage of the configuration as well as practicality when using a node name in a query, the maximum length of a node name can not exceed 50 characters if a node name is longer 50 characters, the user will be prompted note node names which exceed the 50 character limit, will by default be trimmed to 50 characters if no action is taken by the user node description (optional) users are able to add a description for the data model this can be used to provide some context for colleagues as to what the purpose of the data model is the configurator will verify the node description for invalid ascii characters to learn more about which ascii characters are allowed, review the section restrictions on ascii characters allowed to be used the configurator also validates the length of the string invalid ascii characters if an invalid character is found, a prompt is shown to the user invalid characters are marked in red invalid string length to allow for the most efficient storage the maximum length of a node description can not exceed 256 characters if a node description is longer 256 characters, the user will be prompted note node descriptions which exceed the 256 character limit, will by default be trimmed to 256 characters if no action is taken by the user defining the number of hierarchy levels complex data model hierarchies will typically include different hierarchy levels example for a data model with a 2 level hierarchy therefore the user has to define how many hierarchy levels the data model will have, by setting the respective option for the cells labeled with has level x (optional) to the value yes in this example, the user wants to have two sub levels tip if you a user wants to have for example 4 sub levels, they only need to set the cell labeled "has level4 (optional)" to the value yes this will also set all cells above to yes for more information on the concept of sub levels, please review the chapter core concept behind recording production record data via data model docid\ ffsctesqgb9gj7wy5kymo reading back a data model if a user wants to modify an existing data model defined already on litmus production record database, they are able to modify this data model using the configurator this is supported by the ability, to readback a data model hierarchy from litmus production record database into the configurator, and making them available in the respective sheets this does require, that an active connection between the configurator and sql server exists and that the database le productionrecord is defined with the desired data model inside to read back a data model hierarchy, enter the data model name into the cell labeled node name press the button read node configuration the user can be prompted multiple times to provide the sql authenticated login user name and password the progress will be shown by a progress bar after retrieving the data model hierarchy, the values are written into the respective sheets example for the sheet nodeoptions after reading back a data model example for the sheet nodestructure after reading back a data model example for the sheet items after reading back a data model