Deprecated features and components in TM1 Database 12

These features and components, which might be familiar to Planning Analytics v11 database users, are not supported in TM1 Database 12.

Support for the 'classic' APIs

TM1 Database 12 does not support the C, Java, .Net, and all internal and experimental versions of the REST API. Only the OData compliant REST API is supported for interaction with the TM1 Database 12 database.

Because older APIs are no longer supported, clients such as Architect and Perspective, do not work with TM1 Database 12. Older versions of Planning Analytics for Microsoft Excel do not work with TM1 Database 12, while Planning Analytics for Microsoft Excel versions 2.0.77 and later are fully supported.

Bulk load mode

Bulk load mode enabled Planning Analytics to run in an optimized mode for maximum throughput when little or no other action was expected on the system. Bulk load mode is redundant and obsolete with the introduction of Parallel Interaction and it is not available in TM1 Database 12.

Java-TI

Java-TI, an extension that allowed a TurboIntegrator process developer to call a Java function, is not available in TM1 Database 12.

SSL certificates

TM1 Database 12 does not use SSL certificates. Instead, our containerized deployments use Istio and as such all communication is secured using mutual TLS. The service endpoint, exposed by the Kubernetes environment, is secure as well.

Deprecated TurboIntegrator functions

The following TurboIntegrator functions are not supported in TM1 Database 12:

  • AddInfoCubeRestriction
  • AllowExternalRequests
  • AssignClientPassword
  • AssociateCAMIDToGroup
  • BatchCellIncrement
  • BatchUpdateFinish
  • BatchUpdateFinishWait
  • BatchUpdateStart
  • CGAddPromptValues
  • CGPromptGetNextMember
  • CGPromptSize
  • CreateHierarchyByAttribute
  • CubeDataReservationAcquire
  • CubeDataReservationGet
  • CubeDataReservationGetConflicts
  • CubeDataReservationRelease
  • CubeDataReservationReleaseAll
  • CubeGetLogChanges
  • CubeSaveData
  • CubeSetConnParams
  • CubeSetLogChanges
  • DisableBulkLoadMode
  • EnableBatchCellIncrement
  • EnableBulkLoadMode
  • ExecuteJavaN
  • ExecuteJavaS
  • LockOff LockOn
  • RefreshMDXHierarchy
  • RemoveCAMIDAssociation
  • RemoveCAMIDAssociationFromGroup
  • SaveDataAll ServerShutdown
  • SetChoreVerboseMessages
  • SetOdbcUnicodeInterface
  • SwapAliasWithPrincipalName

Database configuration options

The following database configuration options are not supported in TM1 Database 12:

  • AdminHost
  • AdminSvrSSLCertID
  • AdminSvrSSLCertAuthority
  • AdminSvrSSLCertRevList
  • AdminSvrSSLExportKeyID
  • AllowedInvalidXNLogRecLimit
  • CAMPortalVariableFile
  • CAMSSLCertificate
  • CAMUseSSL
  • CacheFriendlyMalloc
  • CheckCAMClientAlias
  • ClientCAMURI
  • ClientExportSSLSvrCert
  • ClientExportSSLSvrKeyID
  • ClientMessageListenerAcceptsTm1TopConnections
  • ClientMessagePortNumber
  • ClientPingCAMPassport
  • ClientPropertiesSyncInterval
  • ClientVersionMaximum
  • ClientVersionMinimum
  • ClientVersionPrecision
  • CognosTM1InterfacePath
  • CreateNewCAMClients
  • DebugDatabaseLock
  • DefaultMeasuresDimension
  • DHFile-512
  • DHFile-1024
  • DHFile-2048
  • DisableExecuteCommandTI
  • DisableMemoryCache
  • DistributedPlanningOutputDir
  • Downtime
  • EnableBatchCellIncrement
  • EnableODBCProxy
  • EnableNewHierarchyCreation
  • EnableSandboxTransactionLog
  • EncryptData ExcelWebPublishEnabled
  • ExportAdminSvrSSLCert
  • ExportSvrSSLCert
  • HTTPRequestEntityMaxSizeInKB
  • HTTPOriginAllowList
  • HTTPOriginWhitelist
  • HTTPHostUri
  • HTTPPortNumber
  • HTTPSessionTimeoutMinutes
  • IdleConnectionTimeOutSeconds
  • IndexStoreDirectory
  • IntegratedSecurityMode
  • IPAddress IPVersion
  • JavaClassPath
  • JavaJVMPath
  • JavaJVMArgs
  • KeepPrivateSubsetsLoaded
  • LDAPHost
  • LDAPPasswordFile
  • LDAPPasswordKeyFile
  • LDAPPort
  • LDAPSearchBase
  • LDAPSearchField
  • LDAPSkipSSLCertVerification
  • LDAPSkipSSLCRLVerification
  • LDAPUseServerAccount
  • LDAPVerifyCertServerName
  • LDAPVerifyServerSSLCert
  • LDAPWellKnownUserName
  • LicenseMetricTime
  • LicenseMetricProductName
  • LicenseMetricProductVersion
  • LicenseMetricProductReleaseID
  • LoadPrivateSubsetsOnStartup
  • LoadPublicViewsAndSubsetsAtStartup
  • LockPagesInMemory
  • LogReleaseLineCount
  • LogMemoryAllocation
  • MaskUserNameInServerTools
  • MaximumLoginAttempts
  • MaximumSynchAttempts
  • MaxUDCCacheSize
  • MemoryCacheMaxBlockSize
  • MemoryWarningLevelKb
  • MemoryWarningLevelMsg
  • MinBreatherThreadCount
  • MDXAggregateForceSetAlgorithm
  • MDXSelectCalculatedMemberInputs
  • MessageCompression
  • MTQ.EnableParallelFacetQuery
  • NetRecvBlockingWaitLimitSeconds
  • NetRecvMaxClientIOWaitWithinAPIsSeconds
  • NWSapCharacteristicRowcount
  • NWSapCharacteristicMethod
  • NWSapInfoCubeExtractMethod
  • ODBCCatalogName
  • ODBCDataSource
  • ODBCLibraryPath
  • ODBCPassword
  • ODBCUserName
  • OracleErrorForceRowStatus
  • OracleErrorUnicodeDateCharacterWorkaround
  • ParallelInteraction PasswordMinimumLength
  • PasswordSource PerformanceMonitorOn
  • PerfMonIsActive PooledMemoryMaxLimit
  • PooledMemoryWarningThreshold PortNumber
  • ProfileBasedOptimization ProgressMessage
  • PullInvalidationSubsets
  • RawStoreDirectory
  • ReceiveProgressResponseTimeoutSecs
  • RulesOverwriteCellsOnLoad
  • RunningInBackground
  • Savetime SecurityPackageName
  • ServerCAMURI
  • ServerCAMURIRetryAttempts
  • ServerLogging ServerName
  • ServicePrincipalName
  • SkipLoadingAliases
  • SkipSSLCAMHostCheck
  • SliceApprovalDimension
  • SliceCubeThreads
  • SSLCertAuthority
  • SSLCertificate
  • SSLCertificateID
  • SSLCertRevocationFile
  • SSLPrivateKeyPwdFile
  • SSLPwdKeyFile
  • StartupChores
  • SubsetElementBreatherCount
  • SvrSSLExportKeyID
  • SyncUnitSize
  • TM1ConnectorforSAP
  • TrackMemoryPools
  • TransactionLogSearchOptimization
  • UseCognosMDXEngine
  • UseLocalCopiesForPublicDynamicSubsets
  • UseSQLFetch UseSQLFetchScroll
  • UseSQLExtendedFetch
  • UseSSL
  • VersionedListControlDimensions
  • WANProxyHost

