{"id":4126,"date":"2020-07-24T14:56:00","date_gmt":"2020-07-24T14:56:00","guid":{"rendered":"http:\/\/forquestsolutions.com\/?p=4126"},"modified":"2026-03-30T13:52:49","modified_gmt":"2026-03-30T13:52:49","slug":"sorting-a-planning-analytics-tm1-dimension-by-its-alias","status":"publish","type":"post","link":"https:\/\/forquestsolutions.com\/staging\/7345\/sorting-a-planning-analytics-tm1-dimension-by-its-alias\/","title":{"rendered":"Sorting a Planning Analytics (TM1) Dimension by it\u2019s Alias"},"content":{"rendered":"

There is often the need to reorganize a large dimension\u2019s order of presentation to a more meaningful view. Elements are typically loaded in order of that presented from a source file and based on the principal element name. The resulting order is not always in the order desired by business users.<\/p>\n

Having been presented the requirement to sort a ragged dimension consisting of over 2 million elements and composed of 10+ element levels, we have designed a solution that not only sorts the required dimension but allows any given dimension to be sorted by its alias name (i.e. Caption).<\/p>\n

Our solution applies 3 Turbo Integrator processes to sort an existing dimension. The following TI\u2019s were defined:
\n1. META Sort Subset<\/strong> \u2013 This TI creates an MDX subset based on the dimension entered. The MDX coding includes sorting by the dimension\u2019s caption. The subset is then reviewed within the META tab and inserted to a ASCII Output file in the appropriate order. The TI calls a second TI detailed below.
\n2. META Sort Subset \u2013 Call<\/strong> \u2013 This TI reads the ASCII Output file from #2 above and creates a static subset in the source dimension originally used. The static subset retains the order of the MDX subset results.
\n3. META Sort Dimension<\/strong> \u2013 This TI specifies a source dimension to be sorted based on the static subset created in #2 above. The Prolog section specifies the dimension to be sorted by \u2018Input\u2019. The ASCII Output file created in #2 is then reviewed within the META tab and each element re-inserted based on the order of the file. The Epilogue tab re-establishes the order of the hierarchy by name.<\/p>\n

\"\"<\/p>\n

TM1 Dimension Sort.zip<\/a><\/p>\n

Download the \u201cTM1 Dimension Sort.zip\u201d file above that contains the 3 Turbo Integrator files. And using this solution will allow a dimension to be sorted alpha-numerically within multiple levels.<\/p>\n","protected":false},"excerpt":{"rendered":"

There is often the need to reorganize a large dimension\u2019s order of presentation to a more meaningful view. Elements are typically loaded in order of that presented from a source file and based on the principal element name. The resulting order is not always in the order desired by business users.<\/p>\n","protected":false},"author":16,"featured_media":9704,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"nf_dc_page":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[111],"tags":[61,63,65,64],"class_list":["post-4126","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ibm-planning-analytics","tag-ibm","tag-planning-analytics-2","tag-sorting","tag-tm1-2"],"_links":{"self":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/posts\/4126","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/users\/16"}],"replies":[{"embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/comments?post=4126"}],"version-history":[{"count":22,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/posts\/4126\/revisions"}],"predecessor-version":[{"id":9705,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/posts\/4126\/revisions\/9705"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/media\/9704"}],"wp:attachment":[{"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/media?parent=4126"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/categories?post=4126"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/forquestsolutions.com\/staging\/7345\/wp-json\/wp\/v2\/tags?post=4126"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}