When porting an Excel spread sheet into TM1 Contributor/ Planner, the format of string and number will display differently from in the Excel. This is due to the string measurement algorithm that TM1 uses when it converts an Excel spreadsheet into web format. Within the web.config file look for the following section.
The StringMeasurement parameter is set to 3 by default. Changing it to 0 (legacy mode) may help a bit but may not completely resolve the issue. Regardless of which mode is chosen, the column width needs to be adjusted in order to get an expected display format.
Here are the comparisons between the new mode (‘3’) and legacy mode (‘0’) in Contributor / Planner for a string and number:
QMetrix is named Winner of the 2024 Adaptive Planning Partner of the Year Award – APJ at the annual Workday Sales Kickoff. QMetrix announced it was named a winner of the 2024 Adaptive Planning Partner of the Year Award – APJ by Workday, Inc. (NASDAQ: WDAY), a leading provider of solutions to help organisations manage
QMetrix is a Platinum Solution Provider with Workday Adaptive Planning – one of only three in the APJ region. It is the highest level of partnership Workday offers.
From Features to Functionality and Cost: A Comprehensive Guide to Selecting the Right Financial Planning and Analysis Solution You might have heard of Anaplan, Board, Workday Adaptive Planning, TM1, IBM Planning Analytics, Oracle and Planful. These are tools that aid Financial Planning and Analysis (FP&A). They have the potential to elevate your financial planning, budgeting,
