wimgielis.com

TM1 articles

• Nov. 11, 2024

Introduction

Here is the exhaustive overview of all articles to date.

TM1 articles, in chronological order

All articles:

• November 2024
• Creating a .tar.gz or .tgz double zipped file (General) New
• Unzipping a .tar.gz or .tgz double zipped file (General) New


• October 2024
• Copy Word text to a new email (General) New


• September 2024
• IBM PAW and TM1 user counts, subscriptions and roles


• July 2023
• MDX statements (Dimensions)


• September 2022
• Do elements exist in a hierarchy ? (Subset Editor)
• Delete elements quickly (TI)


• October 2021
• Document processes and rules (TI, rules)


• September 2021
• Counting input cells (TI)


• January 2021
• Spot duplicates in a hierarchy to avoid circular references (Excel)


• November 2020
• Replace Trump for Biden (Turbo Integrator)
• Service status (PowerShell)


• July 2020
• Update process line numbers with AutoHotKey (AutoHotKey)


• April 2020
• Selecting elements in the Subset Editor quickly (Subset Editor)


• March 2020
• Using LogOutput in a condensed way (Server)


• October 2019
• Set up a TM1 model as a service or an application in AutoHotKey (Server)


• April 2019
• Active form claustrophobia (Active forms)


• March 2019
• Access to cube cells in TM1 (Cells)


• December 2018
• Turbo Integrator: report progress (TI)
• Clearing big chunks of cube data (TI)


• March 2018
• Looping over input files (TI)


• October 2017
• Delete a cube and its dimensions (Cubes)


• July 2017
• TM1 Message log analysis with Power Query (General)


• May 2017
• Double counting elements (TI)


• November 2016
• AsciiOutput to Excel (TI)


• October 2016
• Cube dimension modifications (TI) ARTICLE NUMBER 100 !
• Find invisible characters (TI)
• IsUnd function in TM1 (TI)


• August 2016
• I forgot a dimension in my cube ! (TI)
• SubsetCreateByMDX and SubsetMDXSet do not always play nice together (TI)


• April 2016
• Parameters in the tm1p.ini file (general)
• TM1 working days (Rules)


• March 2016
• Remove double quotes in TI (TI)


• December 2015
• Slice out views to Excel in batch (VBA)


• November 2015
• Dates and times in TM1 - without all the hassle (Turbo Integrator)
• Leap years in TM1 (general)


• July 2015
• Year-to-date values in 2 dimensions (Dimensions)


• June 2015
• TM1 and Notepad++ (Code development)
• Subsets with commentary text (Dimensions)
• Anonymizing TM1 (Cube)


• November 2014
• TM1 user interface languages (general)
• Public default cube views (Turbo Integrator)


• October 2014
• One-cell views (Turbo Integrator)


• August 2014
• Reworking the layout in Excel to import dimensions, part I
• Reworking the layout in Excel to import dimensions, part II


• June 2014
• TM1 Break function (TI)


• April 2014
• Relative time dimensions (TI)
• Cube dependencies (TI)
• Element formatting (general)
• Excel shortcuts and TM1 (TI)
• Non-standard element weights (general)


• March 2014
• TM1 and space characters (TI)
• Generate placeholder elements (Excel VBA)


• January 2014
• Action buttons (Excel VBA)
• Numbers and strings (TI coding)
• Attributes in a TM1 model (Dimensions)
• The ItemReject function (TI coding)


• December 2013
• Data-driven zero out procedures over more than 1 dimension (Cubes)
• Data-driven zero out procedures (Cubes)
• Using tables for data input (Cubes, Excel)
• TM1 gotchas (General)


• August 2013
• Clean up the TM1 Message Log (TM1 Server)
• Excel reports: what cubes are used ? (Cubes, Excel)
• Delete a dimension element (Dimensions)
• Neat MDX subset tricks in TI (Dimensions, MDX subsets, TI)


• May 2013
• Subsets that add up (Dimensions)


• April 2013
• Spot double counting issues (TI)


• October 2012
• Daily utilities (general)


• September 2012
• Creating a test cube including rules and data (TI, rules)
• If structures in TM1 (TI, rules)


• June 2012
• Recreating a TM1 dimension after an export (dimension, TI)


• April 2012
• TM1’s REPLACE function for rules and TI (rules, TI, Excel)


• March 2012
• Speed up with TI (Excel)


• February 2012
• Smart copy/paste operations (Excel)
• Data spread and UDC (Cubes)
• Empty alias values (Dimensions)


• January 2012
• TM1 DB to view: finalized material (Miscellaneous)
• TM1 DB to view: updated article (Miscellaneous)
• TM1 DB to view (Miscellaneous)
• Dynamically updated reports (Dimensions)
• TM1 cookbook (Miscellaneous)
• Daily exchange rates (Miscellaneous)


• December 2011
• Solving a performance problem (Miscellaneous)


• October 2011
• Sorting TM1 text output (Miscellaneous)
• Backup TI source files (Miscellaneous)
• List TI processes (Documentation)
• TM1 backup (Miscellaneous)


• September 2011
• Documenting TM1 cubes (Documentation)


• July 2011
• Run TM1 as an application (Miscellaneous)
• TM1 Services (Miscellaneous)


• June 2011
• Executing a TI process from command line (Miscellaneous)
• Dynamic TI queries (Miscellaneous)


• March 2011
• An alternative way to clear cube data (ZeroOut procedures)
• TM1 API: Connecting and disconnecting a user (TM1 API coding)


• February 2011
• Looping through files (Miscellaneous)
• Merging multiple dimensions (Miscellaneous)


• May 2010
• Year-to-date rollups (Dimensions)


• April 2010
• Visual performance signals (Page I, II) (Miscellaneous)
• Comparing data directories (Excel related)
• Indenting TI processes (Miscellaneous)
• Counting element instances (Miscellaneous)
• Debugging Turbo Integrator processes (Miscellaneous)
• Deleting cubes and dimensions safely (Dimensions)
• Change the TI source file for non-admin users (Miscellaneous)
• Random data in a cube (Page I, II) (Miscellaneous)


• February 2010
• Headers in a text file (Miscellaneous)
• Writing CELLPUT statements (Miscellaneous)
• Clear an entire cube (ZeroOut procedures)
• Write my ZeroOut code! (ZeroOut procedures)
• Delete a consolidated element and all of its children (Dimensions)
• Delete TM1 objects (Miscellaneous)
• Dimension usage (Dimensions)
• Copy all data from one element to another (ZeroOut procedures)
• Avoid copying code (Miscellaneous)
• Clean up TM1 clients and groups (Miscellaneous)
• Copy data to a cube viewer (Excel related)
• Duplicate a dimension (Dimensions)
• Execute a temporary batch file (Miscellaneous)
• Rule area definitions made clear (Rules)
• Using single quotes in variables (Miscellaneous)
• Which cubes use a certain dimension? (Dimensions)
• Create a custom view and zero out it (ZeroOut procedures)
• Clear the data in an existing view (ZeroOut procedures)
• Clear multiple cubes (ZeroOut procedures)