Download Your Free 30-Day Trial!

Version 5 Beta Coming Soon

A new version of TM1Compare will be coming out soon and we invite you to participate! This version is focused on optimizing performance for IBM Planning Analytics cloud based systems, but will also dramatically improve on-premise systems as well.

This new version will be OData only (Native TM1 API is no longer supported by IBM) and will only support migrations to IBM Planning Analytics 2.0.5 and greater (although you can still migrate from TM1 v10.2.2 FP5+).

If you wish to participate in this program, please contact us


Version 4.4 Now Available!

Enhancements

  • OData Performance Improvements
    • Comparing and migrating subsets
    • Attribute value migration optimized
    • Better handling of object validation
  • Improved Dimension Member Handling
    • Dimension member migration is now handled via TI process (OData requires too many round trip calls and is too slow)
  • WAN Performance Tuning

    Speed improvement when initially loading server objects using OData. Dimensions, subsets and attributes are now pulled using fewer queries to TM1 which improves performance over WAN or slow connections.

  • Improved Error Reporting

    When an error occurs while using the TM1 REST API, error messages now show the underlying error generated by TM1.

  • Improved Diagnostics

    Improved diagnostic capabilities for OData communication. Added ability to specify a proxy and/or enable detailed tracing for the OData requests and responses.

  • Improved Login to IBM Cloud

    Added support for unattended connecting and authenticating to a Planning Analytics cloud instance.

Bug Fixes

  • OData Issues Fixed

    • Zero suppression settings not being migrated with certain views
    • Subset default aliases not being migrated with views
    • Better handling of object validation
    • When overwriting a subset that is used by a view, error "subsetIsUsedInCube" occurs
    • Extra blank lines in rules cause comparison results to be different
    • Applications do not get copied to the destination server
    • When copying an attribute, maximum configured member limit is being ignored
    • Issues may occur with migrating, comparing and deleting private subsets
  • Migration Issues

    • Subset copy fails when the MDX has a '*' character in it when using OData. Example: {TM1FILTERBYPATTERN( [plan_chart_of_accounts].Members, "Bank Charges")}
    • Errors occur when migrating a subset containing a double-quote character in one of the members.
  • Miscellaneous Issues

    • Intermittent "Index out of range" intermittent exception when loading cubes.
    • "Null reference" error when attempting to access a non-existent cube rule.
    • Attribute string values showing differences whenever they contain a blank space.
    • "Invalid JSON" error being returned whenever a process parameter default value contains the ampersand character.
    • "Invalid DateTimeOffset" error when copying a chore that contains the start date/time in it.
    • “Copy” vs “Overwrite” option not being properly recognized when copying dimension members to the destination server.

Known Issues

  • Process Parameters Are Always String

    Due to a limitation in TM1 10.2.2 REST API, process parameter types are always defaulted to string after migrating to the destination server. This issue can also cause parameter type mismatch issues in chores, where process parameter values are specified.

  • Command-Line Interface In Progress

    Command line interface for creating unattended snapshots is currently in development.

Version 4.3

Enhancements

  • Dramatic performance improvements when migrating attribute values
  • Startup time and the speed of "Load Objects" is now lighting fast!
  • Migrate member weights when using OData
  • Optimized OData communication for better process visibility

Version 4.2

Enhancements

  • Compare and migrate attributes
  • Compare cube dimensionality and dependent objects
  • Compare cube data
  • Integrate with the source control system of your choice
  • Support for the new TM1 REST API

Bug Fixes

  • Improved visual comparisons for dimension hierarchies and elements
  • Improved control over dimension migrations
  • Substantially faster load and comparison times
  • Improved support for CAM authentication

Bug Fixes

  • Default view mappings in the Manager now include hierarchies and attributes.
  • Subset aliases are now used in the batch mode extracts as well as in the live mode.
  • Fixed logic for setting column data types for the published views.
  • Fixed SQL date formatting when using type conversions (e.g. Output will return a date when an SQL query contains clauses such as CONVERT('MyView'.'MyColumn', SQL_DATE).
  • Fixed order of the columns corresponding to the hierarchy attributes, when they are included in a published view.
  • Fixed bug that would cause a SQL query to fail when one of the string columns contained a single quote in the value.
  • Fixed bug in the Manager UI that would lose hierarchy settings for a view after saving and re-opening it.

 © 2019 CarpeDatum Consulting, Inc.

TM1COMPARE IS POWERED BY CARPEDATUM CONSULTING, INC. IBM, COGNOS, TM1 AND THE PREMIER BUSINESS PARTNER EMBLEM ARE TRADEMARKS OR REGISTERED TRADEMARKS OF INTERNATIONAL BUSINESS MACHINES. TABLEAU AND THE TABLEAU PARTNER EMBLEM ARE REGISTERED TRADEMARKS OF TABLEAU SOFTWARE. QLIK AND THE QLIK PARTNER EMBLEM ARE REGISTERED TRADEMARKS OF QLIKTECH INTERNATIONAL. MICROSOFT AND THE MICROSOFT GOLD PARTNER EMBLEM ARE REGISTERED TRADEMARKS OR MICROSOFT CORPORATION.

#KeepServersRunning