ABS
Converts a number into an absolute value.
Rules TI
Refer to Rules for syntax
ABS
Converts a number into an absolute value.
v11,v12
TI
Refer to Rules for syntax
ACOS
Returns the angle, in radians, whose cosine is x.
Rules TI
Refer to Rules for syntax
ACOS
Returns the angle, in radians, whose cosine is x.
v11,v12
TI
Refer to Rules for syntax
AddClient
Create a new client on the server. 
AddClient
Create a new client on the server. 
v11,v12
AddCubeDependency
Establish cube dependency manually.
AddCubeDependency
Establish cube dependency manually.
v11,v12
AddGroup
Create a new group on the server. 
AddGroup
Create a new group on the server. 
v11,v12
AddInfoCubeRestriction
Filters InfoCube data as it is pulled into TM1. Use this function to restrict the values that are imported for a specified characteristic.
AddInfoCubeRestriction
Filters InfoCube data as it is pulled into TM1. Use this function to restrict the values that are imported for a specified characteristic.
v11
ASCIIDelete
Deletes an ASCII file.
ASCIIDelete
Deletes an ASCII file.
v11,v12
ASCIIOutput
Exports to an ASCII file. The fields exported must be in string format. To convert a number to string, use NumberToString or STR.
ASCIIOutput
Exports to an ASCII file. The fields exported must be in string format. To convert a number to string, use NumberToString or STR.
v11,v12
AsciiOutputOpen
Appends or overwrites content in a specified existing file that you would use in conjunction with functions that write to a file like AsciiOutput and TextOutput.
AsciiOutputOpen
Appends or overwrites content in a specified existing file that you would use in conjunction with functions that write to a file like AsciiOutput and TextOutput.
v11,v12
ASIN
Returns the angle, in radians, whose sine is x. 
Rules TI
Refer to Rules for syntax
ASIN
Returns the angle, in radians, whose sine is x. 
v11,v12
TI
Refer to Rules for syntax
AssignClientPassword
Change the password for a user.  
AssignClientPassword
Change the password for a user.  
v11
AssignClientToGroup
Assigns an existing client on a server to an existing user group.  
AssignClientToGroup
Assigns an existing client on a server to an existing user group.  
v11,v12
AssociateCAMIDToGroup
Creates an association between a TM1 user group and a CAMID (Cognos Access Manager ID) that can be viewed in }ClientCAMAssociatedGroups control cube. 
AssociateCAMIDToGroup
Creates an association between a TM1 user group and a CAMID (Cognos Access Manager ID) that can be viewed in }ClientCAMAssociatedGroups control cube. 
v11
ATAN
Returns the angle, in radians, whose tangent is x.
Rules TI
Refer to Rules for syntax
ATAN
Returns the angle, in radians, whose tangent is x.
v11,v12
TI
Refer to Rules for syntax
AttrDelete
Deletes an attribute for a dimension.
AttrDelete
Deletes an attribute for a dimension.
v11,v12
AttrInsert
Creates a new attribute for a dimenion.
AttrInsert
Creates a new attribute for a dimenion.
v11,v12
AttrN
Returns the numeric attribute for a specified element of a dimension.
Rules TI
Refer to Rules for syntax
AttrN
Returns the numeric attribute for a specified element of a dimension.
v11,v12
TI
Refer to Rules for syntax
AttrNL
Returns a numeric attribute for an element in a dimension, for a given language
AttrNL
Returns a numeric attribute for an element in a dimension, for a given language
v11,v12
AttrPutN
Uploads a value to a numeric attribute for an element.
AttrPutN
Uploads a value to a numeric attribute for an element.
v11,v12
AttrPutS
Uploads a string into an attribute to an element.
AttrPutS
Uploads a string into an attribute to an element.
v11,v12
AttrS
Returns the string attribute for a specified element of a dimension.
Rules TI
Refer to Rules for syntax
AttrS
Returns the string attribute for a specified element of a dimension.
v11,v12
TI
Refer to Rules for syntax
AttrSL
Returns a string attribute for an element, for a given language
AttrSL
Returns a string attribute for an element, for a given language
v11,v12
BatchUpdateFinish
Ends the batch process that was started by BatchUpdateStart.  
BatchUpdateFinish
Ends the batch process that was started by BatchUpdateStart.  
v11
BatchUpdateFinishWait
Ends the batch process until a lock become available that was started by BatchUpdateStart.
BatchUpdateFinishWait
Ends the batch process until a lock become available that was started by BatchUpdateStart.
v11
BatchUpdateStart
Enables batch updates so changes can be committed together when BatchUpdateFinish or BatchUpdateFinishWait is called.
BatchUpdateStart
Enables batch updates so changes can be committed together when BatchUpdateFinish or BatchUpdateFinishWait is called.
v11
Break
A statement that exits from a while loop and continues with the next statement.
Break
A statement that exits from a while loop and continues with the next statement.
v11,v12
CancelJobs
Cancels asynchronous processes that were launched by the RunProcess function.
CancelJobs
Cancels asynchronous processes that were launched by the RunProcess function.
v12
CapIt
Capitalize the first letter of every word in a string. 
Rules TI
Refer to Rules for syntax
CapIt
Capitalize the first letter of every word in a string. 
v11,v12
TI
Refer to Rules for syntax
CellGetN
Retrieves a numeric value from a cube cell.
CellGetN
Retrieves a numeric value from a cube cell.
v11,v12
CellGetS
Retrieves a string value from a cube cell.
CellGetS
Retrieves a string value from a cube cell.
v11,v12
CellIncrementN
Increases a numeric value by a value.
CellIncrementN
Increases a numeric value by a value.
v11,v12
CellIsUpdateable
Checks whether a cube cell can be written to. If the cell can be written to, the function returns 1, otherwise a 0 is returned.
CellIsUpdateable
Checks whether a cube cell can be written to. If the cell can be written to, the function returns 1, otherwise a 0 is returned.
v11,v12
CellPutN
Writes a numeric value to a cube cell.
CellPutN
Writes a numeric value to a cube cell.
v11,v12
CellPutProportionalSpread
Proportionally spreads a value to the children of a consolidation.
CellPutProportionalSpread
Proportionally spreads a value to the children of a consolidation.
v11,v12
CellPutS
Writes a string value to a cube cell.
CellPutS
Writes a string value to a cube cell.
v11,v12
CellSecurityCubeCreate
Creates cell security for a cube.  
CellSecurityCubeCreate
Creates cell security for a cube.  
v11,v12
CellSecurityCubeDestroy
Deletes cube’s cell security.
CellSecurityCubeDestroy
Deletes cube’s cell security.
v11,v12
CellValueN
Returns the numeric value of the specified element in a specified cube.
CellValueN
Returns the numeric value of the specified element in a specified cube.
v11,v12
CellValueS
Returns a string attribute for a specified cube.
CellValueS
Returns a string attribute for a specified cube.
v11,v12
CHAR
Converts the ASCII numeric code into the character. 
Rules TI
Refer to Rules for syntax
CHAR
Converts the ASCII numeric code into the character. 
v11,v12
TI
Refer to Rules for syntax
ChoreAttrDelete
Deletes an attribute for Chores.
ChoreAttrDelete
Deletes an attribute for Chores.
v11,v12
ChoreAttrInsert
Creates an attribute for Chores. 
ChoreAttrInsert
Creates an attribute for Chores. 
v11,v12
ChoreAttrN
Retrieves a numeric attribute for a Chore. 
ChoreAttrN
Retrieves a numeric attribute for a Chore. 
v11,v12
ChoreAttrNL
Retrieves a numeric attribute for a Chore, for a given language
ChoreAttrNL
Retrieves a numeric attribute for a Chore, for a given language
v11,v12
ChoreAttrPutN
Uploads data to a numeric attribute for a Chore. 
ChoreAttrPutN
Uploads data to a numeric attribute for a Chore. 
v11,v12
ChoreAttrPutS
Uploads data to a string attribute for a Chore. 
ChoreAttrPutS
Uploads data to a string attribute for a Chore. 
v11,v12
ChoreAttrS
Retrieves data from a string attribute for a chore.   
ChoreAttrS
Retrieves data from a string attribute for a chore.   
v11,v12
ChoreAttrSL
Retrieves data from a string attribute for a chore, for a given language
ChoreAttrSL
Retrieves data from a string attribute for a chore, for a given language
v11,v12
ChoreError
Terminates the chore and flag with an error status.  
ChoreError
Terminates the chore and flag with an error status.  
v11,v12
ChoreQuit
Terminates a chore and flag with an error status.  
ChoreQuit
Terminates a chore and flag with an error status.  
v11,v12
ChoreRollback
Terminates a chore and begins a rollback.  
ChoreRollback
Terminates a chore and begins a rollback.  
v11,v12
CODE
Converts the character to the ASCII numeric code.  
Rules TI
Refer to Rules for syntax
CODE
Converts the character to the ASCII numeric code.  
v11,v12
TI
Refer to Rules for syntax
CODEW
Returns the UTF-8 numeric code for a specified character within a string.
Rules TI
Refer to TI for syntax
CODEW
Returns the UTF-8 numeric code for a specified character within a string.
v11,v12
Rules
Refer to TI for syntax
ConsolidateChildren
Forces consolidate value to be calculated by summing immediate children. 
ConsolidateChildren
Forces consolidate value to be calculated by summing immediate children. 
v11,v12
ConsolidatedAvg
Returns the average value in a consolidation.  
Rules TI
Refer to Rules for syntax
ConsolidatedAvg
Returns the average value in a consolidation.  
v11,v12
TI
Refer to Rules for syntax
ConsolidatedCount
Returns the number of values in a consolidation
Rules TI
Refer to Rules for syntax
ConsolidatedCount
Returns the number of values in a consolidation
v11,v12
TI
Refer to Rules for syntax
ConsolidatedCountUnique
Counts the unique elements of the consolidated cell in one dimension. 
Rules TI
Refer to Rules for syntax
ConsolidatedCountUnique
Counts the unique elements of the consolidated cell in one dimension. 
v11,v12
TI
Refer to Rules for syntax
ConsolidatedMax
Returns the maximum value in a consolidation.  
Rules TI
Refer to Rules for syntax
ConsolidatedMax
Returns the maximum value in a consolidation.  
v11,v12
TI
Refer to Rules for syntax
ConsolidatedMin
Returns the minimum value in a consolidation.  
Rules TI
Refer to Rules for syntax
ConsolidatedMin
Returns the minimum value in a consolidation.  
v11,v12
TI
Refer to Rules for syntax
CONTINUE
Allows a subsequent rule within the same intersection to be executed. 
Rules TI
Refer to Rules for syntax
CONTINUE
Allows a subsequent rule within the same intersection to be executed. 
v11,v12
TI
Refer to Rules for syntax
COS
Returns the cosine of an angle expressed in radians.
Rules TI
Refer to Rules for syntax
COS
Returns the cosine of an angle expressed in radians.
v11,v12
TI
Refer to Rules for syntax
CreateHierarchyByAttribute
Creates a hierarchy composed of three levels. The lowest level is the N element, the first parent is a given attribute, and the top level is given by a parameter. The new hierarchy will have the same name as the given attribute.   
CreateHierarchyByAttribute
Creates a hierarchy composed of three levels. The lowest level is the N element, the first parent is a given attribute, and the top level is given by a parameter. The new hierarchy will have the same name as the given attribute.   
v11
CubeAttrDelete
Deletes a cube’s attribute. 
CubeAttrDelete
Deletes a cube’s attribute. 
v11,v12
CubeAttrInsert
Creates a new attribute for Cubes.
CubeAttrInsert
Creates a new attribute for Cubes.
v11,v12
CubeAttrN
Returns a numeric attribute for a specified cube.
Rules TI
Refer to Rules for syntax
CubeAttrN
Returns a numeric attribute for a specified cube.
v11,v12
TI
Refer to Rules for syntax
CubeAttrNL
Retrieves data from a numeric attribute for a cube, for a given language
CubeAttrNL
Retrieves data from a numeric attribute for a cube, for a given language
v11,v12
CubeAttrPutN
Uploads data to a numeric attribute for a cube.
CubeAttrPutN
Uploads data to a numeric attribute for a cube.
v11,v12
CubeAttrPutS
Uploads data to a string attribute for a cube.
CubeAttrPutS
Uploads data to a string attribute for a cube.
v11,v12
CubeAttrS
Returns a string attribute for a specified cube.
Rules TI
Refer to Rules for syntax
CubeAttrS
Returns a string attribute for a specified cube.
v11,v12
TI
Refer to Rules for syntax
CubeAttrSL
Retrieves data from a string attribute for a Cube, for a given language
CubeAttrSL
Retrieves data from a string attribute for a Cube, for a given language
v11,v12
CubeClearData
CubeClearData clears the entire data for a Cube.
CubeClearData
CubeClearData clears the entire data for a Cube.
v11,v12
CubeCreate
Creates a cube using the list of specified dimensions.
CubeCreate
Creates a cube using the list of specified dimensions.
v11,v12
CubeDataReservationAcquire
Acquires data reservation for a cube, user and intersection.
CubeDataReservationAcquire
Acquires data reservation for a cube, user and intersection.
v11
CubeDataReservationGet
Finds the data reservations for a cube.
CubeDataReservationGet
Finds the data reservations for a cube.
v11
CubeDataReservationGetConflicts
Gets data reservation set for a cube that conflicts with a user, address and tuple.
CubeDataReservationGetConflicts
Gets data reservation set for a cube that conflicts with a user, address and tuple.
v11
CubeDataReservationRelease
Releases the data reservation for a cube, user and address.  
CubeDataReservationRelease
Releases the data reservation for a cube, user and address.  
v11
CubeDataReservationReleaseAll
Releases all the data reservation specified.
CubeDataReservationReleaseAll
Releases all the data reservation specified.
v11
CubeDestroy
Deletes a Cube from the TM1 Server.   
CubeDestroy
Deletes a Cube from the TM1 Server.   
v11,v12
CubeDimensionCountGet
Returns the number of dimensions in a cube. 
CubeDimensionCountGet
Returns the number of dimensions in a cube. 
v11,v12
CubeDRAcquire
Acquires data reservation for a user in a cube according to an element list. This function applies to dimensions with one or more hierarchies, while CubeDataReservationAcquire is used for dimensions with a single hierarchy.
CubeDRAcquire
Acquires data reservation for a user in a cube according to an element list. This function applies to dimensions with one or more hierarchies, while CubeDataReservationAcquire is used for dimensions with a single hierarchy.
v11,v12
CubeDRGet
Finds existing reservations on a specific cube for all or one user. This function applies to dimensions with one or more hierarchies, while CubeDataReservationGet is used for dimensions with a single hierarchy.
CubeDRGet
Finds existing reservations on a specific cube for all or one user. This function applies to dimensions with one or more hierarchies, while CubeDataReservationGet is used for dimensions with a single hierarchy.
v11,v12
CubeDRGetConflicts
Gets the current data reservation conflicts of the cube. This function applies to dimensions with one or more hierarchies, while CubeDataReservationGetConflicts is used for dimensions with a single hierarchy.
CubeDRGetConflicts
Gets the current data reservation conflicts of the cube. This function applies to dimensions with one or more hierarchies, while CubeDataReservationGetConflicts is used for dimensions with a single hierarchy.
v11,v12
CubeDRRelease
Releases the data reservation specified in the element list. This function applies to dimensions with one or more hierarchies, while CubeDataReservationRelease is used for dimensions with a single hierarchy.
CubeDRRelease
Releases the data reservation specified in the element list. This function applies to dimensions with one or more hierarchies, while CubeDataReservationRelease is used for dimensions with a single hierarchy.
v11,v12
CubeDRReleaseAll
Releases all the data reservation specified in the element list. This function applies to dimensions with one or more hierarchies, while CubeDataReservationReleaseAll is used for dimensions with a single hierarchy.
CubeDRReleaseAll
Releases all the data reservation specified in the element list. This function applies to dimensions with one or more hierarchies, while CubeDataReservationReleaseAll is used for dimensions with a single hierarchy.
v11,v12
CubeExists
Used check if a cube exists on the TM1 Server.
CubeExists
Used check if a cube exists on the TM1 Server.
v11,v12
CubeGetLogChanges
Determines whether logging property of a cube is turned on or not.  
CubeGetLogChanges
Determines whether logging property of a cube is turned on or not.  
v11
CubeProcessFeeders
Re-processes feeders in the rule for a specified cube. 
CubeProcessFeeders
Re-processes feeders in the rule for a specified cube. 
v11,v12
CubeRuleAppend
Appends a single line of text to a rule.
CubeRuleAppend
Appends a single line of text to a rule.
v11,v12
CubeRuleDestroy
Deletes the rule from a cube.
CubeRuleDestroy
Deletes the rule from a cube.
v11,v12
CubeSaveData
Serialises a cube to disk.
CubeSaveData
Serialises a cube to disk.
v11
CubeSetConnParams
Sets the connection parameters and encrypt the password for a virtual cube stored in }CubeProperties control cube. 
CubeSetConnParams
Sets the connection parameters and encrypt the password for a virtual cube stored in }CubeProperties control cube. 
v11
CubeSetLogChanges
Sets the logging property for a cube.
CubeSetLogChanges
Sets the logging property for a cube.
v11
CubeTimeLastUpdated
Returns a serial value which refers to the last time the cube was updated. 
CubeTimeLastUpdated
Returns a serial value which refers to the last time the cube was updated. 
v11,v12
CubeUnload
Unloads a cube and its view from the memory. 
CubeUnload
Unloads a cube and its view from the memory. 
v11,v12
DataMinorErrorCount
Counts minor errors that occur in Data tab.
DataMinorErrorCount
Counts minor errors that occur in Data tab.
v11,v12
DatasourceASCIIDecimalSeparator
Sets the decimal separator for a text file.
DatasourceASCIIDecimalSeparator
Sets the decimal separator for a text file.
v11,v12
DatasourceASCIIDelimiter
Sets the delimiter for a text file.
DatasourceASCIIDelimiter
Sets the delimiter for a text file.
v11,v12
DatasourceASCIIHeaderRecords
Sets the header records for a text file.
DatasourceASCIIHeaderRecords
Sets the header records for a text file.
v11,v12
DatasourceASCIIQuoteCharacter
Sets the quote character for a text file
DatasourceASCIIQuoteCharacter
Sets the quote character for a text file
v11,v12
DatasourceASCIIThousandSeparator
Sets the thousand separator for a text file
DatasourceASCIIThousandSeparator
Sets the thousand separator for a text file
v11,v12
DatasourceCubeview
Sets the cube view in the data source.
DatasourceCubeview
Sets the cube view in the data source.
v11,v12
DatasourceDimensionSubset
Sets the dimension subset in the data source.
DatasourceDimensionSubset
Sets the dimension subset in the data source.
v11,v12
DatasourceNameForClient
Sets the name of the data source from the client’s perspective when creating or editing the process.
DatasourceNameForClient
Sets the name of the data source from the client’s perspective when creating or editing the process.
v11,v12
DatasourceNameForServer
Sets the name for the data source.
DatasourceNameForServer
Sets the name for the data source.
v11,v12
DatasourceODBOCatalog
This TurboIntegrator local variable sets the name of the database collection that contains the cubes, dimensions or other objects to which you want to connect. For Microsoft Analysis Services, this is the name of the database.
DatasourceODBOCatalog
This TurboIntegrator local variable sets the name of the database collection that contains the cubes, dimensions or other objects to which you want to connect. For Microsoft Analysis Services, this is the name of the database.
v11
DatasourceODBOConnectionString
This TurboIntegrator local variable sets any additional connection parameters that may be required to connect to the OLAP server.
DatasourceODBOConnectionString
This TurboIntegrator local variable sets any additional connection parameters that may be required to connect to the OLAP server.
v11
DatasourceODBOCubeName
This TurboIntegrator local variable sets the name of the cube from the OLAP server that you want to use as a data source.
DatasourceODBOCubeName
This TurboIntegrator local variable sets the name of the cube from the OLAP server that you want to use as a data source.
v11
DatasourceODBOHierarchyName
This TurboIntegrator local variable sets the name of the hierarchy for the specific dimension you are using as a data source. You use this variable for other OLAP products, such as SAP BW, where a hierarchy is a separate object.
DatasourceODBOHierarchyName
This TurboIntegrator local variable sets the name of the hierarchy for the specific dimension you are using as a data source. You use this variable for other OLAP products, such as SAP BW, where a hierarchy is a separate object.
v11
DatasourceODBOLocation
This TurboIntegrator local variable sets the name of the location (system) where the OLAP server is running.
DatasourceODBOLocation
This TurboIntegrator local variable sets the name of the location (system) where the OLAP server is running.
v11
DatasourceODBOProvider
This TurboIntegrator local variable sets the name of the ODBO provider that you want to use as a data source. This is the full name that is assigned by the ODBO provider manufacturer to identify their multidimensional database server.
DatasourceODBOProvider
This TurboIntegrator local variable sets the name of the ODBO provider that you want to use as a data source. This is the full name that is assigned by the ODBO provider manufacturer to identify their multidimensional database server.
v11
DatasourceODBOSAPClientID
This TurboIntegrator local variable sets the client number that corresponds to the UI version on the SAP server to which you want to connect.
DatasourceODBOSAPClientID
This TurboIntegrator local variable sets the client number that corresponds to the UI version on the SAP server to which you want to connect.
v11
DatasourceODBOSAPClientLanguage
This TurboIntegrator local variable sets the language specification for the language of the SAP system to which you want to connect.
DatasourceODBOSAPClientLanguage
This TurboIntegrator local variable sets the language specification for the language of the SAP system to which you want to connect.
v11
DatasourcePassword
Sets the password used for the data source
DatasourcePassword
Sets the password used for the data source
v11,v12
DatasourceQuery
Sets query for the data source
DatasourceQuery
Sets query for the data source
v11,v12
DatasourceSAPUsingRoleAuths
The DatasourceSAPUsingRoleAuths local variable instructs the TurboIntegrator process to ignore security information when processing an SAP datasource. This variable must be placed in the Prolog.
DatasourceSAPUsingRoleAuths
The DatasourceSAPUsingRoleAuths local variable instructs the TurboIntegrator process to ignore security information when processing an SAP datasource. This variable must be placed in the Prolog.
v11
DatasourceSAPUsingTexts
The DatasourceSAPUsingTexts local variable instructs the TurboIntegrator process to ignore characteristic descriptions when processing an SAP datasource, resulting in a decreased memory consumption and increased performance.
DatasourceSAPUsingTexts
The DatasourceSAPUsingTexts local variable instructs the TurboIntegrator process to ignore characteristic descriptions when processing an SAP datasource, resulting in a decreased memory consumption and increased performance.
v11
DatasourceType
Sets the type used for the data source.
DatasourceType
Sets the type used for the data source.
v11,v12
DatasourceUsername
Sets the name used to connect to the data source.
DatasourceUsername
Sets the name used to connect to the data source.
v11,v12
DATE
Returns the date in a string yy-dd-mm format.
Rules TI
Refer to Rules for syntax
DATE
Returns the date in a string yy-dd-mm format.
v11,v12
TI
Refer to Rules for syntax
DATES
Returns the date in a string yy-dd-mm or yyyy-dd-mm format.
Rules TI
Refer to Rules for syntax
DATES
Returns the date in a string yy-dd-mm or yyyy-dd-mm format.
v11,v12
TI
Refer to Rules for syntax
DAY
Returns  the day from a date in a numeric format.
Rules TI
Refer to Rules for syntax
DAY
Returns  the day from a date in a numeric format.
v11,v12
TI
Refer to Rules for syntax
DAYNO
Returns the serial number from a date in a numeric format. 
Rules TI
Refer to Rules for syntax
DAYNO
Returns the serial number from a date in a numeric format. 
v11,v12
TI
Refer to Rules for syntax
DB
Retrieve a value from a cube cell. 
DB
Retrieve a value from a cube cell. 
v11,v12
DBR
Retrieve and write back a value or text to a cube’s cell. DBR is less efficient over a WAN than DBRW. DBR will be processed before a DBRW.
DBR
Retrieve and write back a value or text to a cube’s cell. DBR is less efficient over a WAN than DBRW. DBR will be processed before a DBRW.
v11,v12
DBRA
Retrieve and write back a value or text to a dimension’s attribute.
DBRA
Retrieve and write back a value or text to a dimension’s attribute.
v11,v12
DBRW
Provides read and write back capability to Excel from a Cube.
DBRW
Provides read and write back capability to Excel from a Cube.
v11,v12
DBS
Send a value to a cube’s cell. This function cannot send a string to a cube. To send strings, use the DBSS function.
DBS
Send a value to a cube’s cell. This function cannot send a string to a cube. To send strings, use the DBSS function.
v11,v12
DBSA
Send a value to a dimension attribute. The value sent can be either a string or numeric value, based on the attribute type.
DBSA
Send a value to a dimension attribute. The value sent can be either a string or numeric value, based on the attribute type.
v11,v12
DBSS
Send text to a cube’s cell.
DBSS
Send text to a cube’s cell.
v11,v12
DBSW
Send a numeric value to a cube’s cell. DBSW is more efficient over a WAN than DBS.
DBSW
Send a numeric value to a cube’s cell. DBSW is more efficient over a WAN than DBS.
v11,v12
DELET
Deletes a specified number of characters from a specified position within a string.
Rules TI
Refer to Rules for syntax
DELET
Deletes a specified number of characters from a specified position within a string.
v11,v12
TI
Refer to Rules for syntax
DeleteAllPersistentFeeders
Deletes all persistent feeders on the TM1 Server.
DeleteAllPersistentFeeders
Deletes all persistent feeders on the TM1 Server.
v11,v12
DeleteClient
Deletes an existing client from the server.
DeleteClient
Deletes an existing client from the server.
v11,v12
DeleteGroup
Deletes a group from the server.  
DeleteGroup
Deletes a group from the server.  
v11,v12
DFRST
Returns the first element in a dimension
DFRST
Returns the first element in a dimension
v11,v12
DimensionAttrDelete
Deletes an attribute for a Dimension.
DimensionAttrDelete
Deletes an attribute for a Dimension.
v11,v12
DimensionAttrInsert
Creates an attribute for a Dimension.
DimensionAttrInsert
Creates an attribute for a Dimension.
v11,v12
DimensionAttrN
Returns a numeric attribute for a specified dimension.
Rules TI
Refer to Rules for syntax
DimensionAttrN
Returns a numeric attribute for a specified dimension.
v11,v12
TI
Refer to Rules for syntax
DimensionAttrNL
Returns and numeric attribute field, for a given language
DimensionAttrNL
Returns and numeric attribute field, for a given language
v11,v12
DimensionAttrPutN
Uploads data to a numeric attribute for a dimension.
DimensionAttrPutN
Uploads data to a numeric attribute for a dimension.
v11,v12
DimensionAttrPutS
Uploads data to a string attribute for a dimension.
DimensionAttrPutS
Uploads data to a string attribute for a dimension.
v11,v12
DimensionAttrS
Returns a string attribute for a specified dimension.
Rules TI
Refer to Rules for syntax
DimensionAttrS
Returns a string attribute for a specified dimension.
v11,v12
TI
Refer to Rules for syntax
DimensionAttrSL
Returns and string attribute field, for a given language
DimensionAttrSL
Returns and string attribute field, for a given language
v11,v12
DimensionCreate
Creates a new dimension.  
DimensionCreate
Creates a new dimension.  
v11,v12
DimensionDeleteAllElements
Deletes all elements in a dimension.
DimensionDeleteAllElements
Deletes all elements in a dimension.
v11,v12
DimensionDeleteElements
Deletes elements in a dimension based on a subset.
DimensionDeleteElements
Deletes elements in a dimension based on a subset.
v11,v12
DimensionDestroy
Deletes a dimension.
DimensionDestroy
Deletes a dimension.
v11,v12
DimensionElementComponentAddDirect
Adds an element to a consolidated element in a rollup according to a specific weight in a dimension. This function is actioned immediately.
DimensionElementComponentAddDirect
Adds an element to a consolidated element in a rollup according to a specific weight in a dimension. This function is actioned immediately.
v11,v12
DimensionElementComponentDelete
Deletes an element from a consolidated element in a rollup. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use DimensionElementComponentDeleteDirect.
DimensionElementComponentDelete
Deletes an element from a consolidated element in a rollup. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use DimensionElementComponentDeleteDirect.
v11,v12
DimensionElementComponentDelete
Deletes an element from a consolidated element in a rollup. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use DimensionElementComponentDeleteDirect.
DimensionElementComponentDelete
Deletes an element from a consolidated element in a rollup. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use DimensionElementComponentDeleteDirect.
v11,v12
DimensionElementComponentDeleteDirect
Deletes an element from a consolidated element. This function is actioned immediately.  To action this function until the process makes a commitment (e.g. at the end of executing the metadata tab), use DimensionElementComponentDelete.
DimensionElementComponentDeleteDirect
Deletes an element from a consolidated element. This function is actioned immediately.  To action this function until the process makes a commitment (e.g. at the end of executing the metadata tab), use DimensionElementComponentDelete.
v11,v12
DimensionElementDelete
Deletes an element in a dimension. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use DimensionElementDeleteDirect.
DimensionElementDelete
Deletes an element in a dimension. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use DimensionElementDeleteDirect.
v11,v12
DimensionElementDeleteDirect
Deletes an element directly in a dimension. This function is actioned immediately.  To action this function until the process makes a commitment (e.g. at the end of executing the metadata tab), use  DimensionElementDelete.
DimensionElementDeleteDirect
Deletes an element directly in a dimension. This function is actioned immediately.  To action this function until the process makes a commitment (e.g. at the end of executing the metadata tab), use  DimensionElementDelete.
v11,v12
DimensionElementExists
Checks whether a specific element exists in a dimension. If the element exists, the result is 1 and if it does not exist, the result is 0.
DimensionElementExists
Checks whether a specific element exists in a dimension. If the element exists, the result is 1 and if it does not exist, the result is 0.
v11,v12
DimensionElementInsert
Adds an element in a dimension. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use DimensionElementInsertDirect.
DimensionElementInsert
Adds an element in a dimension. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use DimensionElementInsertDirect.
v11,v12
DimensionElementInsertDirect
Adds an element in a dimension by directly editing a dimension. This function is actioned immediately.  To action this function until the process makes a commitment (e.g. at the end of executing the metadata tab), use DimensionElementInsert.
DimensionElementInsertDirect
Adds an element in a dimension by directly editing a dimension. This function is actioned immediately.  To action this function until the process makes a commitment (e.g. at the end of executing the metadata tab), use DimensionElementInsert.
v11,v12
DimensionElementPrincipalName
Returns the principal name of an element or element alias.
DimensionElementPrincipalName
Returns the principal name of an element or element alias.
v11,v12
DimensionExists
Checks whether a dimension exists. If the dimension exists, the result is 1 and if it does not exist the result is 0.
DimensionExists
Checks whether a dimension exists. If the dimension exists, the result is 1 and if it does not exist the result is 0.
v11,v12
DimensionHierarchyCreate
Creates a hierarchy in a dimension. No elements will be inserted in the hierarchy.
DimensionHierarchyCreate
Creates a hierarchy in a dimension. No elements will be inserted in the hierarchy.
v11,v12
DimensionSortOrder
Sorts the elements and components of consolidations within a dimension.
DimensionSortOrder
Sorts the elements and components of consolidations within a dimension.
v11,v12
DimensionTimeLastUpdated
Returns a serial value indicating date and time when a dimension was last updated. Use TIMST to convert the value to a date/time format.
DimensionTimeLastUpdated
Returns a serial value indicating date and time when a dimension was last updated. Use TIMST to convert the value to a date/time format.
v11,v12
DimensionTopElementInsert
Creates a root element in a dimension. This can only be created if the dimension does not have a standalone root element. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab).
DimensionTopElementInsert
Creates a root element in a dimension. This can only be created if the dimension does not have a standalone root element. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab).
v11,v12
DimensionTopElementInsertDirect
Creates a root element in a dimension by directly editing a dimension. This can only be created if the dimension does not have a standalone root element. This function is actioned immediately.
DimensionTopElementInsertDirect
Creates a root element in a dimension by directly editing a dimension. This can only be created if the dimension does not have a standalone root element. This function is actioned immediately.
v11,v12
DimensionUpdateDirect
Rewrites a dimension that has been edited with Dimension*Direct function(s) (e.g. DimensionElementInsertDirect) to reduce the memory utilised to edit the dimension.
DimensionUpdateDirect
Rewrites a dimension that has been edited with Dimension*Direct function(s) (e.g. DimensionElementInsertDirect) to reduce the memory utilised to edit the dimension.
v11,v12
DIMIX
Returns an element’s index number in a dimension
Refer to Rules for syntax
DIMIX
Returns an element’s index number in a dimension
v11,v12
TI
Refer to Rules for syntax
DIMNM
Returns an element’s primary name based on an index in a dimension
Refer to Rules for syntax
DIMNM
Returns an element’s primary name based on an index in a dimension
v11,v12
TI
Refer to Rules for syntax
DIMSIZ
Returns the number of elements in a dimension.
Excel Rules TI
Refer to Excel for syntax
DIMSIZ
Returns the number of elements in a dimension.
v11,v12
Rules
TI
Refer to Excel for syntax
DisableBulkLoadMode
Disables bulk load processing on the TM1 Server. To enable bulk load processing, use EnableBulkLoadMode. 
DisableBulkLoadMode
Disables bulk load processing on the TM1 Server. To enable bulk load processing, use EnableBulkLoadMode. 
v11
DisableMTQViewConstruct
Disables multi-threaded query processing in a process which uses a cube view as the datasource. This function will override the value MTQQuery=F set in the tms1.cfg file. 
DisableMTQViewConstruct
Disables multi-threaded query processing in a process which uses a cube view as the datasource. This function will override the value MTQQuery=F set in the tms1.cfg file. 
v11,v12
DNEXT
Returns the next element based on the index in a dimension
Excel Rules TI
Refer to Excel for syntax
DNEXT
Returns the next element based on the index in a dimension
v11,v12
Rules
TI
Refer to Excel for syntax
DNLEV
Returns the number of levels in a dimension
Excel Rules TI
Refer to Excel for syntax
DNLEV
Returns the number of levels in a dimension
v11,v12
Rules
TI
Refer to Excel for syntax
DTYPE
Returns the element type in a dimension
Excel Rules TI
Refer to Excel for syntax
DTYPE
Returns the element type in a dimension
v11,v12
Rules
TI
Refer to Excel for syntax
ELCOMP
Returns the name of a child element from a consolidated element based on the position
Refer to Rules for syntax
ELCOMP
Returns the name of a child element from a consolidated element based on the position
v11,v12
TI
Refer to Rules for syntax
ELCOMPN
Returns the number of components under an element
Refer to Rules for syntax
ELCOMPN
Returns the number of components under an element
v11,v12
TI
Refer to Rules for syntax
ElementAttrDelete
Deletes attribute for a dimension.
ElementAttrDelete
Deletes attribute for a dimension.
v11,v12
ElementAttrInsert
Create an attribute for a dimension.
ElementAttrInsert
Create an attribute for a dimension.
v11,v12
ElementAttrN
Returns the numeric attribute value of the specified element of a dimension.  
Rules TI
Refer to Rules for syntax
ElementAttrN
Returns the numeric attribute value of the specified element of a dimension.  
v11,v12
TI
Refer to Rules for syntax
ElementAttrNL
Retrieves a numeric attribute for an element, for a given language
ElementAttrNL
Retrieves a numeric attribute for an element, for a given language
v11,v12
ElementAttrPutN
Uploads data to a numeric attribute for an element.
ElementAttrPutN
Uploads data to a numeric attribute for an element.
v11,v12
ElementAttrPutS
Uploads data from a string attribute for an element.
ElementAttrPutS
Uploads data from a string attribute for an element.
v11,v12
ElementAttrS
Returns the string attribute value of the specified element of a dimension.  
Rules TI
Refer to Rules for syntax
ElementAttrS
Returns the string attribute value of the specified element of a dimension.  
v11,v12
TI
Refer to Rules for syntax
ElementAttrSL
Returns a string attribute for an element, for a given language
ElementAttrSL
Returns a string attribute for an element, for a given language
v11,v12
ElementComponent
Returns the name of child of a consolidated element. 
Rules TI
Refer to Rules for syntax
ElementComponent
Returns the name of child of a consolidated element. 
v11,v12
TI
Refer to Rules for syntax
ElementComponentCount
Returns the number of components of the consolidation. 
Rules TI
Refer to Rules for syntax
ElementComponentCount
Returns the number of components of the consolidation. 
v11,v12
TI
Refer to Rules for syntax
ElementCount
Returns the number of components of the consolidated element.
Rules TI
Refer to Rules for syntax
ElementCount
Returns the number of components of the consolidated element.
v11,v12
TI
Refer to Rules for syntax
ElementFirst
Returns the first element of a specified dimension.    
Rules TI
Refer to Rules for syntax
ElementFirst
Returns the first element of a specified dimension.    
v11,v12
TI
Refer to Rules for syntax
ElementIndex
Returns the index number of an element within a dimension. 
Rules TI
Refer to Rules for syntax
ElementIndex
Returns the index number of an element within a dimension. 
v11,v12
TI
Refer to Rules for syntax
ElementIsAncestor
Determines if the element is an ancestor of another element or not. Function returns 1 if the element is ancestor of another element. 
Rules TI
Refer to Rules for syntax
ElementIsAncestor
Determines if the element is an ancestor of another element or not. Function returns 1 if the element is ancestor of another element. 
v11,v12
TI
Refer to Rules for syntax
ElementIsComponent
Determines if the element is child of a consolidation or not.  Function returns 1 if the element is child of consolidation. 
Rules TI
Refer to Rules for syntax
ElementIsComponent
Determines if the element is child of a consolidation or not.  Function returns 1 if the element is child of consolidation. 
v11,v12
TI
Refer to Rules for syntax
ElementIsParent
Determines if an element is parent of another element or not.  
Rules TI
Refer to Rules for syntax
ElementIsParent
Determines if an element is parent of another element or not.  
v11,v12
TI
Refer to Rules for syntax
ElementLevel
Returns the level of an element within a dimension.
Rules TI
Refer to Rules for syntax
ElementLevel
Returns the level of an element within a dimension.
v11,v12
TI
Refer to Rules for syntax
ElementName
Returns the element of a dimension based on the index argument. 
Rules TI
Refer to Rules for syntax
ElementName
Returns the element of a dimension based on the index argument. 
v11,v12
TI
Refer to Rules for syntax
ElementNext
Returns the element that follows the specified element of a dimension.
Rules TI
Refer to Rules for syntax
ElementNext
Returns the element that follows the specified element of a dimension.
v11,v12
TI
Refer to Rules for syntax
ElementParent
Returns the parent of an element in the dimension.
Rules TI
Refer to Rules for syntax
ElementParent
Returns the parent of an element in the dimension.
v11,v12
TI
Refer to Rules for syntax
ElementParentCount
Returns the number of parents of an element in the dimension.  
Rules TI
Refer to Rules for syntax
ElementParentCount
Returns the number of parents of an element in the dimension.  
v11,v12
TI
Refer to Rules for syntax
ElementSecurityGet
Retrieves the security level assigned to a specified group for a dimension element.
ElementSecurityGet
Retrieves the security level assigned to a specified group for a dimension element.
v11,v12
ElementSecurityPut
Assigns a security level to a specified group for an element.
ElementSecurityPut
Assigns a security level to a specified group for an element.
v11,v12
ElementType
Returns element type information of an element in the dimension. 
Rules TI
Refer to Rules for syntax
ElementType
Returns element type information of an element in the dimension. 
v11,v12
TI
Refer to Rules for syntax
ElementWeight
Returns the weight of a child element in a consolidation element.
Rules TI
Refer to Rules for syntax
ElementWeight
Returns the weight of a child element in a consolidation element.
v11,v12
TI
Refer to Rules for syntax
ELISANC
Determines if an element is ancestor of another element or not.  
Rules TI
Refer to Rules for syntax
ELISANC
Determines if an element is ancestor of another element or not.  
v11,v12
TI
Refer to Rules for syntax
ELISCOMP
Determine whether an element is a component of a parent element in a dimension
Refer to Rules for syntax
ELISCOMP
Determine whether an element is a component of a parent element in a dimension
v11,v12
TI
Refer to Rules for syntax
ELISPAR
Determine whether an element is a parent of a child in a dimension
Refer to Rules for syntax
ELISPAR
Determine whether an element is a parent of a child in a dimension
v11,v12
TI
Refer to Rules for syntax
ELLEV
Returns the level of an element within a dimension.
Refer to Rules for syntax
ELLEV
Returns the level of an element within a dimension.
v11,v12
TI
Refer to Rules for syntax
ELPAR
Returns the parent of an element in a dimension
Refer to Rules for syntax
ELPAR
Returns the parent of an element in a dimension
v11,v12
TI
Refer to Rules for syntax
ELPARN
Returns the number of parents for an element
Refer to Rules for syntax
ELPARN
Returns the number of parents for an element
v11,v12
TI
Refer to Rules for syntax
ELSLEN
Returns the number of characters in the element in a dimension
ELSLEN
Returns the number of characters in the element in a dimension
v11,v12
ELWEIGHT
Returns the element’s weight to a consolidated element in a dimension
Refer to Rules for syntax
ELWEIGHT
Returns the element’s weight to a consolidated element in a dimension
v11,v12
TI
Refer to Rules for syntax
EnableBulkLoadMode
Enables bulk load processing to improve process efficiency. Call EnableBulkLoadMode in the Prolog or Epilog. This function is enabled in in one process and remains enabled until disabled with DisableBulkLoadMode or until a chore completes.
EnableBulkLoadMode
Enables bulk load processing to improve process efficiency. Call EnableBulkLoadMode in the Prolog or Epilog. This function is enabled in in one process and remains enabled until disabled with DisableBulkLoadMode or until a chore completes.
v11
EnableMTQViewConstruct
Enables multi-threaded query processing in a process which uses a cube view as the datasource. This function will override the value MTQQuery=F set in the tms1.cfg file. 
EnableMTQViewConstruct
Enables multi-threaded query processing in a process which uses a cube view as the datasource. This function will override the value MTQQuery=F set in the tms1.cfg file. 
v11,v12
EvalJavaN
A rules function that executes a Java TI process that returns a number.
EvalJavaN
A rules function that executes a Java TI process that returns a number.
v11
EvalJavaS
A rules function that executes a Java TI process that returns a string.
EvalJavaS
A rules function that executes a Java TI process that returns a string.
v11
ExecuteCommand
Executes a command line.
ExecuteCommand
Executes a command line.
v11
ExecuteHttpRequest
Executes an HTTP request to a server over the web, enabling the retrieval of web pages, data and other resources. For instance, retrieving a list of TM1 cubes or the local weather.
ExecuteHttpRequest
Executes an HTTP request to a server over the web, enabling the retrieval of web pages, data and other resources. For instance, retrieving a list of TM1 cubes or the local weather.
v12
ExecuteJavaN
Executes a Java TurboIntegrator process that returns a number.
ExecuteJavaN
Executes a Java TurboIntegrator process that returns a number.
v11
ExecuteJavaS
Executes a Java TurboIntegrator process that returns a string.
ExecuteJavaS
Executes a Java TurboIntegrator process that returns a string.
v11
ExecuteProcess
Executes a process. 
ExecuteProcess
Executes a process. 
v11,v12
EXP
Returns the natural anti-log of a number.
Rules TI
Refer to Rules for syntax
EXP
Returns the natural anti-log of a number.
v11,v12
TI
Refer to Rules for syntax
Expand
Expands variable names, enclosed in % signs.
Expand
Expands variable names, enclosed in % signs.
v11,v12
FEEDERS
Flag rule cells and force TM1 engine to calculate. 
FEEDERS
Flag rule cells and force TM1 engine to calculate. 
v11,v12
FEEDSTRINGS
Enables feeding of string cells. 
FEEDSTRINGS
Enables feeding of string cells. 
v11,v12
FileExists
Searches if a file exists in a folder. If the file exists, then 1 is returned, otherwise 0 is returned. 
FileExists
Searches if a file exists in a folder. If the file exists, then 1 is returned, otherwise 0 is returned. 
v11,v12
FILL
Repeats a string to the specified number of lengths
FILL
Repeats a string to the specified number of lengths
v11,v12
ForceSkipCheck
Forces the view query to process only values in the cube, instead of going through every possible cell. Use in the Prolog tab.
ForceSkipCheck
Forces the view query to process only values in the cube, instead of going through every possible cell. Use in the Prolog tab.
v11,v12
FormatDate
Formats a date value
FormatDate
Formats a date value
v11,v12
FV
Returns the future value of an annuity at the time of the last payment. 
Rules TI
Refer to Rules for syntax
FV
Returns the future value of an annuity at the time of the last payment. 
v11,v12
TI
Refer to Rules for syntax
GetJobStatus
Returns the status of a process, such as whether it existed normally, had minor errors or is still in progress.
GetJobStatus
Returns the status of a process, such as whether it existed normally, had minor errors or is still in progress.
v12
GetProcessErrorFileDirectory
Returns the full path name, with trailing slash, of the directory where error files are written.
GetProcessErrorFileDirectory
Returns the full path name, with trailing slash, of the directory where error files are written.
v11,v12
GetProcessErrorFilename
Returns the name of the error log file associated with the process. If the process has not yet generated an error log file, the function returns an empty (null) string.
GetProcessErrorFilename
Returns the name of the error log file associated with the process. If the process has not yet generated an error log file, the function returns an empty (null) string.
v11,v12
GetProcessName
Returns the name of the process.
GetProcessName
Returns the name of the process.
v11,v12
GetUseActiveSandboxProperty
Returns a value that identifies if the process has read/write access to the base or active sandbox for the user.
GetUseActiveSandboxProperty
Returns a value that identifies if the process has read/write access to the base or active sandbox for the user.
v11,v12
Hierarchy
Returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.  
Hierarchy
Returns the name of the hierarchy if there is only one hierarchy at the dimension otherwise it returns empty string.  
v11,v12
HierarchyAttrN
Returns a numeric attribute for a dimensions' hierarchy
HierarchyAttrN
Returns a numeric attribute for a dimensions' hierarchy
v11,v12
HierarchyAttrNL
Returns a numeric attribute for a dimensions' hierarchy, for a given language
HierarchyAttrNL
Returns a numeric attribute for a dimensions' hierarchy, for a given language
v11,v12
HierarchyAttrPutN
uploads data to a string attribute for a dimensions' hierarchy
HierarchyAttrPutN
uploads data to a string attribute for a dimensions' hierarchy
v11,v12
HierarchyAttrPutS
uploads data to a numeric attribute for a dimensions' hierarchy
HierarchyAttrPutS
uploads data to a numeric attribute for a dimensions' hierarchy
v11,v12
HierarchyAttrS
Returns a string attribute for a dimensions' hierarchy
HierarchyAttrS
Returns a string attribute for a dimensions' hierarchy
v11,v12
HierarchyAttrSL
Returns a string attribute for a dimensions' hierarchy, given a locale
HierarchyAttrSL
Returns a string attribute for a dimensions' hierarchy, given a locale
v11,v12
HierarchyContainsAllLeaves
If a hierarchy contains all leaf elements in the dimension. If all are leaf elements the function returns 1 (True) and if missing one or more leaf elements it returns 0 (false).
HierarchyContainsAllLeaves
If a hierarchy contains all leaf elements in the dimension. If all are leaf elements the function returns 1 (True) and if missing one or more leaf elements it returns 0 (false).
v11,v12
HierarchyCount
Returns the number of hierarchies in the supplied dimension.
HierarchyCount
Returns the number of hierarchies in the supplied dimension.
v11,v12
HierarchyCreate
Creates a new hierarchy in a dimension.
HierarchyCreate
Creates a new hierarchy in a dimension.
v11,v12
HierarchyDeleteAllElements
Deletes all elements in a hierarchy.
HierarchyDeleteAllElements
Deletes all elements in a hierarchy.
v11,v12
HierarchyDeleteElements
Deletes an element from a hierarchy.
HierarchyDeleteElements
Deletes an element from a hierarchy.
v11,v12
HierarchyDestroy
Deletes a hierarchy from a dimension.
HierarchyDestroy
Deletes a hierarchy from a dimension.
v11,v12
HierarchyElementComponentAdd
Adds an element to a consolidated element in a hierarchy, rolling up according to the weight defined. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab).
HierarchyElementComponentAdd
Adds an element to a consolidated element in a hierarchy, rolling up according to the weight defined. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab).
v11,v12
HierarchyElementComponentAddDirect
Adds an element to a consolidated element in a hierarchy, rolling up according to the weight defined. This function is actioned immediately.
HierarchyElementComponentAddDirect
Adds an element to a consolidated element in a hierarchy, rolling up according to the weight defined. This function is actioned immediately.
v11,v12
HierarchyElementComponentDelete
Deletes a component (child) from a consolidated element in a hierarchy. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use HierarchyElementComponentDeleteDirect.
HierarchyElementComponentDelete
Deletes a component (child) from a consolidated element in a hierarchy. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use HierarchyElementComponentDeleteDirect.
v11,v12
HierarchyElementComponentDeleteDirect
Deletes a component (child) from a consolidated element in a specific hierarchy in a dimension. This function is actioned immediately.
HierarchyElementComponentDeleteDirect
Deletes a component (child) from a consolidated element in a specific hierarchy in a dimension. This function is actioned immediately.
v11,v12
HierarchyElementDelete
Deletes a member element of a specific hierarchy. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use HierarchyElementDeleteDirect..
HierarchyElementDelete
Deletes a member element of a specific hierarchy. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use HierarchyElementDeleteDirect..
v11,v12
HierarchyElementDeleteDirect
Deletes a member element of a specific hierarchy in a dimension. This function is actioned immediately.  To action this function until the process makes a commitment (e.g. at the end of executing the metadata tab), use HierarchyElementDelete.
HierarchyElementDeleteDirect
Deletes a member element of a specific hierarchy in a dimension. This function is actioned immediately.  To action this function until the process makes a commitment (e.g. at the end of executing the metadata tab), use HierarchyElementDelete.
v11,v12
HierarchyElementExists
Checks whether an element exists in a dimension. If the element exists, the result is 1. If it does not exist, the result is 0. 
HierarchyElementExists
Checks whether an element exists in a dimension. If the element exists, the result is 1. If it does not exist, the result is 0. 
v11,v12
HierarchyElementInsert
Adds an element to a hierarchy. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use HierarchyElementInsertDirect.
HierarchyElementInsert
Adds an element to a hierarchy. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use HierarchyElementInsertDirect.
v11,v12
HierarchyElementInsertDirect
Adds an element to a specific hierarchy. This function is actioned immediately.  To action this function until the process makes a commitment (e.g. at the end of executing the metadata tab), use HierarchyElementInsert.
HierarchyElementInsertDirect
Adds an element to a specific hierarchy. This function is actioned immediately.  To action this function until the process makes a commitment (e.g. at the end of executing the metadata tab), use HierarchyElementInsert.
v11,v12
HierarchyElementPrincipalName
Returns the principal name of an element given an alias or the element name itself.
HierarchyElementPrincipalName
Returns the principal name of an element given an alias or the element name itself.
v11,v12
HierarchyElementSecurityGet
Returns the level of security privilege designated to a group for an element.
HierarchyElementSecurityGet
Returns the level of security privilege designated to a group for an element.
v11,v12
HierarchyElementSecurityPut
Sets security access for a group to an element.
HierarchyElementSecurityPut
Sets security access for a group to an element.
v11,v12
HierarchyExists
Checks whether a specific hierarchy exists in a dimension. If the hierarchy exists, the result is 1 and if it does not exist the result is 0.
HierarchyExists
Checks whether a specific hierarchy exists in a dimension. If the hierarchy exists, the result is 1 and if it does not exist the result is 0.
v11,v12
HierarchyHasOrphanedLeaves
Returns 1 if a hierarchy in a dimension has an orphaned element or returns 0 if there is no orphaned element in that hierarchy.
HierarchyHasOrphanedLeaves
Returns 1 if a hierarchy in a dimension has an orphaned element or returns 0 if there is no orphaned element in that hierarchy.
v11,v12
HierarchyIndex
Function returns a 1-based index if the hierarchy is in the supplied dimension, 0 otherwise.
HierarchyIndex
Function returns a 1-based index if the hierarchy is in the supplied dimension, 0 otherwise.
v11,v12
HierarchyN
Returns the name of the hierarchy at a specified position. 
HierarchyN
Returns the name of the hierarchy at a specified position. 
v11,v12
HierarchySortOrder
Sets the order in which elements in a dimension are organized and displayed.
HierarchySortOrder
Sets the order in which elements in a dimension are organized and displayed.
v11,v12
HierarchySubsetAliasGet
Retrieves the alias used for a subset in a hierarchy.
HierarchySubsetAliasGet
Retrieves the alias used for a subset in a hierarchy.
v11,v12
HierarchySubsetAliasSet
Sets an alias for a subset for a hierarchy. Returns 1 if successful or 0 if not.
HierarchySubsetAliasSet
Sets an alias for a subset for a hierarchy. Returns 1 if successful or 0 if not.
v11,v12
HierarchySubsetAttrDelete
Deletes a subset attribute from a hierarchy in a dimension.
HierarchySubsetAttrDelete
Deletes a subset attribute from a hierarchy in a dimension.
v11,v12
HierarchySubsetAttrInsert
Adds a new attribute for subsets.
HierarchySubsetAttrInsert
Adds a new attribute for subsets.
v11,v12
HierarchySubsetAttrN
Returns a numeric attribute for a subset, tied to a dimension's hierarchy
HierarchySubsetAttrN
Returns a numeric attribute for a subset, tied to a dimension's hierarchy
v11,v12
HierarchySubsetAttrNL
Returns a numeric attribute for a subset, tied to a dimension's hierarchy, given a locale
HierarchySubsetAttrNL
Returns a numeric attribute for a subset, tied to a dimension's hierarchy, given a locale
v11,v12
HierarchySubsetAttrPutN
Writes a numeric value to a subset’s attribute or set of elements in a hierarchy for a dimension.
HierarchySubsetAttrPutN
Writes a numeric value to a subset’s attribute or set of elements in a hierarchy for a dimension.
v11,v12
HierarchySubsetAttrPutS
Writes a string value to a subset’s attribute or set of elements in a hierarchy for a dimension.
HierarchySubsetAttrPutS
Writes a string value to a subset’s attribute or set of elements in a hierarchy for a dimension.
v11,v12
HierarchySubsetAttrS
Retrieve data from a string attribute associated to a subset in a hierarchy.
HierarchySubsetAttrS
Retrieve data from a string attribute associated to a subset in a hierarchy.
v11,v12
HierarchySubsetAttrSL
Retrieve data from a string attribute associated to a subset in a hierarchy, based on a language locale.
HierarchySubsetAttrSL
Retrieve data from a string attribute associated to a subset in a hierarchy, based on a language locale.
v11,v12
HierarchySubsetCreate
Creates an empty public subset in a hierarchy.
HierarchySubsetCreate
Creates an empty public subset in a hierarchy.
v11,v12
HierarchySubsetDeleteAllElements
Deletes all elements in a subset from a hierarchy. 
HierarchySubsetDeleteAllElements
Deletes all elements in a subset from a hierarchy. 
v11,v12
HierarchySubsetDestroy
Destroys a subset from a hierarchy.
HierarchySubsetDestroy
Destroys a subset from a hierarchy.
v11,v12
HierarchySubsetElementDelete
Deletes an element from a subset using an index number.
HierarchySubsetElementDelete
Deletes an element from a subset using an index number.
v11,v12
HierarchySubsetElementExists
Checks if an elements exists in a public subset. 1 is returned if the elements exists or 0 if it does not exist in the subset.
HierarchySubsetElementExists
Checks if an elements exists in a public subset. 1 is returned if the elements exists or 0 if it does not exist in the subset.
v11,v12
HierarchySubsetElementGetIndex
Returns the index of an element in a subset for a hierarchy.
HierarchySubsetElementGetIndex
Returns the index of an element in a subset for a hierarchy.
v11,v12
HierarchySubsetElementInsert
Adds an element into a subset associated to a hierarchy.
HierarchySubsetElementInsert
Adds an element into a subset associated to a hierarchy.
v11,v12
HierarchySubsetExists
Checks if a public subset exists for a hierarchy. 1 is returned if the subset exists or 0 if the subset does not exist.
HierarchySubsetExists
Checks if a public subset exists for a hierarchy. 1 is returned if the subset exists or 0 if the subset does not exist.
v11,v12
HierarchySubsetGetElementName
Returns the name of an element from a subset using an index number that’s associated with a hierarchy.
HierarchySubsetGetElementName
Returns the name of an element from a subset using an index number that’s associated with a hierarchy.
v11,v12
HierarchySubsetGetSize
Returns the number of elements in a subset that’s associated with a hierarchy.
HierarchySubsetGetSize
Returns the number of elements in a subset that’s associated with a hierarchy.
v11,v12
HierarchySubsetIsAllSet
Sets a subset to contain all elements of the dimension.
HierarchySubsetIsAllSet
Sets a subset to contain all elements of the dimension.
v11,v12
HierarchySubsetMDXGet
Returns the MDX expression used to for a subset that’s associated with a hierarchy.
HierarchySubsetMDXGet
Returns the MDX expression used to for a subset that’s associated with a hierarchy.
v11,v12
HierarchySubsetMDXSet
Inserts a MDX expression to a public subset.
HierarchySubsetMDXSet
Inserts a MDX expression to a public subset.
v11,v12
HierarchyTimeLastUpdated
Returns a number which refers to the last time the hierarchy was updated. This is a consecutive number that counts the days since 01/01/1900. 
HierarchyTimeLastUpdated
Returns a number which refers to the last time the hierarchy was updated. This is a consecutive number that counts the days since 01/01/1900. 
v11,v12
HierarchyTopElementInsert
Adds a root element to a hierarchy, if there isn't any root element in it. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use HierarchyTopElementInsertDirect.
HierarchyTopElementInsert
Adds a root element to a hierarchy, if there isn't any root element in it. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use HierarchyTopElementInsertDirect.
v11,v12
HierarchyTopElementInsertDirect
Adds a root element to target hierarchy if there isn’t any root element in it. This function is actioned immediately.
HierarchyTopElementInsertDirect
Adds a root element to target hierarchy if there isn’t any root element in it. This function is actioned immediately.
v11,v12
HierarchyUpdateDirect
Performs a full rewrite of a hierarchy that has been subject to direct editing.
HierarchyUpdateDirect
Performs a full rewrite of a hierarchy that has been subject to direct editing.
v11,v12
HttpResponseGetBody
Returns the body of the response to the previously executed HTTP request.
HttpResponseGetBody
Returns the body of the response to the previously executed HTTP request.
v12
HttpResponseGetHeader
Returns a specified response header of the previously executed HTTP request.
HttpResponseGetHeader
Returns a specified response header of the previously executed HTTP request.
v12
HttpResponseGetStatusCode
Returns the status code of the response to the previously executed HTTP request.
HttpResponseGetStatusCode
Returns the status code of the response to the previously executed HTTP request.
v12
IF
Uses a conditional expression to check if an expression is true or false. 
IF
Uses a conditional expression to check if an expression is true or false. 
v11,v12
INSRT
Inserts one string into another string at the given position number.
Rules TI
Refer to Rules for syntax
INSRT
Inserts one string into another string at the given position number.
v11,v12
TI
Refer to Rules for syntax
INT
Returns the largest value that is less than or equals to a specified value. 
Rules TI
Refer to Rules for syntax
INT
Returns the largest value that is less than or equals to a specified value. 
v11,v12
TI
Refer to Rules for syntax
ISLEAF
Determines if an element is leaf element or not.
ISLEAF
Determines if an element is leaf element or not.
v11,v12
ISUND
Returns 1 if the argument value is undefined.  
Rules TI
Refer to Rules for syntax
ISUND
Returns 1 if the argument value is undefined.  
v11,v12
TI
Refer to Rules for syntax
ISUNDEFINEDCELLVALUE
Compares the argument value with default numeric cube value and returns 1 if the cell value is equal to cube’s default value. 
Rules TI
Refer to Rules for syntax
ISUNDEFINEDCELLVALUE
Compares the argument value with default numeric cube value and returns 1 if the cell value is equal to cube’s default value. 
v11,v12
TI
Refer to Rules for syntax
ItemReject
Skips the current source data transaction like ItemSkip. However, ItemReject allows us to write a custom message in the log file.
ItemReject
Skips the current source data transaction like ItemSkip. However, ItemReject allows us to write a custom message in the log file.
v11,v12
ItemSkip
Skips the current transaction in the process.
ItemSkip
Skips the current transaction in the process.
v11,v12
LevelCount
Returns the number of levels in a dimension
LevelCount
Returns the number of levels in a dimension
v11,v12
LN
Converts a number into an absolute value. returns the natural base e logarithm of a number.
Rules TI
Refer to Rules for syntax
LN
Converts a number into an absolute value. returns the natural base e logarithm of a number.
v11,v12
TI
Refer to Rules for syntax
LOG
Returns the base 10 logarithm of a positive number.
Rules TI
Refer to Rules for syntax
LOG
Returns the base 10 logarithm of a positive number.
v11,v12
TI
Refer to Rules for syntax
LogOutput
Writes a message to the tm1server.log file. 
LogOutput
Writes a message to the tm1server.log file. 
v11,v12
LONG
Returns the length of the string. 
Rules TI
Refer to Rules for syntax
LONG
Returns the length of the string. 
v11,v12
TI
Refer to Rules for syntax
LOWER
Converts text characters to lower case. 
Rules TI
Refer to Rules for syntax
LOWER
Converts text characters to lower case. 
v11,v12
TI
Refer to Rules for syntax
MAX
Returns the largest number between two numbers.   
Rules TI
Refer to Rules for syntax
MAX
Returns the largest number between two numbers.   
v11,v12
TI
Refer to Rules for syntax
MetadataMinorErrorCount
A global variable that counts minor errors that occur in the Metadata portion in a process. For each minor error encountered, the variable value is incremented by 1.
MetadataMinorErrorCount
A global variable that counts minor errors that occur in the Metadata portion in a process. For each minor error encountered, the variable value is incremented by 1.
v11,v12
MIN
Returns the smallest number between two numbers.  
Rules TI
Refer to Rules for syntax
MIN
Returns the smallest number between two numbers.  
v11,v12
TI
Refer to Rules for syntax
MinorErrorLogMax
Sets the maximum number of minor errors written in the TM1 process error log file.
MinorErrorLogMax
Sets the maximum number of minor errors written in the TM1 process error log file.
v11,v12
MOD
Returns the remainder after a number is divided by a divisor. 
Rules TI
Refer to Rules for syntax
MOD
Returns the remainder after a number is divided by a divisor. 
v11,v12
TI
Refer to Rules for syntax
MONTH
Returns the month from a date in a numeric format. 
Rules TI
Refer to Rules for syntax
MONTH
Returns the month from a date in a numeric format. 
v11,v12
TI
Refer to Rules for syntax
NewDateFormatter
Sets the date format used with ParseDate and FormatDate function.
NewDateFormatter
Sets the date format used with ParseDate and FormatDate function.
v11,v12
NOW
Returns the current Time in a serial number format.   
Rules TI
Refer to Rules for syntax
NOW
Returns the current Time in a serial number format.   
v11,v12
TI
Refer to Rules for syntax
NumberToString
Converts a numeric value into a string.
NumberToString
Converts a numeric value into a string.
v11,v12
NumberToStringEx
Converts a numeric value into a string based on a specific numeric format string, specified decimal separator and specified thousands separator.
NumberToStringEx
Converts a numeric value into a string based on a specific numeric format string, specified decimal separator and specified thousands separator.
v11,v12
NUMBR
Converts string character to a number. 
Rules TI
Refer to Rules for syntax
NUMBR
Converts string character to a number. 
v11,v12
TI
Refer to Rules for syntax
NumericGlobalVariable
Declare a numeric global variable.
NumericGlobalVariable
Declare a numeric global variable.
v11,v12
NValue
A TM1 reserved local variable. We don’t need to define this variable to use it in the TM1 script. However, we can only use this variable when the DatasourceType is cube view and the current cell value is numeric. 
NValue
A TM1 reserved local variable. We don’t need to define this variable to use it in the TM1 script. However, we can only use this variable when the DatasourceType is cube view and the current cell value is numeric. 
v11,v12
ODBCClose
Closes an ODBC connection.
ODBCClose
Closes an ODBC connection.
v11,v12
ODBCOpen
Opens a connection between TM1 to an ODBC database.
ODBCOpen
Opens a connection between TM1 to an ODBC database.
v11,v12
ODBCOpenEx
Opens an ODBC data source for output specifying that the connection should be opened as a Unicode connection.
ODBCOpenEx
Opens an ODBC data source for output specifying that the connection should be opened as a Unicode connection.
v11,v12
ODBCOutput
Executes a SQL query from TM1 to an ODBC database. Used in conjunction with ODBCOpen.
ODBCOutput
Executes a SQL query from TM1 to an ODBC database. Used in conjunction with ODBCOpen.
v11,v12
OnMinorErrorDoItemSkip
Instructs the process to skip to the next record when a minor error is encountered.
OnMinorErrorDoItemSkip
Instructs the process to skip to the next record when a minor error is encountered.
v11,v12
ParseDate
Parses a date string according to a formatter defined with the NewDateFormatter function. 
ParseDate
Parses a date string according to a formatter defined with the NewDateFormatter function. 
v11,v12
PAYMT
Returns the payment amount of an annuity based on the principal amount, rate, and number of periods
Rules TI
Refer to Rules for syntax
PAYMT
Returns the payment amount of an annuity based on the principal amount, rate, and number of periods
v11,v12
TI
Refer to Rules for syntax
ProcessAttrDelete
Deletes a process attribute. 
ProcessAttrDelete
Deletes a process attribute. 
v11,v12
ProcessAttrInsert
Creates a process attribute. 
ProcessAttrInsert
Creates a process attribute. 
v11,v12
ProcessAttrN
Retrieves data from a numeric attribute for a process. 
ProcessAttrN
Retrieves data from a numeric attribute for a process. 
v11,v12
ProcessAttrNL
Retrieves data from a numeric attribute for a process, for a given language
ProcessAttrNL
Retrieves data from a numeric attribute for a process, for a given language
v11,v12
ProcessAttrPutN
Uploads data to a numeric attribute for a process.
ProcessAttrPutN
Uploads data to a numeric attribute for a process.
v11,v12
ProcessAttrPutS
Upload to a string attribute for a process.
ProcessAttrPutS
Upload to a string attribute for a process.
v11,v12
ProcessAttrS
Retrieves data from a string attribute for a process. 
ProcessAttrS
Retrieves data from a string attribute for a process. 
v11,v12
ProcessAttrSL
Retrieves data from a string attribute for a process for a given language
ProcessAttrSL
Retrieves data from a string attribute for a process for a given language
v11,v12
ProcessBreak
Stops processing any data and moves straight to the Epilog.
ProcessBreak
Stops processing any data and moves straight to the Epilog.
v11,v12
ProcessError
Immediately terminates the process and produces an error.
ProcessError
Immediately terminates the process and produces an error.
v11,v12
ProcessExists
Checks if a process exists. 1 is returned if the process exist, 0 if it does not exist. If a process exists, but has compilation errors, -1 is returned.
ProcessExists
Checks if a process exists. 1 is returned if the process exist, 0 if it does not exist. If a process exists, but has compilation errors, -1 is returned.
v11,v12
ProcessQuit
Immediately terminates the process and returns a Process Quit message.
ProcessQuit
Immediately terminates the process and returns a Process Quit message.
v11,v12
ProcessReturnCode
A global variable that stores the exist status of the most recently executed process.
ProcessReturnCode
A global variable that stores the exist status of the most recently executed process.
v11,v12
ProcessRollback
Terminates the process and begins a rollback. ProcessRollback cancels all pending edits and terminates the process with an error message. 
ProcessRollback
Terminates the process and begins a rollback. ProcessRollback cancels all pending edits and terminates the process with an error message. 
v11,v12
PrologMinorErrorCount
A global variable that counts minor errors that occur in the Prolog. For each minor error encountered, the variable value is incremented by 1.
PrologMinorErrorCount
A global variable that counts minor errors that occur in the Prolog. For each minor error encountered, the variable value is incremented by 1.
v11,v12
PublishSubset
Converts a private subset to public.
PublishSubset
Converts a private subset to public.
v11,v12
PublishView
Converts a private cube view to public.
PublishView
Converts a private cube view to public.
v11,v12
PV
Returns the initial or principal value of an annuity
Rules TI
Refer to Rules for syntax
PV
Returns the initial or principal value of an annuity
v11,v12
TI
Refer to Rules for syntax
RAND
Function generates a random number. 
Rules TI
Refer to Rules for syntax
RAND
Function generates a random number. 
v11,v12
TI
Refer to Rules for syntax
RefreshMDXHierarchy
Refresh MDX hierarchies without requiring a server restart.
RefreshMDXHierarchy
Refresh MDX hierarchies without requiring a server restart.
v11
RemoveCAMIDAssociation
Removes all associations of a specified CAMID with TM1 user groups. 
RemoveCAMIDAssociation
Removes all associations of a specified CAMID with TM1 user groups. 
v11
RemoveCAMIDAssociationFromGroup
Removes an association between a TM1 user group and a CAMID.
RemoveCAMIDAssociationFromGroup
Removes an association between a TM1 user group and a CAMID.
v11
RemoveClientFromGroup
Removes a client from a TM1 user group.
RemoveClientFromGroup
Removes a client from a TM1 user group.
v11,v12
ROUND
Function rounds a number to the nearest integer. 
Rules TI
Refer to Rules for syntax
ROUND
Function rounds a number to the nearest integer. 
v11,v12
TI
Refer to Rules for syntax
ROUNDP
Rounds a number at a specified decimal precision. 
Rules TI
Refer to Rules for syntax
ROUNDP
Rounds a number at a specified decimal precision. 
v11,v12
TI
Refer to Rules for syntax
RuleLoadFromFile
Loads a text file that contain rules to a Cube
RuleLoadFromFile
Loads a text file that contain rules to a Cube
v11,v12
RunProcess
Run multiple processes in parallel. This function can speed up data loads and other processes by dividing work into multiple parts. Each process thread is managed by TM1 Server. 
RunProcess
Run multiple processes in parallel. This function can speed up data loads and other processes by dividing work into multiple parts. Each process thread is managed by TM1 Server. 
v11,v12
SaveDataAll
Saves all changes made on the TM1 server. This moves the changes from memory to disk and restarts the log file. 
SaveDataAll
Saves all changes made on the TM1 server. This moves the changes from memory to disk and restarts the log file. 
v11
SCAN
Searches the specified substring within a string and returns the starting position of the substring. 
Rules TI
Refer to Rules for syntax
SCAN
Searches the specified substring within a string and returns the starting position of the substring. 
v11,v12
TI
Refer to Rules for syntax
SecurityOverlayCreateGlobalDefault
Creates Security Overlay cube for a specific cube with a dimension map based on the dimension order in the cube, to lock and unlock specific intersections at cell level.
SecurityOverlayCreateGlobalDefault
Creates Security Overlay cube for a specific cube with a dimension map based on the dimension order in the cube, to lock and unlock specific intersections at cell level.
v11,v12
SecurityOverlayDestroyGlobalDefault
Deletes the Security Overlay cube for a specific cube with a dimension map based on the dimension order in the cube. 
SecurityOverlayDestroyGlobalDefault
Deletes the Security Overlay cube for a specific cube with a dimension map based on the dimension order in the cube. 
v11,v12
SecurityOverlayGlobalLockCell
Locks or unlocks specific intersection or cell in the cube based on the combination of dimension elements assigned in the Security Overlay cube of a specific cube. 
SecurityOverlayGlobalLockCell
Locks or unlocks specific intersection or cell in the cube based on the combination of dimension elements assigned in the Security Overlay cube of a specific cube. 
v11,v12
SecurityOverlayGlobalLockNode
Locks or unlocks specific intersection or cell in the cube based on the combination of dimension elements assigned in the Security Overlay cube of a specific cube.
SecurityOverlayGlobalLockNode
Locks or unlocks specific intersection or cell in the cube based on the combination of dimension elements assigned in the Security Overlay cube of a specific cube.
v11,v12
SecurityRefresh
Applies any security changes to the TM1 Server. This function reads all the security control cubes and apply security changes to the TM1 Server. 
SecurityRefresh
Applies any security changes to the TM1 Server. This function reads all the security control cubes and apply security changes to the TM1 Server. 
v11,v12
ServerActiveSandboxGet
Returns the name of the active sandbox for the user. If no sandbox is set as active, the function returns a blank string.  
ServerActiveSandboxGet
Returns the name of the active sandbox for the user. If no sandbox is set as active, the function returns a blank string.  
v11,v12
ServerActiveSandboxSet
Sets an existing sandbox as active for the user.  
ServerActiveSandboxSet
Sets an existing sandbox as active for the user.  
v11,v12
ServerSandboxClone
Creates a sandbox that is a copy of an existing one.  
ServerSandboxClone
Creates a sandbox that is a copy of an existing one.  
v11,v12
ServerSandboxCreate
Creates a new Sandbox for the user. 
ServerSandboxCreate
Creates a new Sandbox for the user. 
v11,v12
ServerSandboxDiscardAllChanges
Discards all changes for a given sandbox owned by the user who executed the process.
ServerSandboxDiscardAllChanges
Discards all changes for a given sandbox owned by the user who executed the process.
v11,v12
ServerSandboxesDelete
Delete user sandboxes from the TM1 server (Admin use only)
ServerSandboxesDelete
Delete user sandboxes from the TM1 server (Admin use only)
v11,v12
ServerSandboxExists
Checks if a sandbox exists for a user. It returns a numeric value of 1 if the sandbox exists or 0 if it does not exist. 
ServerSandboxExists
Checks if a sandbox exists for a user. It returns a numeric value of 1 if the sandbox exists or 0 if it does not exist. 
v11,v12
ServerSandboxGet
Returns the name of a user sandbox using an index. 
ServerSandboxGet
Returns the name of a user sandbox using an index. 
v11,v12
ServerSandboxListCountGet
Returns the number of a sandboxes a user has. 
ServerSandboxListCountGet
Returns the number of a sandboxes a user has. 
v11,v12
ServerSandboxMerge
Merges a source sandbox into a target sandbox for the user who executed the process. 
ServerSandboxMerge
Merges a source sandbox into a target sandbox for the user who executed the process. 
v11,v12
ServerShutdown
Shuts down the TM1 Server
ServerShutdown
Shuts down the TM1 Server
v11
SetChoreVerboseMessages
Turn on or off more detailed messages to the tm1s.log file. 
SetChoreVerboseMessages
Turn on or off more detailed messages to the tm1s.log file. 
v11
SetDimensionGroupsSecurity
Sets level of security to a dimension for non-admin groups. 
SetDimensionGroupsSecurity
Sets level of security to a dimension for non-admin groups. 
v11,v12
SetElementGroupsSecurity
Sets level of security to an element for non-admin groups. 
SetElementGroupsSecurity
Sets level of security to an element for non-admin groups. 
v11,v12
SetHierarchyElementGroupsSecurity
Sets level of security to an element on a hierarchy to non-admin groups.
SetHierarchyElementGroupsSecurity
Sets level of security to an element on a hierarchy to non-admin groups.
v11,v12
SetHierarchyGroupsSecurity
Sets level of security for a hierarchy to non-admin groups. 
SetHierarchyGroupsSecurity
Sets level of security for a hierarchy to non-admin groups. 
v11,v12
SetInputCharacterSet
Specify the encoding used in the data source.  
SetInputCharacterSet
Specify the encoding used in the data source.  
v11,v12
SetODBCUnicodeInterface
Sets whether the ODBC interface should use the Unicode wide functions or the regular single-byte character functions. Setting this function to 1 uses the wide character ODBC interface.
SetODBCUnicodeInterface
Sets whether the ODBC interface should use the Unicode wide functions or the regular single-byte character functions. Setting this function to 1 uses the wide character ODBC interface.
v11
SetOutputCharacterSet
Specifies the character set when writing to a text file using TextOutput. 
SetOutputCharacterSet
Specifies the character set when writing to a text file using TextOutput. 
v11,v12
SetOutputEscapeDoubleQuote
Retains or removes double quotes when outputting element names or data values to a text file.
SetOutputEscapeDoubleQuote
Retains or removes double quotes when outputting element names or data values to a text file.
v11,v12
SetUseActiveSandboxProperty
Set whether the process reads/writes cube data to the base or active sandbox for the user.  
SetUseActiveSandboxProperty
Set whether the process reads/writes cube data to the base or active sandbox for the user.  
v11,v12
SIGN
Determines if the number is positive or negative. 
Rules TI
Refer to Rules for syntax
SIGN
Determines if the number is positive or negative. 
v11,v12
TI
Refer to Rules for syntax
SIN
Returns the sine of an angle expressed in radians.
Rules TI
Refer to Rules for syntax
SIN
Returns the sine of an angle expressed in radians.
v11,v12
TI
Refer to Rules for syntax
SKIPCHECK
Forces TM1 engine to skip the check of all N level empty cells in a cube. 
Rules TI
Refer to Rules for syntax
SKIPCHECK
Forces TM1 engine to skip the check of all N level empty cells in a cube. 
v11,v12
TI
Refer to Rules for syntax
Sleep
Pauses a process for a specified interval.
Sleep
Pauses a process for a specified interval.
v11,v12
SQRT
Returns the square root of a give value. 
Rules TI
Refer to Rules for syntax
SQRT
Returns the square root of a give value. 
v11,v12
TI
Refer to Rules for syntax
STET
Cancels the effect of rule for a specified element. 
STET
Cancels the effect of rule for a specified element. 
v11,v12
STR
Converts number to a string character.  
Rules TI
Refer to Rules for syntax
STR
Converts number to a string character.  
v11,v12
TI
Refer to Rules for syntax
StringGlobalVariable
Defines a string global variable. 
StringGlobalVariable
Defines a string global variable. 
v11,v12
StringToNumber
Converts a string into a numeric value.
StringToNumber
Converts a string into a numeric value.
v11,v12
StringToNumberEx
Converts a string value into a number, based on a specified decimal and thousand separator.
StringToNumberEx
Converts a string value into a number, based on a specified decimal and thousand separator.
v11,v12
SUBNM
Returns an element from a dimension set
SUBNM
Returns an element from a dimension set
v11,v12
SubsetAliasGet
Retrieves the alias used for a subset.
SubsetAliasGet
Retrieves the alias used for a subset.
v11,v12
SubsetAliasSet
Sets the alias attribute in the Subset.  
SubsetAliasSet
Sets the alias attribute in the Subset.  
v11,v12
SubsetAttrDelete
Deletes a subset attribute from the dimension.   
SubsetAttrDelete
Deletes a subset attribute from the dimension.   
v11,v12
SubsetAttrInsert
Creates a string, numeric or alias subset attribute for a dimension. 
SubsetAttrInsert
Creates a string, numeric or alias subset attribute for a dimension. 
v11,v12
SubsetATTRN
Retrieves a value from a subset’s numeric attribute. 
SubsetATTRN
Retrieves a value from a subset’s numeric attribute. 
v11,v12
SubsetAttrNL
Retrieves a value from a subset’s numeric attribute for a given language. If the attribute is not defined for the language code, then the function returns the base attribute value. 
SubsetAttrNL
Retrieves a value from a subset’s numeric attribute for a given language. If the attribute is not defined for the language code, then the function returns the base attribute value. 
v11,v12
SubsetAttrPutN
Updates a numeric attribute from a subset. 
SubsetAttrPutN
Updates a numeric attribute from a subset. 
v11,v12
SubsetAttrPutS
Updates a string attribute from a subset. 
SubsetAttrPutS
Updates a string attribute from a subset. 
v11,v12
SubsetAttrS
Retrieves a string attribute from a subset. 
SubsetAttrS
Retrieves a string attribute from a subset. 
v11,v12
SubsetAttrSL
Retrieves a string attribute from a subset based on the local language code. If the attribute is not defined for the language code, then the function returns the base attribute value.  
SubsetAttrSL
Retrieves a string attribute from a subset based on the local language code. If the attribute is not defined for the language code, then the function returns the base attribute value.  
v11,v12
SubsetCreate
Creates a subset in a dimension.  
SubsetCreate
Creates a subset in a dimension.  
v11,v12
SubsetCreateByMDX
Creates a public subset based on a MDX statement.  
SubsetCreateByMDX
Creates a public subset based on a MDX statement.  
v11,v12
SubsetDeleteAllElements
Deletes all elements from a public subset. 
SubsetDeleteAllElements
Deletes all elements from a public subset. 
v11,v12
SubsetDestroy
Deletes a subset.  
SubsetDestroy
Deletes a subset.  
v11,v12
SubsetElementDelete
Deletes an element from a public subset. 
SubsetElementDelete
Deletes an element from a public subset. 
v11,v12
SubsetElementExists
Checks if an element exists in the specified public subset. If an element exists in the subset then it returns 1 otherwise it returns 0.  
SubsetElementExists
Checks if an element exists in the specified public subset. If an element exists in the subset then it returns 1 otherwise it returns 0.  
v11,v12
SubsetElementGetIndex
Retrieves an element’s index in a subset. If the element doesn’t exist in the subset, then the function returns 0. If the index is not between 1 and the size of the subset then the function return error and process will be aborted. 
SubsetElementGetIndex
Retrieves an element’s index in a subset. If the element doesn’t exist in the subset, then the function returns 0. If the index is not between 1 and the size of the subset then the function return error and process will be aborted. 
v11,v12
SubsetElementInsert
Adds an element in an existing subset. 
SubsetElementInsert
Adds an element in an existing subset. 
v11,v12
SubsetExists
Checks if a public subset exists. The function returns a 1 if the subset exists in the dimension, otherwise it returns 0. 
SubsetExists
Checks if a public subset exists. The function returns a 1 if the subset exists in the dimension, otherwise it returns 0. 
v11,v12
SubsetExpandAboveSet
Sets expand above to a subset. It returns 1 if successful otherwise it returns 0.  
SubsetExpandAboveSet
Sets expand above to a subset. It returns 1 if successful otherwise it returns 0.  
v11,v12
SubsetFormatStyleSet
Applies an existing display style to a named subset.
SubsetFormatStyleSet
Applies an existing display style to a named subset.
v11,v12
SubsetGetElementName
Retrieves an element’s name from a subset based on an index. 
SubsetGetElementName
Retrieves an element’s name from a subset based on an index. 
v11,v12
SubsetGetSize
Returns the number of elements in a subset.  
SubsetGetSize
Returns the number of elements in a subset.  
v11,v12
SubsetIsAllSet
Sets all elements to a public subset
SubsetIsAllSet
Sets all elements to a public subset
v11,v12
SubsetMDXGet
Retrieves the MDX statement used for a subset.  
SubsetMDXGet
Retrieves the MDX statement used for a subset.  
v11,v12
SubsetMDXSet
Applies a MDX expression to a public subset. If the subset doesn’t exist, then an error will occur.  
SubsetMDXSet
Applies a MDX expression to a public subset. If the subset doesn’t exist, then an error will occur.  
v11,v12
SUBSIZ
Returns the number of members in a dimension set.
SUBSIZ
Returns the number of members in a dimension set.
v11,v12
SUBST
Returns the substring of a specified string. 
Rules TI
Refer to Rules for syntax
SUBST
Returns the substring of a specified string. 
v11,v12
TI
Refer to Rules for syntax
SValue
A TM1 reserved local variable. We don’t need to define this variable to use it in the TM1 script. However, we can only use this variable when the DatasourceType is cube view and the current cell value is string.  
SValue
A TM1 reserved local variable. We don’t need to define this variable to use it in the TM1 script. However, we can only use this variable when the DatasourceType is cube view and the current cell value is string.  
v11,v12
Synchronized
Forces processes to run in sequence.  
Synchronized
Forces processes to run in sequence.  
v11,v12
TABDIM
Returns the dimension name in a cube based on an index
Excel Rules TI
Refer to Excel for syntax
TABDIM
Returns the dimension name in a cube based on an index
v11,v12
Rules
TI
Refer to Excel for syntax
TAN
Returns the tangent of an angle expressed in radians.
Rules TI
Refer to Rules for syntax
TAN
Returns the tangent of an angle expressed in radians.
v11,v12
TI
Refer to Rules for syntax
TextOutput
Writes and generate a text file in the specified path. 
TextOutput
Writes and generate a text file in the specified path. 
v11,v12
TIME
Returns the current Time from the TM1 server in a string format. 
Rules TI
Refer to Rules for syntax
TIME
Returns the current Time from the TM1 server in a string format. 
v11,v12
TI
Refer to Rules for syntax
TIMST
Returns a formatted date/time in a string format.
Rules TI
Refer to Rules for syntax
TIMST
Returns a formatted date/time in a string format.
v11,v12
TI
Refer to Rules for syntax
TIMVL
Returns a formatted date/time in a string format. 
Rules TI
Refer to Rules for syntax
TIMVL
Returns a formatted date/time in a string format. 
v11,v12
TI
Refer to Rules for syntax
TM1ELLIST
Returns elements based on a list of elements, MDX or set
TM1ELLIST
Returns elements based on a list of elements, MDX or set
v11,v12
TM1GLOBALSANDBOX
Returns the active sandbox for the user
TM1GLOBALSANDBOX
Returns the active sandbox for the user
v11,v12
TM1INFO
Returns information on the TM1 client
TM1INFO
Returns information on the TM1 client
v11,v12
TM1PRIMARYDBNAME
Returns the primary TM1 server name the user is authenticated in
TM1PRIMARYDBNAME
Returns the primary TM1 server name the user is authenticated in
v11,v12
TM1ProcessError.LOG
Generates a log file when a process encounters an error. 
TM1ProcessError.LOG
Generates a log file when a process encounters an error. 
v11,v12
TM1RptElIsConsolidated
Returns a boolean value if an element is consolidated
TM1RptElIsConsolidated
Returns a boolean value if an element is consolidated
v11,v12
TM1RptElIsExpanded
Returns a boolean value if an element is expanded on the row set
TM1RptElIsExpanded
Returns a boolean value if an element is expanded on the row set
v11,v12
TM1RptElLev
Returns an element’s level relative to the root in the subset
TM1RptElLev
Returns an element’s level relative to the root in the subset
v11,v12
TM1RptFilter
Apply a filter to the Dynamic report to sort the row based on a column
TM1RptFilter
Apply a filter to the Dynamic report to sort the row based on a column
v11,v12
TM1RptRow
Returns the row set in a Dynamic Report
TM1RptRow
Returns the row set in a Dynamic Report
v11,v12
TM1RptTitle
Used to define the title dimension
TM1RptTitle
Used to define the title dimension
v11,v12
TM1RptView
Controls the definition of the report like zero suppression and the format area
TM1RptView
Controls the definition of the report like zero suppression and the format area
v11,v12
TM1User
Returns the user logged in
Refer to Excel for syntax
TM1User
Returns the user logged in
v11,v12
TI
Refer to Excel for syntax
TM1Val
A hierarchy-aware formula that reads, writes, or clears a cell which works with TM1 Web and IBM Planning Analytics for Excel.
TM1Val
A hierarchy-aware formula that reads, writes, or clears a cell which works with TM1 Web and IBM Planning Analytics for Excel.
v11,v12
TODAY
Returns the current date in a string yy-dd-mm format. 
Rules TI
Refer to Rules for syntax
TODAY
Returns the current date in a string yy-dd-mm format. 
v11,v12
TI
Refer to Rules for syntax
TRIM
Removes any leading and trailing spaces from a string. 
Rules TI
Refer to Rules for syntax
TRIM
Removes any leading and trailing spaces from a string. 
v11,v12
TI
Refer to Rules for syntax
UNDEF
Returns the undefined value.
Rules TI
Refer to Rules for syntax
UNDEF
Returns the undefined value.
v11,v12
TI
Refer to Rules for syntax
UNDEFINEDCELLVALUE
Returns the default numeric cube value. 
Rules TI
Refer to Rules for syntax
UNDEFINEDCELLVALUE
Returns the default numeric cube value. 
v11,v12
TI
Refer to Rules for syntax
UNDEFVALS
Changes the default value for the cube from zero to a special undefined value.
Rules TI
Refer to Rules for syntax
UNDEFVALS
Changes the default value for the cube from zero to a special undefined value.
v11,v12
TI
Refer to Rules for syntax
UPPER
Converts text characters to upper case. 
Rules TI
Refer to Rules for syntax
UPPER
Converts text characters to upper case. 
v11,v12
TI
Refer to Rules for syntax
Value_Is_String
A reserved local variable that checks if the data source type is a string or number. If the function return ‘1’, then the value is a string,  otherwise it is numeric. For reserved variables, we don’t need to define it in the script. 
Value_Is_String
A reserved local variable that checks if the data source type is a string or number. If the function return ‘1’, then the value is a string,  otherwise it is numeric. For reserved variables, we don’t need to define it in the script. 
v11,v12
VIEW
Sets up an optimised view for a cube that is cached in memory, so it can be referenced quicker
VIEW
Sets up an optimised view for a cube that is cached in memory, so it can be referenced quicker
v11,v12
ViewAttrDelete
Deletes a view attribute from a cube.  
ViewAttrDelete
Deletes a view attribute from a cube.  
v11,v12
ViewAttrInsert
Creates a new attribute for a cube view.  
ViewAttrInsert
Creates a new attribute for a cube view.  
v11,v12
ViewAttrN
Returns a numeric attribute from a cube view.
ViewAttrN
Returns a numeric attribute from a cube view.
v11,v12
ViewAttrNL
Returns a numeric attribute from a cube view for a given language
ViewAttrNL
Returns a numeric attribute from a cube view for a given language
v11,v12
ViewAttrPutN
Inserts a numeric value to an attribute for a cube view. 
ViewAttrPutN
Inserts a numeric value to an attribute for a cube view. 
v11,v12
ViewAttrPutS
Inserts a string to an attribute for a cube view.
ViewAttrPutS
Inserts a string to an attribute for a cube view.
v11,v12
ViewAttrS
Returns a string from a cube view’s attribute. 
ViewAttrS
Returns a string from a cube view’s attribute. 
v11,v12
ViewAttrSL
Returns a string from a cube view’s attribute for a given language. 
ViewAttrSL
Returns a string from a cube view’s attribute for a given language. 
v11,v12
ViewColumnDimensionSet
Sets the dimension in a column position for a cube view.  
ViewColumnDimensionSet
Sets the dimension in a column position for a cube view.  
v11,v12
ViewColumnSuppressZeroesSet
Hide or display columns containing zero values in a cube view. 
ViewColumnSuppressZeroesSet
Hide or display columns containing zero values in a cube view. 
v11,v12
ViewConstruct
Pre-calculates a view and stores the view in memory for faster access.  
ViewConstruct
Pre-calculates a view and stores the view in memory for faster access.  
v11,v12
ViewCreate
ViewCreate creates an empty view for a cube.  
ViewCreate
ViewCreate creates an empty view for a cube.  
v11,v12
ViewCreateByMDX
Creates a cube view with a MDX expression. 
ViewCreateByMDX
Creates a cube view with a MDX expression. 
v11,v12
ViewDestroy
Deletes cube view 
ViewDestroy
Deletes cube view 
v11,v12
ViewExists
Checks whether a view exists. If the view exists, the result is 1 and if it does not exist the result is 0.
ViewExists
Checks whether a view exists. If the view exists, the result is 1 and if it does not exist the result is 0.
v11,v12
ViewExtractFilterByTitlesSet
Skip or include elements in the title axis when exporting a view using ASCIIOutput. Use in the Prolog tab.
ViewExtractFilterByTitlesSet
Skip or include elements in the title axis when exporting a view using ASCIIOutput. Use in the Prolog tab.
v11,v12
ViewExtractSkipCalcsSet
Skip or include consolidated values when exporting a view using ASCIIOutput. Use in the Prolog tab.
ViewExtractSkipCalcsSet
Skip or include consolidated values when exporting a view using ASCIIOutput. Use in the Prolog tab.
v11,v12
ViewExtractSkipConsolidatedStringsSet
Skip or include strings on consolidated values when exporting a view using ASCIIOutput.
ViewExtractSkipConsolidatedStringsSet
Skip or include strings on consolidated values when exporting a view using ASCIIOutput.
v11,v12
ViewExtractSkipRuleValuesSet
Skip or include ruled values when exporting a view using ASCIIOutput.
ViewExtractSkipRuleValuesSet
Skip or include ruled values when exporting a view using ASCIIOutput.
v11,v12
ViewExtractSkipZeroesSet
Skip or include zeros when exporting a view using ASCIIOutput.
ViewExtractSkipZeroesSet
Skip or include zeros when exporting a view using ASCIIOutput.
v11,v12
ViewMDXGet
Retrieves the MDX expression for a cube view.
ViewMDXGet
Retrieves the MDX expression for a cube view.
v11,v12
ViewMDXSet
Sets the MDX expression for a cube view. 
ViewMDXSet
Sets the MDX expression for a cube view. 
v11,v12
ViewRowDimensionSet
Sets the row for a cube view. 
ViewRowDimensionSet
Sets the row for a cube view. 
v11,v12
ViewRowSuppressZeroesSet
Hides or displays rows containing zero values in a cube view.  
ViewRowSuppressZeroesSet
Hides or displays rows containing zero values in a cube view.  
v11,v12
ViewSubsetAssign
Assigns a named subset in a view.
ViewSubsetAssign
Assigns a named subset in a view.
v11,v12
ViewSuppressZeroesSet
Hides or displays all rows and columns containing zero values in a cube view.
ViewSuppressZeroesSet
Hides or displays all rows and columns containing zero values in a cube view.
v11,v12
ViewTitleDimensionSet
Set a dimension to the title position for a cube view.
ViewTitleDimensionSet
Set a dimension to the title position for a cube view.
v11,v12
ViewTitleElementSet
Sets an element to a dimension in the title position for a cube view.
ViewTitleElementSet
Sets an element to a dimension in the title position for a cube view.
v11,v12
ViewZeroOut
Zeroes out all data to a cube view.
ViewZeroOut
Zeroes out all data to a cube view.
v11,v12
WaitForAllJobs
Instructs a main process to wait for all specified asynchronously executed processes to complete before continuing the main process.
WaitForAllJobs
Instructs a main process to wait for all specified asynchronously executed processes to complete before continuing the main process.
v12
WaitForAnyJobs
Instructs a main process to wait for any processes that have been asynchronously executed to complete before continuing the main process.
WaitForAnyJobs
Instructs a main process to wait for any processes that have been asynchronously executed to complete before continuing the main process.
v12
WaitForInternalJobs
Waits for all asynchronous jobs that are directly launched by the current process to complete before continuing the current process.
WaitForInternalJobs
Waits for all asynchronous jobs that are directly launched by the current process to complete before continuing the current process.
v12
While
Repeats a set of command until a condition is true
While
Repeats a set of command until a condition is true
v11,v12
WildcardFileSearch
Searches files using wildcard characters in a folder.
WildcardFileSearch
Searches files using wildcard characters in a folder.
v11,v12
YEAR
Returns the year from a date in a numeric format. 
Refer to Rules for syntax
YEAR
Returns the year from a date in a numeric format. 
v11,v12
Refer to Rules for syntax