biGENIUS provides default values for singleton
These are configured in the table RC.SingletonValue
Easiest way to modify the values is to create a script for updating these values
Disadvantage: you should execute this script each time you need to deploy again the script 080_Configure.sql
Export the templates
Exported template GS > TemplateExtensionSql.sql: replace the default values by the needed values between lines 878 and 996
This way is not fully recommended because each factory template update add complexity in case of future biGENIUS version migration.
There is now an easier way to change the default singletons value. All templates in the GS / General Settings section can simply be duplicated and linked. Even if they are used in includes in other templates, these includes call the name of the Dwh Part and not anymore the name of the template. So it’s better to duplicate the template rather than using a template export/import which will overwrite the factory template and cause potential complications during a generator version migration. The documentation article on Zendesk is already updated in this sense.
Watch the Live Demo now: