From the Blog
IBM Big Data Hub Blog
    Feed has no items.
TM1 Tutorials
  • DAY TM1 Function: How to Use, Syntax and Example
    by John on September 13, 2021 at 1:29 am

    The TM1 DAY function extracts the Day of Month number from a string based date. For example, DAY ('21-09-18') will return the number 18.

  • DimensionDestroy: How to Delete a Dimension in TM1
    by John on September 3, 2021 at 5:50 am

    Sometimes we want to just delete a dimension from TM1. We get lots of failed searches on our site for DimensionDelete – but unfortunately that doesn’t exist. IBM, in their wisdom, have called the function DimensionDestroy, rather than the logical DimensionDelete. Syntax of DimensionDestroy The syntax is very easy: DimensionDestroy(DimName); Where DimName is the name…

  • How to Install or Upgrade Planning Analytics for Excel Add-in up until 2.0.64
    by John on August 3, 2021 at 4:15 am

    Updated for PAX 2.0.63. How to install or upgrade IBM Planning Analytics for Excel (PAX) onto a users PC. Detailed instructions with screenshots and warnings about keeping PAX, PAW and PA versions up to date.