Control cubes

The following control cubes are not supported in TM1 Database 12:

  • }ApplicationSecurity - TM1 Database 12 includes a new file content area that is used to store Websheets and other files, such as file data sources for TurboIntegrator processes and file output. In TM1 Database 12, it is not possible to set group-based security on Websheets and other files. This means all users have full access to all Websheets and folders used to store Websheets. Websheets can still be public or private.

  • }Capabilities - The undocumented }Capabilities cube was used in Planning Analytics offerings on TM1 Database 11 to determine behavior in some of the clients and tools, primarily Architect, Perspectives, and TM1Web. The spreading and type-in spreading capabilities that could be set in the }Capabilities cube also applied to Planning Analytics Workspace when using TM1 Database 11. These capabilities do not apply to Planning Analytics Workspace when using TM1 Database 12.

    The TM1 Database 12 Migration Utility does not remove the }Capabilities cube. You should manually delete the }Capabilities cube, as it has no use in Planning Analytics Workspace or Planning Analytics for Microsoft Excel on TM1 Database 12.

  • }ClientCAMAssociatedGroups

  • }ClientProperties

  • }ClientSettings

  • }ConnectionProperties

  • }CubeProperties - Cube properties that remain in TM1 Database 12 have been moved to properties of the cube in the REST API. These cube properties, listed below, can now be accessed using the REST API:

    • ViewStorageMaxMemory (previously named VMM)
    • ViewStorageMinTime (previously named VMT)
    • CalculationThresholdForStorage (previously a single setting in tm1s.cfg)
    • AllowPersistentHolds (previously named ALLOW_PERSISTENT_HOLDS)
    • Locked (previously named LOCK)
    • MeasuresDimension
    • TimeDimension

    All other cube properties previously found in the the }CubeProperties cube have been removed from TM1 Database 12.

  • }CubeSecurityProperties - The CellSecurityDefaultValue and CellSecurityMostRestrictive properties previously found in }WS-SecurityPolicy are now properties of the cube in the REST API.

  • }Dimension Properties - The following dimension properties are now properties of the dimension in the REST API:

    • AllLeavesHierarchyName
    • Locked
    • DefaultHierarchy

    The following dimension properties are not properties of hierarchies in the REST API:

    • Visible
    • ElementsSortType
    • ElementsSortSense ComponentsSortType
    • ComponentsSortSense

    All other dimension properties have been removed from TM1 Database 12.

  • }HierarchyProperties

  • }StatsByChore

  • }StatsByClient

  • }StatsByCube

  • }StatsByCubeByClient

  • }StatsByProcess

  • }StatsForServer

Control dimensions

The following control dimensions are not supported in TM1 Database 12:

  • }ApplicationsEntries