Follow these steps to seamlessly add a new parameter to your data model:<\/p>\n\n\n\n
1. Access Data Models and Views:<\/strong><\/p>\n\n\n\n – Start by navigating to the Data Models and Views tab within SEI.<\/p>\n\n\n Figure.1. Manage Data Model Parameters<\/p>\n\n\n\n 2. Manage Data Model Parameters:<\/strong><\/p>\n\n\n\n – Right-click on the specific Data Model where you wish to add the parameter.<\/p>\n\n\n\n – From the context menu, select “Manage Data Model Parameters.”<\/p>\n\n\n\n 3. Initiate Parameter Addition:<\/strong><\/p>\n\n\n\n – Click on the “+” icon to begin defining a new parameter.<\/p>\n\n\n\n 4. Parameter Details:<\/strong><\/p>\n\n\n\n – Name: Enter a descriptive name for your parameter.<\/p>\n\n\n\n – Description: Optionally, provide additional context for clarity.<\/p>\n\n\n\n – Translation: If needed, add translations by clicking on the language icon.<\/p>\n\n\n\n – Value: Choose an appropriate global variable from the dropdown list.<\/p>\n\n\n\n – Global Parameters: Select a parameter from the available list, if applicable.<\/p>\n\n\n\n – Once details are set, click “Confirm” to proceed.<\/p>\n\n\n\n Let\u2019s illustrate the process with an example:<\/strong><\/p>\n\n\n\n – Suppose you need to add a “Month” parameter that dynamically fetches the current month’s value. By selecting the @@UDM_CURMONTH global variable, SEI automatically generates this dynamic variable. You can then utilize this parameter seamlessly within the SQL Scripts Builder found in the Design Data Model window.<\/p>\n\n\n Figure.2. Month Parameter<\/p>\n\n\n\n Setting Parameters for Use<\/strong><\/p>\n\n\n\n After defining parameters, follow these steps to apply them effectively:<\/p>\n\n\n\n 1. Opening a Worksheet:<\/strong><\/p>\n\n\n\n – Right-click on the Data Model associated with your parameter.<\/p>\n\n\n\n – Select “Set Data Model Parameters.”<\/p>\n\n\n\n 2. Confirmation:<\/strong><\/p>\n\n\n\n – Confirm your parameter settings to finalize the setup.<\/p>\n\n\n Figure.3. Setting Parameters<\/p>\n\n\n\n 3. Handling Defaults:<\/strong><\/p>\n\n\n\n – If necessary, opt to “Skip” values in the Data Model Parameters window during setup.<\/p>\n\n\n\n This blog post aims to provide a comprehensive guide on integrating Data Model Parameters within Sage Enterprise Intelligence. By following these steps, you can enhance your scripting capabilities and streamline data management processes effectively.<\/p>\n\n\n\n <\/p>\n","protected":false},"excerpt":{"rendered":" In Sage Enterprise Intelligence (SEI), Data Model Parameters serve as dynamic variables essential for scripting and enhancing flexibility within your data management processes. Whether you’re customizing reports or fine-tuning queries, understanding how to integrate these parameters can significantly streamline your workflow. Step-by-Step Guide to Adding a New Parameter Follow these steps to seamlessly add a\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,3,4,5,3162,6,13,7,8,3642,9,10,2796,11,12],"tags":[4295,4294,4296,1780,1822,1839,2871,1945,3624],"class_list":["post-30013","post","type-post","status-publish","format-standard","hentry","category-configuration","category-debug","category-faq","category-features","category-greytrix","category-installation","category-integration","category-miscellaneous-tables","category-sage-erp-x3","category-sage-x3","category-sage-x3-consulting","category-standard","category-technical","category-tips","category-sage-x3-upgrade","tag-adding-a-data-model-parameter-in-sei","tag-adding-parameter","tag-adding-parameter-in-data-model","tag-sage-erp-x3","tag-sage-x3","tag-sage-x3-blogs","tag-sage-x3-functional-blogs","tag-sage-x3-technical-blogs","tag-sei"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30013","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=30013"}],"version-history":[{"count":2,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30013\/revisions"}],"predecessor-version":[{"id":30018,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/30013\/revisions\/30018"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=30013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=30013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=30013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}![\"\"](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/09\/Fig.1.-Manage-Data-Model-Parameters.png\")
<\/figure><\/div>\n\n\n![\"\"](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/09\/Fig.2.-Month-Parameter.png\")
<\/figure><\/div>\n\n\n![\"\"](\"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-content\/uploads\/2024\/09\/Fig.3.-Setting-Parameters.png\")
<\/figure><\/div>\n\n\n