![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/12\/dim0-min.jpg\")
<\/p>\nThe DIMIX function is a helpful function that can be used in TurboIntegrator (TI) processes and TM1 rules. Simply put, the function will return the index number of an element within a dimension. If the element does not exist in the dimension, the function will return with a 0.<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
The first argument in the function should reference the dimension you are working with, and the second argument is the element that is being checked.<\/p>\n
In most contexts, this function will be used to be check whether an element exists in a dimension and the result can be used to set conditions for further logic.<\/p>\n
This article will review a few of the most common ways DIMIX can be used, but there are many more uses cases beyond what is covered here.<\/p>\n
Parameter Validation<\/strong><\/p>\n <\/p>\n <\/p>\n <\/p>\n <\/p>\n The code above is an example of a validation check against bad parameter inputs from within a TI process. pYear represents the parameter we are checking (e.g. 2009). DIMIX is being used to make sure the input (pYear) exists within the dimension called \u201cFiscal_Year\u201d.\u00a0 \u00a0If the input parameter value does not exist within the dimension, the result will return \u201c0\u201d and the remaining code will create an error log and end the process.<\/p>\n Metadata Changes<\/strong><\/p>\n <\/p>\n Another common use of DIMIX is to use a TI Process to add a missing element into a dimension if it does not already exist. \u00a0In the above code, the process first checks to see if the element, defined by the variable cStartElem, exists within the dimension, defined by the variable cMeasureDim.\u00a0 If the result is \u201c0\u201d (meaning the element does NOT exist), the process will then insert the element into the dimension. \u00a0This proves useful in the Metadata tab of a TurboIntegrator process to avoid generating errors when loading data.<\/p>\n","protected":false},"excerpt":{"rendered":" The DIMIX function is a helpful function that can be used in TurboIntegrator (TI) processes and TM1 rules. Simply put, the function will return the index number of an element within a dimension. If the element does not exist in the dimension, the function will return with a 0. The first argument in…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[35,36,52],"class_list":["post-3434","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-development","tag-planning-analytics","tag-planning-analytics-development"],"acf":[],"yoast_head":"\n![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/12\/DIM1-min.jpg\")
<\/strong><\/p>\n![\"\"](\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2020\/12\/Dim2-min.jpg\")
<\/strong><\/p>\n