Metadata

The Entity Data Model (EDM) defines the TM1 data model that is based on OData Version 4.0 Part 3: Common Schema Definition Language (CSDL). It defines the TM1 data model in a common way so that OData clients can understand and manipulate the model.

This document represents version 11.6.0 of the TM1 REST API metadata.

EDM hierarchy

The EDM hierarchy describes the relationship between TM1 entities, their properties, and their navigation properties.

The EDM organizes entities into a hierarchy. Each entity, which is of some entity type, contains properties, each of which defines the data that the entity contains. An entity might also have navigation properties, which represent connections between entities.

EntityType: Annotation
Properties:
ID (Type: String)
Text (Type: String)
Creator (Type: String)
Created (Type: DateTimeOffset)
LastUpdatedBy (Type: String)
LastUpdated (Type: DateTimeOffset)
Navigation properties:
ApplicationContext (Type: ApplicationContextFacetValue)
DimensionalContext (Type: Member)
Attachments (Type: Attachment)
EntityType: ApplicationContextFacet
Properties:
Name (Type: String)
Navigation properties:
Values (Type: ApplicationContextFacetValue)
EntityType: ApplicationContextFacetValue
Properties:
Value (Type: String)
Navigation properties:
Facet (Type: ApplicationContextFacet)
EntityType: Attachment
Properties:
Name (Type: String)
Description (Type: String)
ContentType (Type: String)
Size (Type: Int64)
EntityType: AttributeDefinition
Properties:
Name (Type: String)
Type (Type: tm1.AttributeType)
EntityType: AuditDetail
Properties:
ID (Type: Int64)
TimeStamp (Type: DateTimeOffset)
UserName (Type: String)
Description (Type: String)
ObjectType (Type: String)
ObjectName (Type: String)
EntityType: AuditLogEntry
Properties:
ID (Type: Int64)
TimeStamp (Type: DateTimeOffset)
UserName (Type: String)
Description (Type: String)
ObjectType (Type: String)
ObjectName (Type: String)
Navigation properties:
AuditDetails (Type: AuditDetail)
EntityType: Cellset
Properties:
ID (Type: String)
Navigation properties:
Cube (Type: Cube)
Axes (Type: CellsetAxis)
Cells (Type: CellsetCell)
Bound functions:
GetPartition
Bound actions:
SaveViewAs
Update
UpdateCells
EntityType: CellsetAxis
Properties:
Ordinal (Type: Int32)
Cardinality (Type: Int32)
Navigation properties:
Hierarchies (Type: Hierarchy)
Tuples (Type: CellsetAxisTuple)
EntityType: CellsetAxisTuple
Properties:
Ordinal (Type: Int32)
Navigation properties:
Members (Type: TupleMember)
EntityType: CellsetCell
Properties:
Ordinal (Type: Int64)
Status (Type: tm1.CellStatus)
Value (Type: PrimitiveType)
FormatString (Type: String)
FormattedValue (Type: String)
Updateable (Type: Int32)
RuleDerived (Type: Boolean)
Annotated (Type: Boolean)
Consolidated (Type: Boolean)
NullIntersected (Type: Boolean)
Language (Type: Int32)
HasPicklist (Type: Boolean)
PicklistValues (Type: String))
HasDrillthrough (Type: Boolean)
Navigation properties:
DrillthroughScripts (Type: Drillthrough)
Members (Type: Member)
EntityType: Chore
Properties:
Name (Type: String)
StartTime (Type: DateTimeOffset)
DSTSensitive (Type: Boolean)
Active (Type: Boolean)
ExecutionMode (Type: tm1.ChoreExecutionMode)
Frequency (Type: Duration)
Attributes (Type: tm1.Attributes)
Navigation properties:
LocalizedAttributes (Type: LocalizedAttributes)
Tasks (Type: ChoreTask)
Bound actions:
Activate
Deactivate
Execute
SetServerLocalStartTime
EntityType: ChoreReference
Navigation properties:
Chore (Type: Chore)
EntityType: ChoreTask
Properties:
Step (Type: Int64)
Parameters (Type: Collection(tm1.ChoreTaskParameter))
Navigation properties:
Process (Type: Process)
Chore (Type: Chore)
EntityType: Configuration
Properties:
ServerName (Type: String)
AdminHost (Type: String)
ProductVersion (Type: String)
PortNumber (Type: Int32)
ClientMessagePortNumber (Type: Int32)
HTTPPortNumber (Type: Int32)
IntegratedSecurityMode (Type: Boolean)
SecurityMode (Type: String)
PrincipalName (Type: String)
SecurityPackageName (Type: String)
ClientCAMURIs (Type: String))
WebCAMURI (Type: String)
ClientPingCAMPassport (Type: Int32)
ServerCAMURI (Type: String)
AllowSeparateNandCRules (Type: Boolean)
DistributedOutputDir (Type: String)
DisableSandboxing (Type: Boolean)
JobQueuing (Type: Boolean)
ForceReevaluationOfFeedersForFedCellsOnDataChange (Type: Boolean)
DataBaseDirectory (Type: String)
UnicodeUpperLowerCase (Type: Boolean)
EntityType: Cube
Properties:
Name (Type: String)
Rules (Type: String)
DrillthroughRules (Type: String)
LastSchemaUpdate (Type: DateTimeOffset)
LastDataUpdate (Type: DateTimeOffset)
Attributes (Type: tm1.Attributes)
Navigation properties:
Dimensions (Type: Dimension)
Views (Type: View)
ViewAttributes (Type: AttributeDefinition)
PrivateViews (Type: View)
Annotations (Type: Annotation)
LocalizedAttributes (Type: LocalizedAttributes)
Bound functions:
DimensionsStorageOrder
Bound actions:
CheckFeeders
CheckRules
Load
Lock
ReorderDimensions
TraceCellCalculation
TraceFeeders
Unload
Unlock
Update
UpdateCells
EntityType: CubeDrillthrough
Bound actions:
Execute
EntityType: CubeReference
Navigation properties:
Cube (Type: Cube)
EntityType: Dimension
Properties:
Name (Type: String)
UniqueName (Type: String)
AllLeavesHierarchyName (Type: String)
Attributes (Type: tm1.Attributes)
Navigation properties:
Hierarchies (Type: Hierarchy)
DefaultHierarchy (Type: Hierarchy)
HierarchyAttributes (Type: AttributeDefinition)
LocalizedAttributes (Type: LocalizedAttributes)
Bound actions:
AddAllLeavesHierarchy
Lock
SaveAs
Unlock
EntityType: DimensionReference
Navigation properties:
Dimension (Type: Dimension)
EntityType: Document
Properties:
Size (Type: Int64)
LastUpdated (Type: DateTimeOffset)
Content (Type: Stream)
EntityType: DocumentReference
Navigation properties:
Document (Type: Document)
EntityType: Drillthrough
Properties:
Name (Type: String)
EntityType: Edge
Properties:
ParentName (Type: String)
ComponentName (Type: String)
Weight (Type: Double)
Navigation properties:
Hierarchy (Type: Hierarchy)
Parent (Type: Element)
Component (Type: Element)
EntityType: Element
Properties:
Name (Type: String)
UniqueName (Type: String)
Type (Type: tm1.ElementType)
Level (Type: Int32)
Index (Type: Int32)
Attributes (Type: tm1.Attributes)
Navigation properties:
Hierarchy (Type: Hierarchy)
Parents (Type: Element)
Components (Type: Element)
Edges (Type: Edge)
LocalizedAttributes (Type: LocalizedAttributes)
Bound actions:
SetComponent
EntityType: Entry
Properties:
ID (Type: String)
Name (Type: String)
Attributes (Type: tm1.Attributes)
Navigation properties:
ContainedBy (Type: Folder)
LocalizedAttributes (Type: LocalizedAttributes)
Bound actions:
Copy
Move
EntityType: ErrorLogFile
Properties:
Filename (Type: String)
Content (Type: Stream)
EntityType: Folder
Navigation properties:
Contents (Type: Entry)
PrivateContents (Type: Entry)
EntityType: GitPlan
Properties:
ID (Type: String)
Branch (Type: String)
Force (Type: Boolean)
EntityType: GitPullPlan
Properties:
Commit (Type: tm1.GitCommit)
Operations (Type: String))
ExecutionMode (Type: tm1.GitPlanExecutionMode)
Bound actions:
Execute
EntityType: GitPushPlan
Properties:
NewBranch (Type: String)
NewCommit (Type: tm1.GitCommit)
ParentCommit (Type: tm1.GitCommit)
SourceFiles (Type: String))
Bound actions:
Execute
EntityType: Group
Properties:
Name (Type: String)
Navigation properties:
Users (Type: User)
EntityType: Hierarchy
Properties:
Name (Type: String)
UniqueName (Type: String)
Cardinality (Type: Int32)
Structure (Type: Int32)
Visible (Type: Boolean)
Attributes (Type: tm1.Attributes)
Navigation properties:
Dimension (Type: Dimension)
Elements (Type: Element)
Edges (Type: Edge)
Subsets (Type: Subset)
PrivateSubsets (Type: Subset)
SessionSubsets (Type: Subset)
Members (Type: Member)
AllMember (Type: Member)
DefaultMember (Type: Member)
Levels (Type: Level)
LocalizedAttributes (Type: LocalizedAttributes)
ElementAttributes (Type: AttributeDefinition)
SubsetAttributes (Type: AttributeDefinition)
Bound functions:
RootMembers
Bound actions:
CreateSessionSubset
SaveAs
SetElement
EntityType: Level
Properties:
Number (Type: Int32)
Name (Type: String)
UniqueName (Type: String)
Cardinality (Type: Int32)
Type (Type: Int32)
Navigation properties:
Hierarchy (Type: Hierarchy)
Members (Type: Member)
EntityType: Link
Properties:
URL (Type: String)
EntityType: LocalizedAttributes
Properties:
LocaleID (Type: String)
Attributes (Type: tm1.Attributes)
EntityType: Logger
Properties:
Name (Type: String)
Level (Type: tm1.LogLevel)
EntityType: MDXView
Properties:
MDX (Type: String)
Bound actions:
Execute
EntityType: Member
Properties:
Name (Type: String)
UniqueName (Type: String)
Type (Type: tm1.MemberType)
Ordinal (Type: Int32)
IsPlaceholder (Type: Boolean)
Weight (Type: Double)
Attributes (Type: tm1.Attributes)
Navigation properties:
Hierarchy (Type: Hierarchy)
Level (Type: Level)
Element (Type: Element)
Parent (Type: Member)
Children (Type: Member)
LocalizedAttributes (Type: LocalizedAttributes)
EntityType: MessageLogEntry
Properties:
ID (Type: Int64)
ThreadID (Type: Int64)
SessionID (Type: Int64)
Level (Type: tm1.LogLevel)
TimeStamp (Type: DateTimeOffset)
Logger (Type: String)
Message (Type: String)
EntityType: NativeView
Properties:
Columns (Type: Collection(tm1.ViewAxisSelection))
Rows (Type: Collection(tm1.ViewAxisSelection))
Titles (Type: Collection(tm1.ViewTitle))
SuppressEmptyColumns (Type: Boolean)
SuppressEmptyRows (Type: Boolean)
FormatString (Type: String)
Bound actions:
Execute
EntityType: Process
Properties:
Name (Type: String)
HasSecurityAccess (Type: Boolean)
PrologProcedure (Type: String)
MetadataProcedure (Type: String)
DataProcedure (Type: String)
EpilogProcedure (Type: String)
DataSource (Type: tm1.ProcessDataSource)
Parameters (Type: Collection(tm1.ProcessParameter))
Variables (Type: Collection(tm1.ProcessVariable))
Attributes (Type: tm1.Attributes)
Navigation properties:
LocalizedAttributes (Type: LocalizedAttributes)
ErrorLogs (Type: ProcessErrorLog)
Bound actions:
Compile
Debug
Execute
ExecuteWithReturn
EntityType: ProcessDebugContext
Properties:
ID (Type: String)
Status (Type: tm1.ProcessDebugContextStatus)
LastActivityDuration (Type: Int64)
ObjectLocks (Type: Collection(tm1.ProcessDebugContextObjectLock))
Result (Type: tm1.ProcessExecuteResult)
Navigation properties:
CurrentBreakpoint (Type: ProcessDebugContextBreakpoint)
Process (Type: Process)
CallStack (Type: ProcessDebugContextStackFrame)
Breakpoints (Type: ProcessDebugContextBreakpoint)
Thread (Type: Thread)
Bound actions:
Continue
StepIn
StepOut
StepOver
EntityType: ProcessDebugContextBreakpoint
Properties:
ID (Type: Int32)
Enabled (Type: Boolean)
HitMode (Type: tm1.ProcessDebugContextHitMode)
HitCount (Type: Int64)
Expression (Type: String)
EntityType: ProcessDebugContextDataBreakpoint
Properties:
VariableName (Type: String)
EntityType: ProcessDebugContextLineBreakpoint
Properties:
ProcessName (Type: String)
Procedure (Type: tm1.ProcessProcedure)
LineNumber (Type: Int32)
EntityType: ProcessDebugContextLockBreakpoint
Properties:
ObjectName (Type: String)
ObjectType (Type: String)
LockMode (Type: tm1.ProcessDebugContextLockMode)
EntityType: ProcessDebugContextStackFrame
Properties:
ID (Type: String)
Procedure (Type: tm1.ProcessProcedure)
LineNumber (Type: Int32)
RecordNumber (Type: Int32)
Navigation properties:
Process (Type: Process)
Variables (Type: ProcessDebugContextVariable)
EntityType: ProcessDebugContextVariable
Properties:
Name (Type: String)
Value (Type: PrimitiveType)
EntityType: ProcessErrorLog
Properties:
Timestamp (Type: DateTimeOffset)
Content (Type: Stream)
EntityType: ProcessReference
Navigation properties:
Process (Type: Process)
EntityType: RelationalDrillthrough
Bound actions:
Execute
ExecuteWithRowset
EntityType: Rowset
Properties:
ID (Type: String)
Navigation properties:
Rows (Type: RowsetRow)
EntityType: RowsetRow
Properties:
Ordinal (Type: Int64)
EntityType: SQLDataSource
Properties:
Name (Type: String)
Description (Type: String)
EntityType: Sandbox
Properties:
Name (Type: String)
IsLoaded (Type: Boolean)
IsActive (Type: Boolean)
IsQueued (Type: Boolean)
IncludeInSandboxDimension (Type: Boolean)
Bound actions:
DiscardChanges
Load
Merge
Publish
Unload
EntityType: Server
Properties:
Name (Type: String)
ProductVersion (Type: String)
PortNumber (Type: Int32)
ClientMessagePortNumber (Type: Int32)
HTTPPortNumber (Type: Int32)
UsingSSL (Type: Boolean)
SecurityPackageName (Type: String)
ServicePrincipalName (Type: String)
IntegratedSecurityMode (Type: tm1.SecurityMode)
ClientCAMURI (Type: String)
ClientPingCAMPassport (Type: Int32)
EntityType: ServerSettings
Properties:
ServerName (Type: String)
Access (Type: tm1.AccessSettings)
Administration (Type: tm1.AdministrationSettings)
Modelling (Type: tm1.ModellingSettings)
Performance (Type: tm1.PerformanceSettings)
EntityType: Session
Properties:
ID (Type: Int64)
Context (Type: String)
Active (Type: Boolean)
Navigation properties:
User (Type: User)
Threads (Type: Thread)
Bound actions:
Close
EntityType: Subset
Properties:
Name (Type: String)
UniqueName (Type: String)
Expression (Type: String)
Attributes (Type: tm1.Attributes)
Navigation properties:
Hierarchy (Type: Hierarchy)
Elements (Type: Element)
LocalizedAttributes (Type: LocalizedAttributes)
Bound actions:
SaveAs
SetElement
EntityType: SubsetReference
Navigation properties:
Subset (Type: Subset)
EntityType: Thread
Properties:
ID (Type: Int64)
Type (Type: tm1.ThreadType)
Name (Type: String)
Context (Type: String)
State (Type: String)
Function (Type: String)
ObjectType (Type: String)
ObjectName (Type: String)
RLocks (Type: Int32)
IXLocks (Type: Int32)
WLocks (Type: Int32)
ElapsedTime (Type: Duration)
WaitTime (Type: Duration)
Info (Type: String)
Navigation properties:
Session (Type: Session)
Bound actions:
CancelOperation
EntityType: TransactionLogEntry
Properties:
ID (Type: Int64)
ChangeSetID (Type: String)
TimeStamp (Type: DateTimeOffset)
ReplicationTime (Type: DateTimeOffset)
User (Type: String)
Cube (Type: String)
Tuple (Type: String))
OldValue (Type: PrimitiveType)
NewValue (Type: PrimitiveType)
StatusMessage (Type: String)
EntityType: TupleMember
Properties:
DisplayInfo (Type: Int32)
DisplayInfoAbove (Type: Int32)
EntityType: User
Properties:
Name (Type: String)
FriendlyName (Type: String)
Password (Type: String)
Type (Type: tm1.UserType)
IsActive (Type: Boolean)
Enabled (Type: Boolean)
Navigation properties:
Groups (Type: Group)
Sessions (Type: Session)
Bound actions:
Disconnect
EntityType: View
Properties:
Name (Type: String)
Attributes (Type: tm1.Attributes)
Navigation properties:
Cube (Type: Cube)
LocalizedAttributes (Type: LocalizedAttributes)
EntityType: ViewReference
Navigation properties:
View (Type: View)

EntityContainer: API

The EntityContainer is the top-level container for the EDM.

It defines the resources that comprise the API, including entity sets, singletons, actions, and functions. If an item is defined in the EDM but is not defined within the API entity container, it is bound to another resource defined within the model.

Entity sets

Singletons

Functions

Actions

Entity types

Entity types are structured records consisting of named and typed properties. Entity types contain a key.

Annotation

An element that represents a single annotation.

An annotation applies a term to a model element and defines how to calculate a value for the term application.

Key: ID

OpenType: true

Table 1. Annotation properties
Name Details

ID

The ID of the annotation.

Type: Edm.String

Nullable: false

Text

The text of the annotation.

Type: Edm.String

Creator

The creator of the annotation.

Type: Edm.String

Created

The date that the annotation was created.

Type: Edm.DateTimeOffset

LastUpdatedBy

The ID of the element that updated the annotation.

Type: Edm.String

LastUpdated

The date and time value of the last update of this annotation, with a time zone offset.

Type: Edm.DateTimeOffset

Table 2. Annotation navigation properties
Name Details

ApplicationContext

An interface to the collection of configuration information for the annotation.

Type: Collection(tm1.ApplicationContextFacetValue)

DimensionalContext

An interface to the collection of dimensions for the annotation.

Type: Collection(tm1.Member)

Attachments

Attached documents that provide details and background.

Type: Collection(tm1.Attachment)

ContainsTarget: true

ApplicationContextFacet

The facet of the application context.

Key: Name

Table 3. ApplicationContextFacet properties
Name Details

Name

The name of the application context facet.

Type: Edm.String

Nullable: false

Table 4. ApplicationContextFacet navigation properties
Name Details

Values

The value of the application context facet, see ApplicationContextFacetValue.

Type: Collection(tm1.ApplicationContextFacetValue)

ContainsTarget: true

ApplicationContextFacetValue

A value for a facet of the application context.

Key: Value

Table 5. ApplicationContextFacetValue properties
Name Details

Value

The application context facet value.

Type: Edm.String

Nullable: false

Table 6. ApplicationContextFacetValue navigation properties
Name Details

Facet

The description of the application context facet value, see also ApplicationContextFacet.

Type: tm1.ApplicationContextFacet

Partner: Values

Nullable: false

Attachment

An attached document that provides details and background.

Key: Name

HasStream: true

Table 7. Attachment properties
Name Details

Name

The name of the attachment.

Type: Edm.String

Nullable: false

Description

A description of the attachment.

Type: Edm.String

ContentType

The type of content in the attachment.

Type: Edm.String

Size

The size of the attachment.

Type: Edm.Int64

AttributeDefinition

An interface to describe an attribute.

Added: 10.2.2.1

Key: Name

Table 8. AttributeDefinition properties
Name Details

Name

The name of the attribute.

Type: Edm.String

Nullable: false

Type

The type of the attribute.

Type: tm1.AttributeType

Nullable: false

AuditDetail

An audit detail entry contained by an expandable audit log entry.

An audit detail entry of an expandable audit log that includes detailed actions.

Added: 11.6.0

Key: ID

Table 9. AuditDetail properties
Name Details

ID

The ID of this audit detail entry. ID is not designed for indexing or filtering.

Type: Edm.Int64

Nullable: false

TimeStamp

The date and time of this audit detail entry.

Type: Edm.DateTimeOffset

Nullable: false

UserName

The user who is recorded by this audit detail entry.

Type: Edm.String

Description

The description of this audit detail entry.

Type: Edm.String

Nullable: false

ObjectType

The object type of this audit detail entry.

Type: Edm.String

Nullable: false

ObjectName

The object name of this audit detail entry.

Type: Edm.String

Nullable: false

AuditLogEntry

An audit log entry in the audit log.

An audit log entry that contains timestamp, user name, object type, object name and descriptions.

Added: 11.6.0

Key: ID

Table 10. AuditLogEntry properties
Name Details

ID

The ID of audit log entry. ID is not designed for indexing or filtering.

Type: Edm.Int64

Nullable: false

TimeStamp

The date and time of this audit log entry.

Type: Edm.DateTimeOffset

Nullable: false

UserName

The user who is recorded by this audit log entry.

Type: Edm.String

Description

The description of this audit log entry.

Type: Edm.String

Nullable: false

ObjectType

The type of this audit log entry.

Type: Edm.String

Nullable: false

ObjectName

The name of this audit log entry.

Type: Edm.String

Nullable: false

Table 11. AuditLogEntry navigation properties
Name Details

AuditDetails

The collection of audit detail entries that are contained by this audit log entry.

Type: Collection(tm1.AuditDetail)

Cellset

The result of an execution of a view or an MDX expression.

A cellset represents a snapshot of your data at a certain point in time. You can use the cellset ID within a session instead of running a view or MDX multiple times. Running a view or MDX expression multiple times can yield different results each time and can have an impact on memory resources. When operations on a cellset have completed, you should delete the cellset if you are not ending the session. When a session ends, the cellset is deleted automatically.

Key: ID

Table 12. Cellset properties
Name Details

ID

Read-only property that provides a unique identifier for the cellset for the current session.

The ID does not persist outside of a session because a cellset is transient. You cannot depend on the ID being consistent. If you try to access a cellset by using a previous ID value after the session has ended or when the cellset has been deleted, an error is received.

Type: Edm.String

Nullable: false

Table 13. Cellset navigation properties
Name Details

Cube

The contents of the cellset.

Type: tm1.Cube

Nullable: false

Axes

A collection of axes for the cellset.

Type: Collection(tm1.CellsetAxis)

ContainsTarget: true

Cells

Individual cell value that makes up part of the cellset.

Type: Collection(tm1.CellsetCell)

ContainsTarget: true

CellsetAxis

Key: Ordinal

Table 14. CellsetAxis properties
Name Details

Ordinal

A number that identifies an entity's position in a series.

Type: Edm.Int32

Nullable: false

Cardinality

The cardinality of the cellset axis.

Type: Edm.Int32

Table 15. CellsetAxis navigation properties
Name Details

Hierarchies

A collection of hierarchies for this cellset axis.

Type: Collection(tm1.Hierarchy)

Tuples

A collection of tuples for this cellset axis.

Type: Collection(tm1.CellsetAxisTuple)

ContainsTarget: true

CellsetAxisTuple

Key: Ordinal

Table 16. CellsetAxisTuple properties
Name Details

Ordinal

A number that identifies an entity's position in a series.

Type: Edm.Int32

Nullable: false

Table 17. CellsetAxisTuple navigation properties
Name Details

Members

A collection of members that make up this cellset axis.

Type: Collection(tm1.TupleMember)

CellsetCell

A cell in a cellset.

Key: Ordinal

Table 18. CellsetCell properties
Name Details

Ordinal

A number that identifies an entity's position in a series.

Type: Edm.Int64

Nullable: false

Status

The status of the cell, that is, NULL, DATA, or ERROR.

Type: tm1.CellStatus

Nullable: false

Value

The value of the cell in the cellset.

Type: Edm.PrimitiveType

FormatString

The format of the cell in the cellset.

Type: Edm.String

FormattedValue

The formatted value of the cell in the cellset.

Type: Edm.String

Updateable

A value that indicates whether the cell is updateable.

Type: Edm.Int32

RuleDerived

A Boolean that indicates whether the cell is rule derived.

Type: Edm.Boolean

Annotated

A Boolean that indicates whether the cell is annotated.

Type: Edm.Boolean

Consolidated

A Boolean that indicates whether the cell is consolidated.

Type: Edm.Boolean

NullIntersected

Type: Edm.Boolean

Language

The language of the value of the cell.

Type: Edm.Int32

HasPicklist

A Boolean that indicates whether the value of the cell can be selected from a drop-down list.

Added: 10.2.2.1

Type: Edm.Boolean

PicklistValues

The collection of available values that can be selected from the drop-down list.

Added: 10.2.2.1

Type: Collection(Edm.String)

HasDrillthrough

A Boolean that indicates whether drill-through scripts are defined on the cell.

Added: 10.2.2.6

Type: Edm.Boolean

Table 19. CellsetCell navigation properties
Name Details

DrillthroughScripts

The collection of drill throughs.

Added: 10.2.2.6

Type: Collection(tm1.Drillthrough)

Members

A collection of all members that represent the location, the tuple if you will, of this cell in the cube. Using the cellset's Cells property and expending this Members property effectively returns the flattened cellset.

Added: 10.2.2.7

Type: Collection(tm1.Member)

Chore

Objects that execute one or more processes of TM1 at a user-defined frequency.

Added: 10.2.2.1

Key: Name

Table 20. Chore properties
Name Details

Name

The name of the chore.

Type: Edm.String

Nullable: false

StartTime

The UTC date-time defining the start time of the chore, independent of DST.

Type: Edm.DateTimeOffset

Nullable: false

DSTSensitive

A Boolean that indicates whether the chore start time is sensitive to daily savings time.

Type: Edm.Boolean

Nullable: false

Active

A Boolean that indicates whether the chore is active.

Type: Edm.Boolean

Nullable: false

ExecutionMode

The execution mode of the chore, that is, single or multiple commit.

Type: tm1.ChoreExecutionMode

Nullable: false

Frequency

The frequency of the chore.

Type: Edm.Duration

Attributes

The attributes of the chore.

Type: tm1.Attributes

Table 21. Chore navigation properties
Name Details

LocalizedAttributes

Translated string values for properties of the chore.

Type: Collection(tm1.LocalizedAttributes)

ContainsTarget: true

Tasks

A collection of tasks that make up the chore.

Type: Collection(tm1.ChoreTask)

Partner: Chore

ContainsTarget: true

ChoreReference

A reference to a chore.

Added: 10.2.2.1

BaseType: tm1.Entry

Table 22. ChoreReference navigation properties
Name Details

Chore

The chore that is referenced.

Type: tm1.Chore

ChoreTask

A task to be completed as part of a Chore.

Added: 10.2.2.1

Key: Step

Table 23. ChoreTask properties
Name Details

Step

A step in a task.

Type: Edm.Int64

Nullable: false

Parameters

A collection of parameters for the task.

Type: Collection(tm1.ChoreTaskParameter)

Table 24. ChoreTask navigation properties
Name Details

Process

The process completed in the task.

Type: tm1.Process

Chore

The Chore that the task belongs to.

Deprecated: 11.4.0

Type: tm1.Chore

Partner: Tasks

Nullable: false

Configuration

Specifies configuration parameters as defined in the Tm1s.cfg file for an IBM Cognos TM1 server.

For details about all of the parameters, refer to the comments in the Tm1s.cfg file and the Operations Guide.

Deprecated: 11.0.0

Key: ServerName

Table 25. Configuration properties
Name Details

ServerName

The name of the server.

Type: Edm.String

Nullable: false

AdminHost

The location where TM1 Admin Server is running.

Type: Edm.String

ProductVersion

The product version of the TM1 server.

Type: Edm.String

PortNumber

The port number of the TM1 server, which is used to distinguish between multiple servers running on the same computer.

Type: Edm.Int32

ClientMessagePortNumber

A secondary port used to accept client messages concerning the progress and ultimate cancellation of a lengthy operation without tying up thread reserves.

Type: Edm.Int32

HTTPPortNumber

The port number on which the TM1 server listens for incoming HTTP(S) requests.

Type: Edm.Int32

IntegratedSecurityMode

A Boolean that indicates whether the TM1 server uses integrated security modes.

Type: Edm.Boolean

SecurityMode

The user authentication mode to be used by TM1 server.

Type: Edm.String

PrincipalName

The service principal name (SPN) when using Integrated Login with TM1 Web and constrained delegation.

Type: Edm.String

SecurityPackageName

If you configure the TM1 server to use Integrated Login, the SecurityPackageName parameter defines the security package that authenticates your user name and password in Microsoft Windows.

Type: Edm.String

ClientCAMURIs

A collection of URIs used to authenticate TM1 clients.

Type: Collection(Edm.String)

WebCAMURI

The URI used to authenticate TM1 Web clients.

Type: Edm.String

ClientPingCAMPassport

Indicates the interval, in seconds, that a client should ping the CAM server to keep their passport alive.

Type: Edm.Int32

ServerCAMURI

Specifies the URI for the internal dispatcher that the TM1 server should use to connect to Cognos Authentication Manager (CAM).

Type: Edm.String

AllowSeparateNandCRules

Lets you specify rule expressions for N: and C: levels on separate lines using identical AREA definitions.

Type: Edm.Boolean

DistributedOutputDir

Defines the directory to which TUnits are written when a Cognos Insight distributed application is deployed.

Type: Edm.String

DisableSandboxing

A Boolean that indicates whether users have the ability to use sandboxes across the server.

Type: Edm.Boolean

JobQueuing

A Boolean that indicates whether the TM1 server should use queues to merge sandboxes.

Type: Edm.Boolean

ForceReevaluationOfFeedersForFedCellsOnDataChange

When this parameter is set, a feeder statement is forced to be re-evaluated when data changes.

Type: Edm.Boolean

DataBaseDirectory

Specifies the data directory from which the server loads cubes, dimensions, and other objects.

Type: Edm.String

UnicodeUpperLowerCase

Instructs the TM1 server to identify and handle Unicode object names, preventing the creation of identical Unicode object names that vary only in case.

Type: Edm.Boolean

Cube

Represents a single cube on a TM1 server.

Key: Name

Table 26. Cube properties
Name Details

Name

Name of the cube as it is registered on the server.

Type: Edm.String

Nullable: false

Rules

Cube rules expand the standard hierarchical consolidation operations that you may define within a dimension.

Type: Edm.String

DrillthroughRules

Rules associating drill-through scripts with regions of cells in the cube.

Drill-through processes can return query results against either cubes or relational tables.

Added: 10.2.2.6

Type: Edm.String

LastSchemaUpdate

Last schema update date of the cube.

Type: Edm.DateTimeOffset

LastDataUpdate

Last data update date of the cube.

Type: Edm.DateTimeOffset

Attributes

Captions and resource attributes of the cube.

Type: tm1.Attributes

Table 27. Cube navigation properties
Name Details

Dimensions

Represents dimensions that perform calculations, control labels, and format data entry.

Type: Collection(tm1.Dimension)

Views

Represents a View object on the TM1 Server.

A View is a child object of a Cube. You can retrieve a list of available Views, or find a specific View using the appropriate methods in the Cube class. View objects can be queried for information (such as name or subsets) or changed. Executing a View results in a Cellset object, which can be used to read the actual cell data.

Type: Collection(tm1.View)

Partner: Cube

ContainsTarget: true

ViewAttributes

Specific attributes for each View object of the cube.

Type: Collection(tm1.AttributeDefinition)

ContainsTarget: true

PrivateViews

Private views are accessible only by the user who registered them.

A private registered view is a named object. It persists after the termination of a client session.

Type: Collection(tm1.View)

Partner: Cube

ContainsTarget: true

Annotations

Comments that provide additional information about the cube.

Type: Collection(tm1.Annotation)

LocalizedAttributes

Translated string values for properties of the cube.

Type: Collection(tm1.LocalizedAttributes)

ContainsTarget: true

CubeDrillthrough

A drill through that drills to a view of a cube.

Added: 10.2.2.6

BaseType: tm1.Drillthrough

CubeReference

A reference to a cube.

Added: 10.2.2.1

BaseType: tm1.Entry

Table 28. CubeReference navigation properties
Name Details

Cube

The cube that is referenced.

Type: tm1.Cube

Dimension

Represents a single dimension on a TM1 server.

A dimension is a broad grouping of descriptive data about a major aspect of a business, such as products, dates, or locations. Each dimension includes different levels of members in one or more hierarchies and an optional set of calculated members or special categories.

Key: Name

Table 29. Dimension properties
Name Details

Name

The name of the dimension.

Type: Edm.String

Nullable: false

UniqueName

The caption for the dimension.

Type: Edm.String

AllLeavesHierarchyName

The name of the all leaves hierarchy in a dimension with alternate hierarchies. Defaults to 'Leaves' if no name is specified.

A dimension with more than one hierarchy automatically gets a, system maintained, all leaves hierarchy. The name of this hierarchy, if no name is specified this hierarchy is called "Leaves", can be controlled with this AllLeavesHierarchyName property. Note that the all leaves hierarchy can also be added by calling the AddAllLeavesHierarchy action, which converts the dimension into a multi hierarchy dimension, if not one already, by adding a second, in this case the all leaves, hierarchy.

Added: 11.0.0

Type: Edm.String

Attributes

A property of the dimension.

Attributes have a finite domain within the context of the dimension that they belong to. For example, a dimension for a customer may have attributes that describe the city, region, and country that the customer belongs to.

Type: tm1.Attributes

Table 30. Dimension navigation properties
Name Details

Hierarchies

More specific groupings within a dimension.

For example, for the Years dimension, data can be organized into smaller groups, such as Years, Current Month, and All Dates.

Type: Collection(tm1.Hierarchy)

Partner: Dimension

ContainsTarget: true

DefaultHierarchy

The default hierarchy of the dimension.

Added: 10.2.2.5

Type: tm1.Hierarchy

HierarchyAttributes

Attributes of a hierarchy.

Type: Collection(tm1.AttributeDefinition)

ContainsTarget: true

LocalizedAttributes

Translated string values for properties of the dimensions.

Type: Collection(tm1.LocalizedAttributes)

ContainsTarget: true

DimensionReference

A reference to a dimension.

Added: 10.2.2.1

BaseType: tm1.Entry

Table 31. DimensionReference navigation properties
Name Details

Dimension

The dimension that is referenced.

Type: tm1.Dimension

Document

An attached document.

Added: 10.2.2.1

BaseType: tm1.Entry

Table 32. Document properties
Name Details

Size

The size of the document.

Type: Edm.Int64

LastUpdated

The date and time value of the last update of this document, with a time zone offset.

Added: 11.1.0

Type: Edm.DateTimeOffset

Content

The contents of the document.

Type: Edm.Stream

DocumentReference

A reference to a document.

Added: 10.2.2.1

BaseType: tm1.Entry

Table 33. DocumentReference navigation properties
Name Details

Document

The document that is referenced.

Type: tm1.Document

Drillthrough

The definition of a drill through on the current cell.

Added: 10.2.2.6

Key: Name

Abstract: true

Table 34. Drillthrough properties
Name Details

Name

The name of the drill through.

Type: Edm.String

Nullable: false

Edge

Represents the relationship between two or more hierarchies and their weight.

Key: ParentName, ComponentName

Table 35. Edge properties
Name Details

ParentName

The name of the parent of the component in the hierarchy.

Type: Edm.String

Nullable: false

ComponentName

The name of the component in the hierarchy.

Type: Edm.String

Nullable: false

Weight

The weight of the component in the edge.

Type: Edm.Double

Table 36. Edge navigation properties
Name Details

Hierarchy

The hierarchy of the component in the edge.

Type: tm1.Hierarchy

Partner: Edges

Nullable: false

Parent

The parent of the component.

Type: tm1.Element

Nullable: false

Component

The component.

Type: tm1.Element

Nullable: false

Element

An element in a dimension that identifies the location of a cell in a cube.

Key: Name

Table 37. Element properties
Name Details

Name

The name of the element.

Type: Edm.String

Nullable: false

UniqueName

The element's invariant name.

Type: Edm.String

Type

The type of the element, one of Numeric, String, or Consolidated.

Type: tm1.ElementType

Level

The level to which the element belongs within the dimension hierarchy.

Level 0 identifies leaf elements. Each level of consolidation within the dimension hierarchy is incremented by 1.

Type: Edm.Int32

Index

A value that corresponds to the position of the element within a dimension.

The first element within a dimension has an index value of 1, the second element has an index value of 2, and so on.

Type: Edm.Int32

Attributes

The attributes of the element.

Type: tm1.Attributes

Table 38. Element navigation properties
Name Details

Hierarchy

The hierarchy of the element in the dimension.

Type: tm1.Hierarchy

Partner: Elements

Nullable: false

Parents

The parent element of the element in the hierarchy.

Type: Collection(tm1.Element)

Components

The collection of elements in the dimension.

Type: Collection(tm1.Element)

Edges

The collection of edges in the dimension.

Type: Collection(tm1.Edge)

LocalizedAttributes

Translated string values for properties of the element.

Type: Collection(tm1.LocalizedAttributes)

ContainsTarget: true

Entry

An entry.

Added: 10.2.2.1

Key: Name

Table 39. Entry properties
Name Details

ID

The ID of the entry.

Deprecated: 11.5.0

Type: Edm.String

Nullable: false

Name

The name of the entry.

Type: Edm.String

Nullable: false

Attributes

The attributes of the entry.

Type: tm1.Attributes

Table 40. Entry navigation properties
Name Details

ContainedBy

The folder that contains the entries.

Type: tm1.Folder

LocalizedAttributes

Translated string values for properties of the entry.

Type: Collection(tm1.LocalizedAttributes)

ContainsTarget: true

ErrorLogFile

An error log file

Added: 11.3.0

Key: Filename

Table 41. ErrorLogFile properties
Name Details

Filename

The name of the error log file.

Type: Edm.String

Nullable: false

Content

The content of the process error.

Type: Edm.Stream

Folder

A container for related TM1 objects.

Added: 10.2.2.1

BaseType: tm1.Entry

Table 42. Folder navigation properties
Name Details

Contents

A collection of entries that are in the folder.

Type: Collection(tm1.Entry)

ContainsTarget: true

PrivateContents

A collection of private entries that are in the folder.

Type: Collection(tm1.Entry)

ContainsTarget: true

GitPlan

A plan of pulling or pushing the source of server objects.

Added: 11.5.0

Key: ID

Abstract: true

Table 43. GitPlan properties
Name Details

ID

The ID of the plan.

Type: Edm.String

Nullable: false

Branch

The name of the remote branch.

Type: Edm.String

Nullable: false

Force

A flag which is used to evaluate preconditions.

Type: Edm.Boolean

Nullable: false

GitPullPlan

A plan of pulling source from a remote Git commit.

Added: 11.5.0

BaseType: tm1.GitPlan

Table 44. GitPullPlan properties
Name Details

Commit

The Git commit which contains the source.

Type: tm1.GitCommit

Nullable: false

Operations

The operations that will be performed to read in the resource.

Type: Collection(Edm.String)

ExecutionMode

The execution mode of the Git pull plan, that is, single or multiple commit.

Type: tm1.GitPlanExecutionMode

Nullable: false

GitPushPlan

A plan of pushing server objects to remote Git repository.

Added: 11.5.0

BaseType: tm1.GitPlan

Table 45. GitPushPlan properties
Name Details

NewBranch

The name of the new branch to which the source to be pushed.

Type: Edm.String

Nullable: false

NewCommit

The commit that contains the source generated for the push.

Type: tm1.GitCommit

Nullable: false

ParentCommit

The parent commit of the new commit.

Type: tm1.GitCommit

Nullable: false

SourceFiles

A collection of the sources files in the commit.

Type: Collection(Edm.String)

Group

A user group on a TM1 server.

Key: Name

Table 46. Group properties
Name Details

Name

The name of a user group on the TM1 server.

There are three predefined groups on each server: Admin, DataAdmin, and SecurityAdmin. Other user groups can be created by an administrator as required.

Type: Edm.String

Nullable: false

Table 47. Group navigation properties
Name Details

Users

The names of users in a given group.

Type: Collection(tm1.User)

Partner: Groups

Hierarchy

A hierarchy organizes dimensions into a hierarchical structure, with each dimension representing a different level of the hierarchy.

For example, you have separate dimensions for days, months, and quarters. You group them into a dimension called year.

Key: Name

Table 48. Hierarchy properties
Name Details

Name

The name of the hierarchy.

Type: Edm.String

Nullable: false

UniqueName

The caption of the hierarchy.

Type: Edm.String

Cardinality

The cardinality of a relationship is the number of related rows for each of the two query subjects.

Relationships exist between two query subjects. The cardinality of a relationship is the number of related rows for each of the two query subjects. The rows are related by the expression of the relationship. This expression usually refers to the primary and foreign keys of the underlying tables.

Type: Edm.Int32

Structure

Specifies whether the hierarchy is balanced or unbalanced.

A value of 0 indicates a balanced structure and a value of 2 indicates an unbalanced structure.

Type: Edm.Int32

Visible

Indicates if this hierarchy should be visible to consumers.

A designer of a dimension might opt to use additional hierarchies for modeling purposes and express his or her preference to not make such hierarchy 'visible' using this property. A consumer however is free to ignore this flag, like modeling clients would obviously, if such behavior would be more appropriate. Note: this flag has absolutely no meaning to the server!

Added: 11.0.0

Type: Edm.Boolean

Attributes

The attributes of the hierarchy.

Type: tm1.Attributes

Table 49. Hierarchy navigation properties
Name Details

Dimension

A dimension that is part of the hierarchy.

Type: tm1.Dimension

Partner: Hierarchies

Nullable: false

Elements

The elements of the hierarchy.

Type: Collection(tm1.Element)

Partner: Hierarchy

ContainsTarget: true

Edges

The edges of the hierarchy.

Type: Collection(tm1.Edge)

Partner: Hierarchy

ContainsTarget: true

Subsets

The subsets of the hierarchy.

Type: Collection(tm1.Subset)

Partner: Hierarchy

ContainsTarget: true

PrivateSubsets

The private subsets of the hierarchy.

Type: Collection(tm1.Subset)

Partner: Hierarchy

ContainsTarget: true

SessionSubsets

The session-scoped subsets generated on this hierarchy.

This collection will always appear empty, like the Cellsets collection, but generated SessionSubsets can be retrieved directly by ID.

Type: Collection(tm1.Subset)

Partner: Hierarchy

ContainsTarget: true

Members

The members of the hierarchy.

Type: Collection(tm1.Member)

Partner: Hierarchy

ContainsTarget: true

AllMember

An aggregation of all of the members of the hierarchy.

Type: tm1.Member

Partner: Hierarchy

DefaultMember

The default member of the hierarchy.

Type: tm1.Member

Partner: Hierarchy

Levels

A collection of levels in the hierarchy.

Type: Collection(tm1.Level)

Partner: Hierarchy

ContainsTarget: true

LocalizedAttributes

Translated string values for properties of the hierarchy.

Type: Collection(tm1.LocalizedAttributes)

ContainsTarget: true

ElementAttributes

The attributes of the elements of the hierarchy.

Added: 10.2.2.1

Type: Collection(tm1.AttributeDefinition)

ContainsTarget: true

SubsetAttributes

The attributes of the subsets of the hierarchy.

Type: Collection(tm1.AttributeDefinition)

ContainsTarget: true

Level

A level in the hierarchy of a set of cubes.

Key: Number

Table 50. Level properties
Name Details

Number

The level number.

Type: Edm.Int32

Nullable: false

Name

The name of the level.

Type: Edm.String

Nullable: false

UniqueName

The unique name of the level.

Type: Edm.String

Cardinality

The cardinality of the level, that is, the number of elements in the level.

Type: Edm.Int32

Type

The type of the level.

Type: Edm.Int32

Table 51. Level navigation properties
Name Details

Hierarchy

The hierarchy of the level.

Type: tm1.Hierarchy

Partner: Levels

Nullable: false

Members

The members of the level.

Type: Collection(tm1.Member)

Partner: Level

LocalizedAttributes

A combination of international language codes defined by ISO 639-1 to identify major languages and IETF language tags to identify specific locales.

For example, "fr" identifies French and "fr-CA" identifies Canadian French.

Key: LocaleID

Table 53. LocalizedAttributes properties
Name Details

LocaleID

The ID of the locale. To use the default locale, specify 'Default'.

Type: Edm.String

Nullable: false

Attributes

A set of attributes for the locale.

Type: tm1.Attributes

Logger

A logger to be configured for a TM1 server.

Added: 10.2.2.6

Key: Name

Table 54. Logger properties
Name Details

Name

The name of the logger.

Type: Edm.String

Nullable: false

Level

The level of the logger, that is, Fatal, Error, Warning, Info, Debug, Unknown, or Off.

Type: tm1.LogLevel

Nullable: false

MDXView

A view of a cube that is defined by an MDX expression.

OpenType: true

BaseType: tm1.View

Table 55. MDXView properties
Name Details

MDX

An MDX expression that defines a cube view.

Type: Edm.String

Nullable: false

Member

A set of elements that are members of the consolidation.

Key: Name

Table 56. Member properties
Name Details

Name

The name of the member.

Type: Edm.String

Nullable: false

UniqueName

The name of the member, preceded by the name of the parent, for example, [dimension_name]:[member_name].

Type: Edm.String

Type

The type of the member.

Type: tm1.MemberType

Ordinal

A number that identifies an entity's position in a series.

Type: Edm.Int32

IsPlaceholder

A Boolean that indicates whether this member is a placeholder.

Type: Edm.Boolean

Weight

The weight of the member within a consolidation.

Weight is a factor applied to an individual member when summing the members of a consolidation.

Type: Edm.Double

Attributes

The attributes of the member.

Type: tm1.Attributes

Table 57. Member navigation properties
Name Details

Hierarchy

The hierarchy of the member.

Type: tm1.Hierarchy

Partner: Members

Nullable: false

Level

The level within the hierarchy on which this member resides.

Added: 10.2.2.5

Type: tm1.Level

Partner: Members

Nullable: false

Element

The member element.

Type: tm1.Element

Nullable: false

Parent

The parent of the member in the consolidation.

Type: tm1.Member

Partner: Children

Children

The children of the member in the consolidation.

Type: Collection(tm1.Member)

Partner: Parent

LocalizedAttributes

Translated string values for properties of the member.

Type: Collection(tm1.LocalizedAttributes)

ContainsTarget: true

MessageLogEntry

An entry in the message log.

The message log displays status messages on the activity of the TM1 server in a log file. These messages contain details on activity such as executed processes, chores, loaded cubes and dimensions, and synchronized replication.

Added: 10.2.2.1

Key: ID

Table 58. MessageLogEntry properties
Name Details

ID

The ID of the message log entry.

Type: Edm.Int64

Nullable: false

ThreadID

The thread ID of the message log entry.

Type: Edm.Int64

SessionID

The session ID of the message log entry.

Type: Edm.Int64

Level

The level of the message log entry, that is, Fatal, Error, Warning, Info, Debug, Unknown, Off.

Type: tm1.LogLevel

Nullable: false

TimeStamp

The date and time of the message log entry.

Type: Edm.DateTimeOffset

Logger

The logger of the message log entry.

Type: Edm.String

Nullable: false

Message

The message in the message log entry.

Type: Edm.String

Nullable: false

NativeView

A native view of a cube.

OpenType: true

BaseType: tm1.View

Table 59. NativeView properties
Name Details

Columns

The dimension elements that exist on the column axis of a view.

Type: Collection(tm1.ViewAxisSelection)

Rows

The dimension elements that exist on the row axis of a view.

Type: Collection(tm1.ViewAxisSelection)

Titles

The dimension elements that exist as title (context) elements of a view.

Type: Collection(tm1.ViewTitle)

SuppressEmptyColumns

A Boolean that suppresses any columns that contain only zero values.

Type: Edm.Boolean

SuppressEmptyRows

A Boolean that suppresses any rows that contain only zero values.

Type: Edm.Boolean

FormatString

The format of the elements in the view.

Type: Edm.String

Nullable: false

Process

A TurboIntegrator process that can be used to manipulate TM1 data and metadata.

Key: Name

Table 60. Process properties
Name Details

Name

The name of a TurboIntegrator process.

Type: Edm.String

Nullable: false

HasSecurityAccess

A Boolean that indicates whether the user security access to run this process.

Type: Edm.Boolean

PrologProcedure

The code that is executed during the Prolog stage of the process.

Type: Edm.String

MetadataProcedure

The code that is executed during the Metadata stage of the process.

Type: Edm.String

DataProcedure

The code that is executed during the Data stage of the process.

Type: Edm.String

EpilogProcedure

The code that is executed during the Epilog stage of the process.

Type: Edm.String

DataSource

The source of the data for the process.

Type: tm1.ProcessDataSource

Parameters

Parameters used by the process.

Type: Collection(tm1.ProcessParameter)

Variables

Variables used by the process.

Type: Collection(tm1.ProcessVariable)

Attributes

The attributes of the process.

Type: tm1.Attributes

Table 61. Process navigation properties
Name Details

LocalizedAttributes

Translated string values for properties of the process.

Type: Collection(tm1.LocalizedAttributes)

ContainsTarget: true

ErrorLogs

A collection of error logs for the process.

Added: 10.2.2.2

Type: Collection(tm1.ProcessErrorLog)

ContainsTarget: true

ProcessDebugContext

A debug session of a TurboIntegrator process.

Added: 11.0.0

Key: ID

Table 62. ProcessDebugContext properties
Name Details

ID

Type: Edm.String

Nullable: false

Status

The state of the process that is being debugged.

Type: tm1.ProcessDebugContextStatus

Nullable: false

LastActivityDuration

The number of milliseconds that have elapsed since the last debug action.

Type: Edm.Int64

ObjectLocks

A collection of object locks that are held by the TurboIntegrator process under debug.

Type: Collection(tm1.ProcessDebugContextObjectLock)

Result

Once the process execution has completed this contains the execution results.

Type: tm1.ProcessExecuteResult

Table 63. ProcessDebugContext navigation properties
Name Details

CurrentBreakpoint

The breakpoint that the process is currently paused at.

Type: tm1.ProcessDebugContextBreakpoint

Process

The TurboIntegrator process passed to the debug action.

Type: tm1.Process

Nullable: false

CallStack

The execution stack that represents the current execution state.

Type: Collection(tm1.ProcessDebugContextStackFrame)

ContainsTarget: true

Breakpoints

A list of breakpoints that apply to this debug session.

Type: Collection(tm1.ProcessDebugContextBreakpoint)

ContainsTarget: true

Thread

The thread that is executing the process for the debug session.

Type: tm1.Thread

ProcessDebugContextBreakpoint

A conditional expression that gets evaluated each time the breakpoint is hit. If the expression evaluates to true, execution is paused. Otherwise execution continues.

Valid operators are '=', '<>', '@=', '@<>', '<', '<=', '>', '>=', '&', '%', '~', '+', '-', '*', '/', '\', '^', '|'. Parenthesis and variable names are also supported. Function calls are not allowed. These operators should have the same semantics when used here as they would if used in a TurboIntegrator script.

Added: 11.0.0

Key: ID

Abstract: true

Table 64. ProcessDebugContextBreakpoint properties
Name Details

ID

Type: Edm.Int32

Nullable: false

Enabled

Type: Edm.Boolean

Nullable: false

HitMode

Type: tm1.ProcessDebugContextHitMode

Nullable: false

HitCount

Type: Edm.Int64

Expression

Type: Edm.String

ProcessDebugContextDataBreakpoint

A breakpoint that pauses execution when the named variable is written to.

Added: 11.0.0

BaseType: tm1.ProcessDebugContextBreakpoint

Table 65. ProcessDebugContextDataBreakpoint properties
Name Details

VariableName

Type: Edm.String

Nullable: false

ProcessDebugContextLineBreakpoint

A breakpoint that pauses execution at a specific script line.

Added: 11.0.0

BaseType: tm1.ProcessDebugContextBreakpoint

Table 66. ProcessDebugContextLineBreakpoint properties
Name Details

ProcessName

Type: Edm.String

Nullable: false

Procedure

Type: tm1.ProcessProcedure

Nullable: false

LineNumber

Type: Edm.Int32

Nullable: false

ProcessDebugContextLockBreakpoint

A breakpoint that pauses execution when an object lock is acquired.

Added: 11.0.0

BaseType: tm1.ProcessDebugContextBreakpoint

Table 67. ProcessDebugContextLockBreakpoint properties
Name Details

ObjectName

Type: Edm.String

Nullable: false

ObjectType

Type: Edm.String

Nullable: false

LockMode

Type: tm1.ProcessDebugContextLockMode

Nullable: false

ProcessDebugContextStackFrame

A single frame in the execution stack.

Added: 11.0.0

Key: ID

Table 68. ProcessDebugContextStackFrame properties
Name Details

ID

Type: Edm.String

Nullable: false

Procedure

Type: tm1.ProcessProcedure

Nullable: false

LineNumber

Type: Edm.Int32

Nullable: false

RecordNumber

Type: Edm.Int32

Table 69. ProcessDebugContextStackFrame navigation properties
Name Details

Process

Type: tm1.Process

Nullable: false

Variables

The entire list of active variables available to the process.

Type: Collection(tm1.ProcessDebugContextVariable)

ContainsTarget: true

ProcessDebugContextVariable

Added: 11.0.0

Key: Name

Table 70. ProcessDebugContextVariable properties
Name Details

Name

Type: Edm.String

Nullable: false

Value

Type: Edm.PrimitiveType

ProcessErrorLog

A process error log entry.

Added: 10.2.2.2

Deprecated: 11.3.0

Key: Timestamp

Table 71. ProcessErrorLog properties
Name Details

Timestamp

The date and time of the process error.

Type: Edm.DateTimeOffset

Nullable: false

Content

The content of the process error.

Type: Edm.Stream

ProcessReference

A reference to a process.

Added: 10.2.2.1

BaseType: tm1.Entry

Table 72. ProcessReference navigation properties
Name Details

Process

The process that is referenced.

Type: tm1.Process

RelationalDrillthrough

A drill through that drills to an Open Database Connectivity (ODBC) table.

Added: 10.2.2.6

BaseType: tm1.Drillthrough

Rowset

The result of an execution of a relational drillthrough.

Added: 11.6.0

Key: ID

Table 73. Rowset properties
Name Details

ID

Read-only property that provides a unique identifier for the rowset for the current session.

Type: Edm.String

Nullable: false

Table 74. Rowset navigation properties
Name Details

Rows

Individual row value that makes up part of the rowset.

Type: Collection(tm1.RowsetRow)

ContainsTarget: true

RowsetRow

A row in a rowset.

Added: 11.6.0

Key: Ordinal

OpenType: true

Table 75. RowsetRow properties
Name Details

Ordinal

A number that identifies an entity's position in a series.

Type: Edm.Int64

Nullable: false

SQLDataSource

A representation of a SQL (read: ODBC) data source available on the host on which the TM1 server is running.

Added: 11.2.0

Key: Name

Table 76. SQLDataSource properties
Name Details

Name

The name of the SQL data source.

Type: Edm.String

Nullable: false

Description

A description of the data source.

Type: Edm.String

Sandbox

A sandbox that allows you to work with your data without affecting your base.

Sandboxes allow you to work with your data in different versions, allowing you to add or modify it to see the results without affecting your base. Changes that you make in a sandbox are not made public until you commit the changes. You can continue to work with your data until you are satisfied with the result.

Key: Name

Table 77. Sandbox properties
Name Details

Name

The name of a sandbox.

Type: Edm.String

Nullable: false

IsLoaded

A Boolean that specifies whether the sandbox is loaded into memory. Read-only.

Type: Edm.Boolean

IsActive

A Boolean that indicates whether the current context is an active sandbox.

Used when the !sandbox parameter is used as a query option.

Type: Edm.Boolean

IsQueued

A Boolean that indicates whether the current context is queued and therefore read-only.

Type: Edm.Boolean

IncludeInSandboxDimension

A Boolean that indicates whether the sandbox is to be included in the sandbox dimension.

Added: 11.0.0

Type: Edm.Boolean

Server

A read-only collection of properties of the running server. Available without authenticating.

Added: 11.0.0

Key: Name

Table 78. Server properties
Name Details

Name

The name of the server.

Type: Edm.String

Nullable: false

ProductVersion

The product version of the TM1 server.

Type: Edm.String

PortNumber

The port number of the TM1 server, which is used to distinguish between multiple servers running on the same computer.

Type: Edm.Int32

ClientMessagePortNumber

A secondary port used to accept client messages concerning the progress and ultimate cancellation of a lengthy operation without tying up thread reserves.

Type: Edm.Int32

HTTPPortNumber

The port number on which the TM1 server listens for incoming HTTP(S) requests.

Type: Edm.Int32

UsingSSL

Whether or not the server is configured to use SSL for client connections.

Type: Edm.Boolean

SecurityPackageName

If you configure the TM1 server to use Integrated Login, the SecurityPackageName parameter defines the security package that authenticates your user name and password in Microsoft Windows.

Type: Edm.String

ServicePrincipalName

The service principal name (SPN) when using Integrated Login with TM1 Web and constrained delegation.

Type: Edm.String

IntegratedSecurityMode

The authentication scheme supported by TM1 Server.

Type: tm1.SecurityMode

ClientCAMURI

The URI clients use to connect to the CAM provider to retrieve a CAM passport.

Type: Edm.String

ClientPingCAMPassport

Indicates the interval, in seconds, that a client should ping the CAM server to keep their passport alive.

Type: Edm.Int32

ServerSettings

The settings for a TM1 server.

Added: 11.0.0

Key: ServerName

Table 79. ServerSettings properties
Name Details

ServerName

The name of the TM1 server.

Type: Edm.String

Nullable: false

Access

The access settings of the TM1 server, that is, network, authentication, SSL, CAM, LDAP, CAPI, and HTTP settings.

Type: tm1.AccessSettings

Administration

The administration settings, including client, audit log, debug log, server log, Java, external database, and TM1 Web settings.

Type: tm1.AdministrationSettings

Modelling

The modelling settings of the TM1 server.

Type: tm1.ModellingSettings

Performance

The performance settings of the TM1 server.

Type: tm1.PerformanceSettings

Session

Represents a unique user session with the server.

Added: 10.2.2.5

Key: ID

Table 80. Session properties
Name Details

ID

The ID uniquely identifying the session.

Type: Edm.Int64

Nullable: false

Context

The Context specified by the client to help identifying the consumer of this session.

Added: 11.1.0

Type: Edm.String

Active

A Boolean indicating that the session is still considered active vs. closed with threads actively executing requests.

Added: 11.5.0

Type: Edm.Boolean

Nullable: false

Table 81. Session navigation properties
Name Details

User

The user that is associated to this session.

Type: tm1.User

Partner: Sessions

Nullable: false

Threads

The names of users in a given group.

Type: Collection(tm1.Thread)

Partner: Session

Subset

Key: Name

Table 82. Subset properties
Name Details

Name

The name of the subset.

Type: Edm.String

Nullable: false

UniqueName

The name of the subset, preceded by the parent dimension and separated by a colon, for example, [dimension_name]:[subset_name].

Type: Edm.String

Expression

An MDX expression that defines the subset.

Type: Edm.String

Attributes

The attributes of the subset.

Type: tm1.Attributes

Table 83. Subset navigation properties
Name Details

Hierarchy

The hierarchies that are included in the subset.

Type: tm1.Hierarchy

Nullable: false

Elements

The elements that are included in the subset.

Type: Collection(tm1.Element)

LocalizedAttributes

Translated string values for properties of the subset.

Type: Collection(tm1.LocalizedAttributes)

ContainsTarget: true

SubsetReference

A reference to a subset.

Added: 10.2.2.1

BaseType: tm1.Entry

Table 84. SubsetReference navigation properties
Name Details

Subset

The subset that is referenced.

Type: tm1.Subset

Thread

A thread that can run queries concurrently on the TM1 server.

Added: 10.2.2.1

Key: ID

Table 85. Thread properties
Name Details

ID

The ID of the thread.

Added: 10.2.2.5

Type: Edm.Int64

Nullable: false

Type

The type of thread, that is, user, worker, chore, system.

Type: tm1.ThreadType

Nullable: false

Name

The name of the thread.

Type: Edm.String

Nullable: false

Context

The context of the thread.

Type: Edm.String

Nullable: false

State

The state of the thread.

Type: Edm.String

Nullable: false

Function

The function of the thread.

Type: Edm.String

Nullable: false

ObjectType

The object type of the thread.

Type: Edm.String

Nullable: false

ObjectName

The name of the object that the thread acts on.

Type: Edm.String

Nullable: false

RLocks

A shared lock that allows many threads to read from an object at the same time, but does not allow another thread to modify or write to this object until all R-locks have been released.

Type: Edm.Int32

IXLocks

A lock that reserves the right for a thread to obtain a W-lock on an object when all R-locks have been released.

Type: Edm.Int32

WLocks

An exclusive lock that allows only one thread at a time to access and write changes to an object.

Type: Edm.Int32

ElapsedTime

The elapsed time of a thread in seconds.

Type: Edm.Duration

WaitTime

The wait time (delay) before a thread should start the process.

Type: Edm.Duration

Info

The info of the thread.

Type: Edm.String

Nullable: false

Table 86. Thread navigation properties
Name Details

Session

The Session that this thread is currently servicing.

Type: tm1.Session

Partner: Threads

TransactionLogEntry

An entry in the transaction log.

The transaction log displays the transactions recorded in the Tm1s.log file when a TM1 client changes a cube value.

Added: 10.2.2.1

Key: ID

Table 87. TransactionLogEntry properties
Name Details

ID

The ID of the transaction log entry.

Type: Edm.Int64

Nullable: false

ChangeSetID

The ID of the changeset in the transaction log entry.

Type: Edm.String

TimeStamp

The date and time of the transaction log entry.

Type: Edm.DateTimeOffset

ReplicationTime

The replication time of the TM1 server for the transaction log entry.

Type: Edm.DateTimeOffset

User

The user who completed the changeset in the transaction.

Type: Edm.String

Cube

The cube that was acted on in the transaction.

Type: Edm.String

Tuple

A collection of tuples that were acted on in the transaction.

Type: Collection(Edm.String)

OldValue

The previous value of the changed tuple in the transaction.

Type: Edm.PrimitiveType

NewValue

The new value of the changed tuple in the transaction.

Type: Edm.PrimitiveType

StatusMessage

The status message of the transaction.

Type: Edm.String

TupleMember

Represents a member in a tuple on an axis in a query result.

Added: 11.2.0

BaseType: tm1.Member

Table 88. TupleMember properties
Name Details

DisplayInfo

This property contains various items of information that help an application render the axis.

The DisplayInfo property contains various items of information that help an application render the axis. It is a 4-byte value. The value of the least-significant byte of the least significant word contains the so called drill level. The drill level effectively represents the number of ancestors of a member that preceded the member, hence those ancestors being drilled down, without breaking ancestry. The most significant byte of the least significant word represents the level in the ancestry relative to the ancestor at the root of the tree. In the most-significant 2 bytes, each bit potentially conveys one piece of display information, however for only 3 bits (the least-significant bits) a meaning has been defined. The least-significant bit (rightmost bit), if set, indicates that this member is drilled down. That is, at least one descendant of this member appears on the axis, immediately following all occurrences of that member. The next bit (the second least-significant bit), if set, indicates that the parent of this member is the same as the parent of the member preceding all occurrences of the current member. The last bit (the third least-significant bit), if set, indicates that, with the exception of members that appear at/are at the root, at least one sibling of this member appears on the axis following zero or more descendants of the member.

Type: Edm.Int32

Nullable: false

DisplayInfoAbove

This property contains various items of information that help an application render the axis, presuming children are expanded before their parent.

The DisplayInfoAbove property contains various items of information that help an application render the axis, looking at the content of the axis in reverse order, useful in cases where children are presumed to be expanded before their parent/ancestors. It is a 4-byte value. The value of the least-significant byte of the least significant word contains the so called drill level. The drill level effectively represents the number of ancestors of a member that follow the member, hence those ancestors being drilled down, or rather up in this case, without breaking ancestry. The most significant byte of the least significant word represents the level in the ancestry relative to the ancestor at the root of the tree. In the most-significant 2 bytes, each bit potentially conveys one piece of display information, however for only 3 bits (the least-significant bits) a meaning has been defined. The least-significant bit (rightmost bit), if set, indicates that this member is drilled down, or up in this case. That is, at least one descendant of this member appears on the axis, immediately preceding all occurrences of that member. The next bit (the second least-significant bit), if set, indicates that the parent of this member is the same as the parent of the member following all occurrences of the current member. The last bit (the third least-significant bit), if set, indicates that, with the exception of members that appear at/are at the root, at least one sibling of this member appears on the axis preceding zero or more descendants of the member.

Type: Edm.Int32

Nullable: false

User

A user on a TM1 server.

Key: Name

Table 89. User properties
Name Details

Name

The unique name of the user.

Type: Edm.String

Nullable: false

FriendlyName

The friendly name, also known as the display name, of the user.

Added: 10.2.2.5

Type: Edm.String

Nullable: false

Password

The password for the user.

Type: Edm.String

Type

The type of the user.

Added: 10.2.2.4

Type: tm1.UserType

Nullable: false

IsActive

A Boolean that indicates whether the user is currently logged in to the TM1 server.

Type: Edm.Boolean

Nullable: false

Enabled

A Boolean that indicates whether the user is enabled.

Added: 11.0.0

Type: Edm.Boolean

Nullable: false

Table 90. User navigation properties
Name Details

Groups

The defined groups that the user belongs to. A user can belong to multiple groups.

Type: Collection(tm1.Group)

Partner: Users

Sessions

The set of currently active sessions of this user.

Added: 10.2.2.5

Type: Collection(tm1.Session)

Partner: User

View

A view of data in a cube.

Key: Name

Abstract: true

OpenType: true

Table 91. View properties
Name Details

Name

The name of the view.

Type: Edm.String

Nullable: false

Attributes

The attributes of the view.

Type: tm1.Attributes

Table 92. View navigation properties
Name Details

Cube

The parent cube of the view.

Type: tm1.Cube

Nullable: false

LocalizedAttributes

Translated string values for properties of the view.

Type: Collection(tm1.LocalizedAttributes)

ContainsTarget: true

ViewReference

A reference to a view.

Added: 10.2.2.1

BaseType: tm1.Entry

Table 93. ViewReference navigation properties
Name Details

View

The view that is referenced.

Type: tm1.View

Complex types

Complex types are structured types with a list of properties but with no key. Complex types can exist only as a property of a containing entity or as a temporary value.

AccessSettings

Added: 11.0.0

Table 94. AccessSettings properties
Name Details

Network

Type: tm1.NetworkSettings

Authentication

Type: tm1.AuthenticationSettings

SSL

Type: tm1.SSLSettings

CAM

Type: tm1.CAMSettings

LDAP

Type: tm1.LDAPSettings

CAPI

Type: tm1.CAPISettings

HTTP

Type: tm1.HTTPSettings

AdministrationSettings

Added: 11.0.0

Table 95. AdministrationSettings properties
Name Details

ServerName

Type: Edm.String

AdminHost

Type: Edm.String

Language

Type: Edm.String

DataBaseDirectory

Type: Edm.String

UnicodeUpperLowerCase

Type: Edm.Boolean

MaskUserNameInServerTools

Type: Edm.Boolean

AllowReadOnlyChoreReschedule

Type: Edm.Boolean

DisableSandboxing

Type: Edm.Boolean

RunningInBackground

Type: Edm.Boolean

StartupChores

Type: Collection(Edm.String)

PerformanceMonitorOn

Type: Edm.Boolean

PerfMonActive

Type: Edm.Boolean

EnableSandboxDimension

Type: Edm.Boolean

Clients

Type: tm1.ClientSettings

AuditLog

Type: tm1.AuditLogSettings

DebugLog

Type: tm1.DebugLogSettings

ServerLog

Type: tm1.ServerLogSettings

EventLog

Type: tm1.EventLogSettings

TopLog

Type: tm1.TopLogSettings

Java

Type: tm1.JavaSettings

ExternalDatabase

Type: tm1.ExternalDatabaseSettings

TM1Web

Type: tm1.TM1WebSettings

FileRetry

Type: tm1.FileRetrySettings

DownTime

Type: Edm.String

Attributes

OpenType: true

Table 96. Attributes properties
Name Details

Caption

Type: Edm.String

AuditLogSettings

Added: 11.0.0

Table 97. AuditLogSettings properties
Name Details

Enable

Type: Edm.Boolean

UpdateInterval

Type: Edm.Duration

MaxFileSizeKilobytes

Type: Edm.Int64

MaxQueryMemoryKilobytes

Type: Edm.Int64

AuthenticationSettings

Added: 11.0.0

Table 98. AuthenticationSettings properties
Name Details

SecurityPackageName

Type: Edm.String

ServicePrincipalName

Type: Edm.String

IntegratedSecurityMode

Type: tm1.SecurityMode

MaximumLoginAttempts

Type: Edm.Int32

CAMSettings

Added: 11.0.0

Table 99. CAMSettings properties
Name Details

CAMUseSSL

Type: Edm.Boolean

ClientURI

Type: Edm.String

ServerURIs

Type: Collection(Edm.String)

PortalVariableFile

Type: Edm.String

ClientPingCAMPassport

Type: Edm.Int32

ServerCAMURIRetryAttempts

Type: Edm.Int32

CreateNewCAMClients

Type: Edm.Boolean

CAPISettings

Added: 11.0.0

Table 100. CAPISettings properties
Name Details

Port

Type: Edm.Int32

ClientMessagePort

Type: Edm.Int32

MessageCompression

Type: Edm.Boolean

ProgressMessage

Type: Edm.Boolean

ClientVersionMaximum

Type: Edm.Int32

ClientVersionMinimum

Type: Edm.Int32

ClientVersionPrecision

Type: Edm.Int32

CalculationComponent

Added: 11.1.0

Table 101. CalculationComponent properties
Name Details

Type

The type of calculation (consolidation or rule-driven) that populates this cell.

Type: tm1.CalculationType

Value

The value of this cell.

Type: Edm.PrimitiveType

Statements

The rule statement that populates this cell.

Type: Collection(Edm.String)

Components

The set of components that determine the value of this cell.

Type: Collection(tm1.CalculationComponent)

Table 102. CalculationComponent navigation properties
Name Details

Cube

Cube containing the cell that is a component of the calculation.

Type: tm1.Cube

Tuple

Coordinates of the cell that is a component of the calculation.

Type: Collection(tm1.Element)

CellDescriptor

Added: 10.2.2.1

Table 103. CellDescriptor navigation properties
Name Details

Tuple

Type: Collection(tm1.Element)

CellsetUpdate

Contains the information necessary to perform a spread to a single cell.

The spreading command indicated by Value is applied to the cell specified by Tuple. Optionally, a reference cube and cell can also be specified.

Added: 11.0.0

Table 104. CellsetUpdate properties
Name Details

Ordinal

Type: Edm.Int64

Nullable: false

Value

Type: Edm.String

Nullable: false

Table 105. CellsetUpdate navigation properties
Name Details

ReferenceCube

Type: tm1.Cube

ReferenceCell

Type: Collection(tm1.Element)

ChoreTaskParameter

Added: 10.2.2.1

Table 106. ChoreTaskParameter properties
Name Details

Name

Type: Edm.String

Nullable: false

Value

Type: Edm.PrimitiveType

ClientSettings

Added: 11.0.0

Table 107. ClientSettings properties
Name Details

PasswordMinimumLength

Type: Edm.Int32

ClientPropertiesSyncInterval

Type: Edm.Duration

RetainNonCAMGroupMembership

Type: Edm.Boolean

CubeUpdate

Contains the information necessary to perform a spread to a single cell.

The spreading command indicated by Value is applied to the cell specified by Tuple. Optionally, a reference cube and cell can also be specified.

Added: 11.0.0

Table 108. CubeUpdate properties
Name Details

Value

Type: Edm.String

Nullable: false

Table 109. CubeUpdate navigation properties
Name Details

Tuple

Type: Collection(tm1.Element)

ReferenceCube

Type: tm1.Cube

ReferenceCell

Type: Collection(tm1.Element)

DebugLogSettings

Added: 11.0.0

Table 110. DebugLogSettings properties
Name Details

LoggingDirectory

Type: Edm.String

DrillthroughRow

Added: 10.2.2.6

EventLogSettings

Added: 11.1.0

Table 111. EventLogSettings properties
Name Details

Enable

Type: Edm.Boolean

ScanFrequency

Type: Edm.Duration

ThresholdForThreadRunningTime

Type: Edm.Duration

ThresholdForThreadWaitingTime

Type: Edm.Duration

ThresholdForThreadBlockingNumber

Type: Edm.Int32

ThresholdForPooledMemoryInMB

Type: Edm.Int32

ExternalDatabaseSettings

Added: 11.0.0

Table 112. ExternalDatabaseSettings properties
Name Details

OracleErrorForceRowStatus

Type: tm1.OracleErrorForceRowStatus

SQLFetchType

Type: tm1.SQLFetchType

SQLRowsetSize

Type: Edm.Int32

ODBCLibraryPath

Type: Edm.String

ODBCTimeoutInSeconds

Type: Edm.Int32

FedCellDescriptor

Added: 11.1.0

Table 113. FedCellDescriptor properties
Name Details

Fed

Whether or not the cell is fed.

Type: Edm.Boolean

Table 114. FedCellDescriptor navigation properties
Name Details

Cube

Cube containing the cell.

Type: tm1.Cube

Tuple

Coordinates of the cell.

Type: Collection(tm1.Element)

FeederTrace

Added: 11.1.0

Table 115. FeederTrace properties
Name Details

FedCells

Collection of cells that are fed by the source cell.

Type: Collection(tm1.FedCellDescriptor)

Statements

Collection of feeder statements that have the source cell on the left hand side.

Type: Collection(Edm.String)

FileRetrySettings

Added: 11.0.0

Table 116. FileRetrySettings properties
Name Details

FileRetryCount

Type: Edm.Int32

FileRetryDelayMilliseconds

Type: Edm.Int32

FileRetryFileSpec

Type: Collection(Edm.String)

Git

Added: 11.5.0

Table 117. Git properties
Name Details

URL

The URL of the remote Git repository.

Type: Edm.String

Nullable: false

Deployment

The deployment chosen for current Git operations.

Type: Edm.String

Nullable: false

DeployedCommit

The last commit of the source that is pulled to the server.

Type: tm1.GitCommit

Nullable: false

Remote

The information of the remote Git repository.

Type: tm1.GitRemote

Nullable: false

Config

The configuration parameters.

Type: tm1.GitConfiguration

GitCommit

Added: 11.5.0

Table 118. GitCommit properties
Name Details

ID

The ID of the Git commit.

Type: Edm.String

Nullable: false

Summary

The summary of the Git commit.

Type: Edm.String

Nullable: false

Author

The author of the Git commit.

Type: Edm.String

Nullable: false

GitConfiguration

Added: 11.8.3

OpenType: true

GitRemote

Added: 11.5.0

Table 119. GitRemote properties
Name Details

Connected

Indicates if the TM1 Server can connect to the remote Git repository.

Type: Edm.Boolean

Nullable: false

Branches

The branches in the remote Git repository.

Type: Collection(Edm.String)

Tags

The tags in the remote Git repository.

Type: Collection(Edm.String)

HTTPSettings

Added: 11.0.0

Table 120. HTTPSettings properties
Name Details

Port

Type: Edm.Int32

SessionTimeout

Type: Edm.Duration

SessionMaxRequests

Type: Edm.Int32

RequestEntityMaxSizeInKB

Type: Edm.Int32

JavaSettings

Added: 11.0.0

Table 121. JavaSettings properties
Name Details

ClassPath

Type: Edm.String

JVMPath

Type: Edm.String

JVMArgs

Type: Edm.String

JobQueuingSettings

Added: 11.0.0

Table 122. JobQueuingSettings properties
Name Details

Enable

Type: Edm.Boolean

ThreadSleepTime

Type: Edm.Duration

ThreadPoolSize

Type: Edm.Int32

MaxWaitTime

Type: Edm.Duration

LDAPSettings

Added: 11.0.0

Table 123. LDAPSettings properties
Name Details

Enable

Type: Edm.Boolean

Host

Type: Edm.String

Port

Type: Edm.Int32

UseServerAccount

Type: Edm.Boolean

VerifyCertServerName

Type: Collection(Edm.String)

VerifyServerSSLCert

Type: Edm.Boolean

SkipSSLCertVerification

Type: Edm.Boolean

SkipSSLCRLVerification

Type: Edm.Boolean

WellKnownUserName

Type: Edm.String

PasswordFile

Type: Edm.String

PasswordKeyFile

Type: Edm.String

SearchBase

Type: Edm.String

SearchField

Type: Edm.String

LockingSettings

Added: 11.0.0

Table 124. LockingSettings properties
Name Details

SubsetElementLockBreathing

Type: Edm.Boolean

UseLocalCopiesForPublicDynamicSubsets

Type: Edm.Boolean

PullInvalidationSubsets

Type: Edm.Boolean

MTCubeLoadSettings

Added: 11.8.2

Table 125. MTCubeLoadSettings properties
Name Details

Enabled

Type: Edm.Boolean

Nullable: false

Weight

Type: Edm.Int64

MinFileSize

Type: Edm.Int64

UseBookmarkFiles

Type: Edm.Boolean

MTFeedersSettings

Added: 11.8.2

Table 126. MTFeedersSettings properties
Name Details

Enabled

Type: Edm.Boolean

Nullable: false

AtStartup

Type: Edm.Boolean

MTQSettings

Added: 11.0.0

Table 127. MTQSettings properties
Name Details

UseAllThreads

Type: Edm.Boolean

NumberOfThreadsToUse

Type: Edm.Int32

SingleCellConsolidation

Type: Edm.Boolean

ImmediateCheckForSplit

Type: Edm.Boolean

OperationProgressCheckSkipLoopSize

Type: Edm.Int64

MTFeeders

Deprecated: 11.8.2

Type: Edm.Boolean

MTFeedersAtStartup

Deprecated: 11.8.2

Type: Edm.Boolean

MTQQuery

Type: Edm.Boolean

MemorySettings

Added: 11.0.0

Table 128. MemorySettings properties
Name Details

ApplyMaximumViewSizeToEntireTransaction

Type: Edm.Boolean

DisableMemoryCache

Type: Edm.Boolean

CacheFriendlyMalloc

Type: Edm.Boolean

MaximumViewSizeMB

Type: Edm.Int64

MaximumUserSandboxSizeMB

Type: Edm.Int64

MaximumMemoryForSubsetUndoKB

Type: Edm.Int64

LockPagesInMemory

Type: Edm.Boolean

ModellingSettings

Added: 11.0.0

Table 129. ModellingSettings properties
Name Details

MDXSelectCalculatedMemberInputs

Type: Edm.Boolean

DefaultMeasuresDimension

Type: Edm.Boolean

UserDefinedCalculations

Type: Edm.Boolean

EnableNewHierarchyCreation

Type: Edm.Boolean

Spreading

Type: tm1.SpreadingSettings

TI

Type: tm1.TISettings

Rules

Type: tm1.RulesSettings

Startup

Type: tm1.StartupSettings

Synchronization

Type: tm1.SynchronizationSettings

NameValuePair

Table 130. NameValuePair properties
Name Details

Name

Type: Edm.String

Nullable: false

Value

Type: Edm.PrimitiveType

NetworkSettings

Added: 11.0.0

Table 131. NetworkSettings properties
Name Details

IPAddress

Type: Edm.String

IPVersion

Type: tm1.IPVersion

NetRecvBlockingWaitLimit

Type: Edm.Duration

NetRecvMaxClientIOWaitWithinAPIs

Type: Edm.Duration

IdleConnectionTimeOut

Type: Edm.Duration

ReceiveProgressResponseTimeout

Type: Edm.Duration

PerformanceSettings

Added: 11.0.0

Table 132. PerformanceSettings properties
Name Details

PrivilegeGenerationOptimization

Type: Edm.Boolean

Memory

Type: tm1.MemorySettings

MTCubeLoad

Type: tm1.MTCubeLoadSettings

Nullable: false

MTFeeders

Type: tm1.MTFeedersSettings

Nullable: false

MTQ

Type: tm1.MTQSettings

Nullable: false

Locking

Type: tm1.LockingSettings

ViewCalculation

Type: tm1.ViewCalculationSettings

Stargate

Type: tm1.StargateSettings

JobQueuing

Type: tm1.JobQueuingSettings

ProcessDataSource

OpenType: true

Table 133. ProcessDataSource properties
Name Details

Type

Type: Edm.String

Nullable: false

ProcessDebugContextObjectLock

Added: 11.0.0

Table 134. ProcessDebugContextObjectLock properties
Name Details

ObjectName

Type: Edm.String

Nullable: false

ObjectType

Type: Edm.String

Nullable: false

LockMode

Type: tm1.ProcessDebugContextLockMode

Nullable: false

Scope

Type: tm1.ProcessDebugContextObjectLockScope

Nullable: false

ProcessExecuteResult

A process execution return value.

Table 135. ProcessExecuteResult properties
Name Details

ProcessExecuteStatusCode

The status code return value.

Type: tm1.ProcessExecuteStatusCode

Nullable: false

Table 136. ProcessExecuteResult navigation properties
Name Details

ErrorLogFile

The error log for the process.

Type: tm1.ErrorLogFile

ProcessParameter

Table 137. ProcessParameter properties
Name Details

Name

Type: Edm.String

Nullable: false

Prompt

Type: Edm.String

Value

Type: Edm.PrimitiveType

Type

Type: tm1.ProcessVariableType

Nullable: false

ProcessSyntaxError

Added: 11.0.0

Table 138. ProcessSyntaxError properties
Name Details

Procedure

Type: tm1.ProcessProcedure

Nullable: false

LineNumber

Type: Edm.Int32

Nullable: false

Message

Type: Edm.String

Nullable: false

ProcessVariable

Table 139. ProcessVariable properties
Name Details

Name

Type: Edm.String

Nullable: false

Type

Type: tm1.ProcessVariableType

Nullable: false

Position

Type: Edm.Int32

StartByte

Type: Edm.Int32

EndByte

Type: Edm.Int32

RuleSyntaxError

Added: 11.1.0

Table 140. RuleSyntaxError properties
Name Details

LineNumber

The number of the line containing the error.

Type: Edm.Int32

Message

The error message.

Type: Edm.String

RulesSettings

Added: 11.0.0

Table 141. RulesSettings properties
Name Details

AllowSeparateNandCRules

Type: Edm.Boolean

AutomaticallyAddCubeDependencies

Type: Edm.Boolean

RulesOverwriteCellsOnLoad

Type: Edm.Boolean

ForceReevaluationOfFeedersForFedCellsOnDataChange

Type: Edm.Boolean

SSLSettings

Added: 11.0.0

Table 142. SSLSettings properties
Name Details

Enable

Type: Edm.Boolean

ClientExportServerCertificate

Type: Edm.Boolean

CertificateID

Type: Edm.String

CertificateFile

Type: Edm.String

PrivateKeyPwdFile

Type: Edm.String

PwdKeyFile

Type: Edm.String

CertAuthority

Type: Edm.String

CertRevocationFile

Type: Edm.String

ClientExportServerKeyID

Type: Edm.String

KeyFile

Type: Edm.String

KeyStashFile

Type: Edm.String

KeyLabel

Type: Edm.String

TLSCipherList

Type: Edm.String

FIPSOperationMode

Type: tm1.FIPSMode

NIST_SP800_131A_MODE

Type: Edm.Boolean

ServerLogSettings

Added: 11.0.0

Table 143. ServerLogSettings properties
Name Details

Enable

Type: Edm.Boolean

LogReleaseLineCount

Type: Edm.Int32

SpreadingSettings

Added: 11.0.0

Table 144. SpreadingSettings properties
Name Details

SpreadingPrecision

Type: Edm.Double

ProportionSpreadToZeroCells

Type: Edm.Boolean

StargateSettings

Added: 11.0.0

Table 145. StargateSettings properties
Name Details

ZeroWeightOptimization

Type: Edm.Boolean

AllRuleCalcStargateOptimization

Type: Edm.Boolean

UseStargateForRules

Type: Edm.Boolean

StartupSettings

Added: 11.0.0

Table 146. StartupSettings properties
Name Details

PersistentFeeders

Type: Edm.Boolean

MaximumCubeLoadThreads

Type: Edm.Int32

LoadPrivateSubsetsOnStartup

Type: Edm.Boolean

SynchronizationSettings

Added: 11.0.0

Table 147. SynchronizationSettings properties
Name Details

SyncUnitSize

Type: Edm.Int32

MaximumSynchAttempts

Type: Edm.Int32

TISettings

Added: 11.0.0

Table 148. TISettings properties
Name Details

CognosTM1InterfacePath

Type: Edm.String

UseExcelSerialDate

Type: Edm.Boolean

MaximumTILockObjects

Type: Edm.Int32

EnableTIDebugging

Type: Edm.Boolean

TM1WebSettings

Added: 11.0.0

Table 149. TM1WebSettings properties
Name Details

ExcelWebPublishEnabled

Type: Edm.Boolean

TopLogSettings

Added: 11.5.0

Table 150. TopLogSettings properties
Name Details

Enable

Type: Edm.Boolean

ScanMode

Type: tm1.TopScanMode

ScanFrequency

Type: Edm.Duration

ViewAxisSelection

Table 151. ViewAxisSelection navigation properties
Name Details

Subset

Type: tm1.Subset

Nullable: false

ViewCalculationSettings

Added: 11.0.0

Table 152. ViewCalculationSettings properties
Name Details

MagnitudeDifferenceToBeZero

Type: Edm.Int32

CheckFeedersMaximumCells

Type: Edm.Int64

CalculationThresholdForStorage

Type: Edm.Int64

ViewConsolidationOptimization

Type: Edm.Boolean

ViewConsolidationOptimizationMethod

Type: Edm.String

ViewTitle

Table 153. ViewTitle navigation properties
Name Details

Subset

Type: tm1.Subset

Nullable: false

Selected

Type: tm1.Element

Nullable: false

Enumerated types

Enumerated types are nominal types that represent a series of related values that are known as members.

AttributeType

Added: 10.2.2.1

Members:

  • Numeric : 0
  • String : 1
  • Alias : 2

CalculationType

Added: 11.1.0

Members:

  • Simple : 0
  • Consolidation : 1
  • Rule : 2

CellStatus

Members:

  • Null : 0
  • Data : 1
  • Error : 2

ChoreExecutionMode

Added: 10.2.2.1

Members:

  • SingleCommit : 0
  • MultipleCommit : 1

ConflictResolution

Members:

  • UsingSource : 0
  • UsingTarget : 1
  • Individually : 2

ElementType

Members:

  • Numeric : 1
  • String : 2
  • Consolidated : 3

EncryptionFileType

Members:

  • Object : 1
  • TransactionLog : 2
  • AuditLog : 3

FIPSMode

Added: 11.0.0

Members:

  • FIPS_MODE : 1
  • FIPS_APPROVED : 2
  • FIPS_NONE : 3

GitPlanExecutionMode

Added: 11.5.0

Members:

  • SingleCommit : 0
  • MultipleCommit : 1

IPVersion

Added: 11.0.0

IsFlags: true

Members:

  • IPv4 : 1
  • IPv6 : 2
  • Dual : 3

LogLevel

Added: 10.2.2.1

Members:

  • Fatal : 0
  • Error : 1
  • Warning : 2
  • Info : 3
  • Debug : 4
  • Unknown : 5
  • Off : 6

MemberType

Members:

  • Unknown : 0
  • Regular : 1
  • All : 2
  • Measure : 3
  • Formula : 4

OracleErrorForceRowStatus

Added: 11.0.0

Members:

  • AutoDetect : 0
  • Default : 1
  • UseSQLULEN : 2

ProcessDebugContextHitMode

Added: 11.0.0

Members:

  • BreakAlways : 0
  • BreakEqual : 1
  • BreakGreaterOrEqual : 2

ProcessDebugContextLockMode

Added: 11.0.0

IsFlags: true

Members:

  • None : 0
  • Read : 1
  • ReadOnly : 2
  • IntenteXclusiveNoCopy : 4
  • IntenteXclusive : 8
  • Write : 16
  • Any : 31

ProcessDebugContextObjectLockScope

Added: 11.0.0

Members:

  • Sandbox : 1
  • Shared : 2
  • Temporary : 3

    A temporary lock scope that indicates a thread private object is not visible to other threads and will not cause contention with other threads.

ProcessDebugContextStatus

Added: 11.0.0

Members:

  • Unknown : 0
  • Running : 1
  • Paused : 2
  • Complete : 3

ProcessExecuteStatusCode

Added: 11.3.0

Members:

  • CompletedSuccessfully : 0
  • Aborted : 1
  • HasMinorErrors : 2
  • QuitCalled : 3
  • CompletedWithMessages : 4
  • RollbackCalled : 5

ProcessProcedure

Added: 11.0.0

Members:

  • Prolog : 572
  • Metadata : 573
  • Data : 574
  • Epilog : 575

ProcessVariableType

Members:

  • String : 1
  • Numeric : 2

SQLFetchType

Added: 11.0.0

Members:

  • ExtendedFetch : 1
  • FetchScroll : 2
  • Fetch : 3

SecurityMode

Added: 11.0.0

Members:

  • Basic : 1
  • Integrated : 2
  • Mixed : 3
  • CAM : 4

ThreadType

Added: 10.2.2.1

Members:

  • User : 0
  • Worker : 1
  • Chore : 2
  • System : 3

TopScanMode

Added: 11.5.0

IsFlags: true

Members:

  • Threads : 1
  • Sandboxes : 2
  • SandboxQueueMetrics : 4

UpdateOrder

Added: 11.0.0

Members:

  • NoOrder : 0
  • ByLevel : 1

UserType

Added: 10.2.2.4

Members:

  • User : 0
  • SecurityAdmin : 1
  • DataAdmin : 2
  • Admin : 3
  • OperationsAdmin : 4

    Added: 11.3.0

ViewConsolidationOptimizationMethod

Added: 11.0.0

Members:

  • Tree : 0
  • Array : 1

Functions

Functions in an entity model can have zero or more parameters, and must specify a return type.

ControlCubes

Returns only control cubes in the model.

Control cubes are used for "system use" (for example, localized attribute values) to TM1 (identified with '}'). Control cubes don't contain your actual data.

IsBound: false

Table 154. ControlCubes return types
Type Details
Collection(tm1.Cube)

A collection of control cubes.

Nullable: false

ControlDimensions

Return only control dimensions.

IsBound: false

Table 155. ControlDimensions return types
Type Details
Collection(tm1.Dimension)

A collection of control dimensions.

Nullable: false

Cube.DimensionsStorageOrder

Gets a Cube's Dimensions in current storage order.

Added: 11.4.0

IsBound: true

Table 156. DimensionsStorageOrder parameters
Name Details

Cube

The Cube from which to get the Dimensions in storage order.

Type: tm1.Cube

Nullable: false

Table 157. DimensionsStorageOrder return types
Type Details
Collection(tm1.Dimension)

The Cube's Dimensions in current storage order..

Nullable: false

GetOIDCKeys

Returns OIDC keys. Must be performed by a full admin.

IsBound: false

Table 158. GetOIDCKeys return types
Type Details
Collection(Edm.String)

A collection of OIDC key ids.

Nullable: false

Cellset.GetPartition

Retrieves the cells of a cellset in multiple partitions.

This allows the application to manage processing of the area of the partition based on a defined boundary.

Added: 10.2.2.3

IsBound: true

Table 159. GetPartition parameters
Name Details

Cellset

The collection of cells.

Type: tm1.Cellset

Nullable: false

Begin

Defines the cell ordinal of the left or right corner of the closest rectangular area of your cellset.

Type: Edm.Int64

End

Defines the cell ordinal of the other edge of the closest rectangular area of your cellset.

Type: Edm.Int64

Table 160. GetPartition return types
Type Details
Collection(tm1.CellsetCell)

A collection of cellset cells.

Nullable: false

MessageLog

Returns a collection of message log entries.

By default, the most recent message log entry is returned first.

Added: 10.2.2.1

IsBound: false

Table 161. MessageLog parameters
Name Details

Reverse

A Boolean that indicates whether to order message log entries chronologically as they occurred in time.

Type: Edm.Boolean

Table 162. MessageLog return types
Type Details
Collection(tm1.MessageLogEntry)

A collection of message log entries.

Nullable: false

ModelCubes

Returns only non-control cubes in the model.

IsBound: false

Table 163. ModelCubes return types
Type Details
Collection(tm1.Cube)

A collection of non-control cubes.

If you want all of the cubes (including control), you can use /api/vi/Cubes as a resource identifier.

Nullable: false

ModelDimensions

Returns only model dimensions.

IsBound: false

Table 164. ModelDimensions return types
Type Details
Collection(tm1.Dimension)

A collection of model dimensions.

Nullable: false

Hierarchy.RootMembers

Returns the root members of a hierarchy.

Added: 11.4.7

IsBound: true

Table 165. RootMembers parameters
Name Details

Hierarchy

The hierarchy that the root members belong to.

Type: tm1.Hierarchy

Nullable: false

Table 166. RootMembers return types
Type Details
Collection(tm1.Member)

The collection of the root members.

Nullable: false

TailAuditLog

Initiates change tracking on the audit log.

Initiates change tracking on the audit log and returns a delta link referencing the timestamp end of the audit log.

Added: 11.6.0

IsBound: false

Table 167. TailAuditLog return types
Type Details
Edm.String

Delta link referencing the end of the audit log.

Nullable: false

TailMessageLog

Initiates change tracking on the message log.

Initiates change tracking on the message log and returns a delta link referencing the end of the message log as-is.

Added: 11.3.0

IsBound: false

Table 168. TailMessageLog return types
Type Details
Edm.String

Delta link referencing the end of the message log.

Nullable: false

TailTransactionLog

Initiates change tracking on the transaction log.

Initiates change tracking on the transaction log and returns a delta link referencing the end of the transaction log as-is.

Added: 11.3.0

IsBound: false

Table 169. TailTransactionLog return types
Type Details
Edm.String

Delta link referencing the end of the transaction log.

Nullable: false

TransactionLog

Returns a collection of transaction log entries.

By default, the most recent transaction log entry is returned first.

Added: 10.2.2.1

IsBound: false

Table 170. TransactionLog parameters
Name Details

Reverse

A Boolean that indicates whether to order transaction log entries chronologically as they occurred in time.

Type: Edm.Boolean

IgnoreStatusMessages

A Boolean that indicates whether to include or not include status messages in the translation log.

Type: Edm.Boolean

Table 171. TransactionLog return types
Type Details
Collection(tm1.TransactionLogEntry)

A collection of transaction log entries.

Nullable: false

Actions

Actions in an entity model can have zero or more parameters, and might specify a return type.

Chore.Activate

Activates a chore.

Added: 10.2.2.1

Deprecated: 11.8.3

IsBound: true

Table 172. Activate parameters
Name Details

Chore

The chore to activate.

Type: tm1.Chore

Nullable: false

Dimension.AddAllLeavesHierarchy

Adds the all leaves hierarchy to a single hierarchy dimension and implicitly converts that dimension into a multi hierarchy dimension.

Added: 11.0.0

IsBound: true

Table 173. AddAllLeavesHierarchy parameters
Name Details

Dimension

The dimension to convert into a multi hierarchy dimension and add the all leaves hierarchy to.

Type: tm1.Dimension

Nullable: false

AllLeavesHierarchyName

The name of the all leaves hierarchy (default='Leaves')

Type: Edm.String

Visible

A Boolean indicating if the visible property of the new all leaves hierarchy should be set to true (default=false).

Type: Edm.Boolean

Table 174. AddAllLeavesHierarchy return types
Type Details
tm1.Hierarchy

The newly created all leaves hierarchy.

Nullable: false

BeginChangeSet

Begins a change set.

Added: 10.2.2.6

IsBound: false

Table 175. BeginChangeSet return types
Type Details
Edm.String

The ID of the change set that has begun.

Nullable: false

Thread.CancelOperation

Cancels an operation.

Added: 10.2.2.1

IsBound: true

Table 176. CancelOperation parameters
Name Details

Thread

The thread where the action should be canceled.

Type: tm1.Thread

Nullable: false

Cube.CheckFeeders

Returns a list of components of a consolidation that are not properly fed.

Added: 11.1.0

IsBound: true

Table 177. CheckFeeders parameters
Name Details

Cube

Cube containing the cell that should be checked.

Type: tm1.Cube

Nullable: false

Tuple

Coordinates of the cell that should be checked.

Type: Collection(tm1.Element)

Table 178. CheckFeeders return types
Type Details
Collection(tm1.FedCellDescriptor)

The collection of improperly fed components of the consolidation.

Nullable: false

Cube.CheckRules

Checks the Cube rules for errors.

Added: 11.1.0

IsBound: true

Table 179. CheckRules parameters
Name Details

Cube

The Cube containing the rules to be checked.

Type: tm1.Cube

Nullable: false

Table 180. CheckRules return types
Type Details
Collection(tm1.RuleSyntaxError)

The set of errors in the rules. If no errors are returned, the rules are correct.

Nullable: false

Session.Close

Closes the session.

Added: 10.2.2.5

IsBound: true

Table 181. Close parameters
Name Details

Session

The session being closed.

Type: tm1.Session

Nullable: false

Process.Compile

Added: 11.0.0

IsBound: true

Table 182. Compile parameters
Name Details

Process

Type: tm1.Process

Nullable: false

Table 183. Compile return types
Type Details
Collection(tm1.ProcessSyntaxError)

Nullable: false

CompileProcess

Added: 11.0.0

IsBound: false

Table 184. CompileProcess parameters
Name Details

Process

Type: tm1.Process

Nullable: false

Table 185. CompileProcess return types
Type Details
Collection(tm1.ProcessSyntaxError)

Nullable: false

ProcessDebugContext.Continue

Continues execution of a paused process debug context.

IsBound: true

Table 186. Continue parameters
Name Details

Context

The debug context to continue.

Type: tm1.ProcessDebugContext

Nullable: false

Table 187. Continue return types
Type Details
tm1.ProcessDebugContext  

Entry.Copy

Copies an Entry.

Added: 11.2.0

IsBound: true

Table 188. Copy parameters
Name Details

Entry

The source Entry to be copied.

Type: tm1.Entry

Target

The destination folder. If not specified, the source Entry's parent is used.

Type: tm1.Folder

Private

Whether the new Entry should be private. If not specified, the existing scope is used. Cannot be true if the destination folder is private.

Type: Edm.Boolean

Name

The name of the new Entry.

Type: Edm.String

Table 189. Copy return types
Type Details
tm1.Entry

The new Entry copy.

Nullable: false

Hierarchy.CreateSessionSubset

Creates a session-scoped subset within the hierarchy.

The subset will have a generated name, and will not be listed on any collection. The subsets can be looked up by ID, edited with PATCH, and DELETEd. They may also be used by ID in MDX queries, in place of the subset name. If a named subset exists with the generated ID, the named subset (public or private) will be used in the query instead. These subsets are not persisted and are automatically destroyed when the session expires or is logged out. They cannot be retrieved, modified, or used in an MDX query from another session.

IsBound: true

Table 190. CreateSessionSubset parameters
Name Details

Hierarchy

Implicit first parameter (this action is bound to a Hierarchy).

Type: tm1.Hierarchy

Nullable: false

Subset

Optional. Subset to be copied (if value is supplied with an entity reference) or a definition to be used (if a subset definition is given as an object).

If this parameter is omitted, an empty subset is created. In the case of a subset definition, the Name supplied will be ignored, and an ID will be generated.

Type: tm1.Subset

Table 191. CreateSessionSubset return types
Type Details
tm1.Subset

Newly created session-scoped subset that will be contained by the SessionSubsets collection of the bound hierarchy.

Nullable: false

Chore.Deactivate

Deactivates a chore.

Added: 10.2.2.1

Deprecated: 11.8.3

IsBound: true

Table 192. Deactivate parameters
Name Details

Chore

The chore to deactivate.

Type: tm1.Chore

Nullable: false

Process.Debug

Starts a debug session for a process defined in Turbo Integrator.

IsBound: true

Table 193. Debug parameters
Name Details

Process

The process to start the debug session for.

Type: tm1.Process

Nullable: false

Parameters

Override default values (numeric or string) defined in the model.

Type: Collection(tm1.NameValuePair)

Table 194. Debug return types
Type Details
tm1.ProcessDebugContext  

DecryptDataFile

Decrypts a single file. Must be performed by a full admin.

IsBound: false

Table 195. DecryptDataFile parameters
Name Details

SourcePath

The path to the file to be decrypted.

Type: Edm.String

DestinationPath

The path to the directory where the decrypted file should be stored. If unspecified, the file will be decrypted and replaced.

Type: Edm.String

FileType

The file type of the source file.

Type: tm1.EncryptionFileType

DecryptDataModel

Decrypts the data model. Must be performed by a full admin. Will result in a server shutdown.

IsBound: false

Table 196. DecryptDataModel parameters
Name Details

TimeUntilShutdown

The time until the server shuts down, rounded up to the minute.

Type: Edm.Duration

DeleteAnnotationArtifacts

Removes all annotation-related control cubes and all things related to annotations for the entire model including context facets, comments, attachments, and so on. Use this action with caution because it cannot be undone.

IsBound: false

Sandbox.DiscardChanges

Resets the values in the sandbox back to the base.

IsBound: true

Table 197. DiscardChanges parameters
Name Details

Sandbox

The sandbox to be reset.

Type: tm1.Sandbox

Nullable: false

User.Disconnect

Disconnects a user but lets threads that are active continue to run until they are done.

Added: 10.2.2.6

IsBound: true

Table 198. Disconnect parameters
Name Details

User

The user to disconnect.

Type: tm1.User

Nullable: false

EncryptDataFile

Encrypts a single file. Must be performed by a full admin.

IsBound: false

Table 199. EncryptDataFile parameters
Name Details

SourcePath

The path to the file to be encrypted.

Type: Edm.String

DestinationPath

The path to the directory where the encrypted file should be stored. If unspecified, the file will be encrypted and replaced.

Type: Edm.String

FileType

The file type of the source file.

Type: tm1.EncryptionFileType

EncryptDataModel

Encrypts the data model. Must be performed by a full admin. Will result in a server shutdown.

IsBound: false

Table 200. EncryptDataModel parameters
Name Details

TimeUntilShutdown

The time until the server shuts down, rounded up to the minute.

Type: Edm.Duration

EndChangeSet

Ends a change set.

Added: 10.2.2.6

IsBound: false

Table 201. EndChangeSet parameters
Name Details

ChangeSetID

The ID of the change set to end.

Type: Edm.String

Nullable: false

Table 202. EndChangeSet return types
Type Details
Edm.Int64

The return code of the EndChangeSet action.

Nullable: false

MDXView.Execute

Runs a view against the model.

IsBound: true

Table 203. Execute parameters
Name Details

View

The view to be executed, specified in the resource path of the URL.

Type: tm1.MDXView

Nullable: false

Table 204. Execute return types
Type Details
tm1.Cellset

Nullable: false

NativeView.Execute

Runs a view against the model.

IsBound: true

Table 205. Execute parameters
Name Details

View

The view to be executed, specified in the resource path of the URL.

Type: tm1.NativeView

Nullable: false

Titles

The values of the titles in the title axis that you are slicing the view against.

You must specify all titles, even though you may only want change one.

Type: Collection(tm1.Element)

SuppressEmptyColumns

Columns without a value are not returned in the result set.

Type: Edm.Boolean

SuppressEmptyRows

Rows without a value are not returned in the result set.

Type: Edm.Boolean

Table 206. Execute return types
Type Details
tm1.Cellset

Nullable: false

Process.Execute

Runs a process defined in Turbo Integrator.

Deprecated: 11.3.0

IsBound: true

Table 207. Execute parameters
Name Details

Process

Specifies the process.

This value is not specified because it is obtained by the first parameter in the resource path specified in the URL of a POST operation.

Type: tm1.Process

Nullable: false

Parameters

Override default values (numeric or string) defined in the model.

Type: Collection(tm1.NameValuePair)

CubeDrillthrough.Execute

Drill into a cell.

Added: 10.2.2.6

IsBound: true

Table 208. Execute parameters
Name Details

Drillthrough

The drill through to use.

Type: tm1.CubeDrillthrough

Nullable: false

Table 209. Execute return types
Type Details
tm1.Cellset

Nullable: false

RelationalDrillthrough.Execute

Drill into a cell.

Added: 10.2.2.6

IsBound: true

Table 210. Execute parameters
Name Details

Drillthrough

The drill through to use.

Type: tm1.RelationalDrillthrough

Nullable: false

Table 211. Execute return types
Type Details
Collection(tm1.DrillthroughRow)

Nullable: false

Chore.Execute

Executes a chore.

Added: 10.2.2.2

IsBound: true

Table 212. Execute parameters
Name Details

Chore

The chore to execute.

Type: tm1.Chore

Nullable: false

GitPullPlan.Execute

Execute a Git pull plan.

Added: 11.5.0

IsBound: true

Table 213. Execute parameters
Name Details

GitPlan

The Git pull plan to be executed.

Type: tm1.GitPullPlan

Nullable: false

GitPushPlan.Execute

Execute a Git push plan.

Added: 11.5.0

IsBound: true

Table 214. Execute parameters
Name Details

GitPlan

The Git push plan to be executed.

Type: tm1.GitPushPlan

Nullable: false

ExecuteChore

Runs a chore.

Added: 11.1.1

IsBound: false

Table 215. ExecuteChore parameters
Name Details

Chore

Specifies the chore to be executed.

Type: tm1.Chore

Nullable: false

ExecuteCubeDrillthrough

Drill to the drillthrough process returned cube view.

Added: 11.2.0

IsBound: false

Table 216. ExecuteCubeDrillthrough parameters
Name Details

DrillthroughProcess

A process that returns a handle of a view.

Type: tm1.Process

Nullable: false

Parameters

Parameters used by the process.

Type: Collection(tm1.ProcessParameter)

Table 217. ExecuteCubeDrillthrough return types
Type Details
tm1.Cellset

Nullable: false

ExecuteMDX

Runs an MDX expression at root level.

Added: 10.2.2.1

IsBound: false

Table 218. ExecuteMDX parameters
Name Details

MDX

A string value that represents your expression. Included in the POST body of the request.

Type: Edm.String

Nullable: false

Table 219. ExecuteMDX return types
Type Details
tm1.Cellset

A cellset.

Nullable: false

ExecuteMDXSetExpression

Runs an MDX set expression at root level.

Added: 11.1.0

IsBound: false

Table 220. ExecuteMDXSetExpression parameters
Name Details

MDX

A string value that represents your expression. Included in the POST body of the request.

Type: Edm.String

Nullable: false

Table 221. ExecuteMDXSetExpression return types
Type Details
tm1.CellsetAxis

A cellset axis representing the snapshot of the member set described by the expression

Nullable: false

ExecuteProcess

Runs a process defined in Turbo Integrator.

Added: 11.0.0

Deprecated: 11.3.0

IsBound: false

Table 222. ExecuteProcess parameters
Name Details

Process

Specifies the process to be executed.

This parameter can either reference an existing process or define a transient process that will only exist for the duration of the execution of such process.

Type: tm1.Process

Nullable: false

Parameters

Override default values (numeric or string) defined in the model.

Type: Collection(tm1.NameValuePair)

ExecuteProcessWithReturn

Runs a process defined in Turbo Integrator and returns back the status.

Added: 11.3.0

IsBound: false

Table 223. ExecuteProcessWithReturn parameters
Name Details

Process

Specifies the process to be executed.

This parameter can either reference an existing process or define a transient process that will only exist for the duration of the execution of such process.

Type: tm1.Process

Nullable: false

Parameters

Override default values (numeric or string) defined in the model.

Type: Collection(tm1.NameValuePair)

WithProcess

Optional. A collection of temporary processes available to the main, transient, process being executed.

This parameter can be used to specify a collection of temporary processes that will only be available to the main, transient, process being executed. If the process being executed is not a transient process, this parameter will be ignored. Note that these temporary processes can only be executed using the ExecuteProcess function!

Type: Collection(tm1.Process)

Table 224. ExecuteProcessWithReturn return types
Type Details
tm1.ProcessExecuteResult

Nullable: false

ExecuteRelationalDrillthrough

Drill to relational tables.

Added: 11.2.0

IsBound: false

Table 225. ExecuteRelationalDrillthrough parameters
Name Details

DrillthroughProcess

A process that returns a handle of a SQL or CSV table.

Type: tm1.Process

Nullable: false

Parameters

Parameters used by the process.

Type: Collection(tm1.ProcessParameter)

Table 226. ExecuteRelationalDrillthrough return types
Type Details
Collection(tm1.DrillthroughRow)

Nullable: false

ExecuteRelationalDrillthroughWithRowset

Execute a relational drillthrough to get a rowset of a relational table.

Added: 11.6.0

IsBound: false

Table 227. ExecuteRelationalDrillthroughWithRowset parameters
Name Details

DrillthroughProcess

A process that returns a handle of a SQL or CSV table.

Type: tm1.Process

Nullable: false

Parameters

Parameters used by the process.

Type: Collection(tm1.ProcessParameter)

Table 228. ExecuteRelationalDrillthroughWithRowset return types
Type Details
tm1.Rowset

Nullable: false

Process.ExecuteWithReturn

Runs a process defined in Turbo Integrator and returns back the status.

Added: 11.3.0

IsBound: true

Table 229. ExecuteWithReturn parameters
Name Details

Process

Specifies the process.

This value is not specified because it is obtained by the first parameter in the resource path specified in the URL of a POST operation.

Type: tm1.Process

Nullable: false

Parameters

Override default values (numeric or string) defined in the model.

Type: Collection(tm1.NameValuePair)

Table 230. ExecuteWithReturn return types
Type Details
tm1.ProcessExecuteResult

Nullable: false

RelationalDrillthrough.ExecuteWithRowset

Drill into a cell to get a rowset of a relational table.

Added: 11.6.0

IsBound: true

Table 231. ExecuteWithRowset parameters
Name Details

Drillthrough

The drill through to use.

Type: tm1.RelationalDrillthrough

Nullable: false

Table 232. ExecuteWithRowset return types
Type Details
tm1.Rowset

Nullable: false

GitDeploy

Deploy a model using the source from the specified Git repository.

Added: 11.5.0

IsBound: false

Table 233. GitDeploy parameters
Name Details

URL

The URL of the remote Git repository.

Type: Edm.String

Nullable: false

Username

The username of the remote Git repository.

Type: Edm.String

Nullable: false

Password

The password of the remote Git repository.

Type: Edm.String

Nullable: false

PublicKey

The SSH public key for connecting to the remote Git repository.

Type: Edm.String

Nullable: false

PrivateKey

The SSH private key paired with the SSH public key.

Type: Edm.String

Nullable: false

Passphrase

The passphrase for decrypting the SSH private key.

Type: Edm.String

Nullable: false

Branch

The branch to pull.

Type: Edm.String

Nullable: false

Deployment

The deployment of the repository instance.

Type: Edm.String

Force

A flag which is used to evaluate preconditions.

Type: Edm.Boolean

Nullable: false

Config

The configuration parameters.

Type: tm1.GitConfiguration

GitInit

Initialize TM1 Server's Git environment.

Added: 11.5.0

IsBound: false

Table 234. GitInit parameters
Name Details

URL

The URL of the remote Git repository.

Type: Edm.String

Nullable: false

Username

The username of the remote Git repository.

Type: Edm.String

Password

The password of the remote Git repository.

Type: Edm.String

PublicKey

The SSH public key for connecting to the remote Git repository.

Type: Edm.String

PrivateKey

The SSH private key paired with the SSH public key.

Type: Edm.String

Passphrase

The passphrase for decrypting the SSH private key.

Type: Edm.String

Deployment

The deployment chosen for current Git operations.

Type: Edm.String

Force

Reset existing Git context and initialize.

Type: Edm.Boolean

Nullable: false

Config

The configuration parameters.

Type: tm1.GitConfiguration

Table 235. GitInit return types
Type Details
tm1.Git

Git status.

Nullable: false

GitPull

Fetch a remote branch and create a plan which contains the actions of loading the sources from the branch into the server.

Added: 11.5.0

IsBound: false

Table 236. GitPull parameters
Name Details

Username

The username of the remote Git repository.

Type: Edm.String

Nullable: false

Password

The password of the remote Git repository.

Type: Edm.String

Nullable: false

PublicKey

The SSH public key for connecting to the remote Git repository.

Type: Edm.String

Nullable: false

PrivateKey

The SSH private key paired with the SSH public key.

Type: Edm.String

Nullable: false

Passphrase

The passphrase for decrypting the SSH private key.

Type: Edm.String

Nullable: false

Branch

The branch to pull.

Type: Edm.String

Nullable: false

ExecutionMode

The execution mode of the Git pull plan, that is, single or multiple commit.

Type: tm1.GitPlanExecutionMode

Force

A flag which is used to evaluate preconditions.

Type: Edm.Boolean

Nullable: false

Table 237. GitPull return types
Type Details
tm1.GitPlan

The created Git pull plan.

Nullable: false

GitPush

Generate sources and use those files to create a Git commit to push to the remote Git repository.

Added: 11.5.0

IsBound: false

Table 238. GitPush parameters
Name Details

Username

The username of the remote Git repository.

Type: Edm.String

Nullable: false

Password

The password of the remote Git repository.

Type: Edm.String

Nullable: false

PublicKey

The SSH public key for connecting to the remote Git repository.

Type: Edm.String

Nullable: false

PrivateKey

The SSH private key paired with the SSH public key.

Type: Edm.String

Nullable: false

Passphrase

The passphrase for decrypting the SSH private key.

Type: Edm.String

Nullable: false

Branch

The branch which contains the commit to be used as the parent commit of the new commit to push.

Type: Edm.String

Nullable: false

NewBranch

The branch to create and push on.

Type: Edm.String

Message

The commit message.

Type: Edm.String

Nullable: false

Author

The name of the commit author.

Type: Edm.String

Nullable: false

Email

The Email of the commit author.

Type: Edm.String

Nullable: false

Force

A flag which is used to evaluate preconditions.

Type: Edm.Boolean

Nullable: false

Table 239. GitPush return types
Type Details
tm1.GitPlan

The created Git push plan.

Nullable: false

GitStatus

Check Git status.

Added: 11.5.0

IsBound: false

Table 240. GitStatus parameters
Name Details

Username

The username of the remote Git repository.

Type: Edm.String

Password

The password of the remote Git repository.

Type: Edm.String

PublicKey

The SSH public key for connecting to the remote Git repository.

Type: Edm.String

PrivateKey

The SSH private key paired with the SSH public key.

Type: Edm.String

Passphrase

The passphrase for decrypting the SSH private key.

Type: Edm.String

Table 241. GitStatus return types
Type Details
tm1.Git

Git status.

Nullable: false

GitUninit

Clean up the local Git repository and reset Git context.

Added: 11.5.0

IsBound: false

Table 242. GitUninit parameters
Name Details

Force

A Boolean that indicates whether to reset the Git context.

Type: Edm.Boolean

Nullable: false

Cube.Load

Loads the cube into memory on the server.

Added: 11.6.0

IsBound: true

Table 243. Load parameters
Name Details

Cube

The cube to be loaded.

Type: tm1.Cube

Nullable: false

Sandbox.Load

Loads the sandbox into memory on the server.

This action sets the IsLoaded property for Sandbox entity.

IsBound: true

Table 244. Load parameters
Name Details

Sandbox

The sandbox to be loaded.

Type: tm1.Sandbox

Nullable: false

Cube.Lock

Locks a cube, preventing any users from modifying it until the cube is unlocked.

IsBound: true

Table 245. Lock parameters
Name Details

Cube

The cube to lock.

Type: tm1.Cube

Dimension.Lock

Locks a dimension, preventing any users from modifying it until the dimension is unlocked.

IsBound: true

Table 246. Lock parameters
Name Details

Dimension

The dimension to lock.

Type: tm1.Dimension

Sandbox.Merge

Merges the values of one sandbox with another.

IsBound: true

Table 247. Merge parameters
Name Details

Source

The sandbox to be merged with the target sandbox.

Type: tm1.Sandbox

Nullable: false

Target

The sandbox target that you want to merge to.

Type: tm1.Sandbox

Nullable: false

ConflictResolution

An enumerated value that indicates whether to resolve conflicts using the source, target, or individually.

Type: tm1.ConflictResolution

AllowQueueing

A Boolean that indicates whether to allow queuing.

Type: Edm.Boolean

CleanAfter

A Boolean that indicates whether to clean the sandbox after merging.

Type: Edm.Boolean

Entry.Move

Moves an Entry to a new parent folder, renames an Entry, and publishes or privatizes it.

Added: 11.2.0

IsBound: true

Table 248. Move parameters
Name Details

Entry

The Entry to be moved.

Type: tm1.Entry

Target

The destination folder. If not specified, the existing parent is used.

Type: tm1.Folder

Private

Whether the Entry should be private. If not specified, the existing scope is used. Cannot be true if the destination folder is private.

Type: Edm.Boolean

Name

The new name of the Entry.

Type: Edm.String

Table 249. Move return types
Type Details
tm1.Entry

The moved Entry.

Nullable: false

Sandbox.Publish

Publishes the contents (values) of the sandbox back to base.

The sandbox specified is still available for use and is left unchanged.

IsBound: true

Table 250. Publish parameters
Name Details

Sandbox

Specifies the sandbox to publish.

Type: tm1.Sandbox

Nullable: false

ConflictResolution

An enumerated value that indicates whether to resolve conflicts using the source, target, or individually.

Type: tm1.ConflictResolution

AllowQueueing

A Boolean that indicates whether to allow queuing.

Type: Edm.Boolean

CleanAfter

A Boolean that indicates whether to clean the sandbox after merging.

Type: Edm.Boolean

RemoveOIDCKeyFromCache

Removes OIDC key from server cache. Must be performed by a full admin.

IsBound: false

Table 251. RemoveOIDCKeyFromCache parameters
Name Details

KeyId

Optional. The collection of keys to remove. If this parameter is omitted, all keys are removed.

Type: Collection(Edm.String)

Cube.ReorderDimensions

Reorders a Cube's Dimensions.

Added: 11.4.0

IsBound: true

Table 252. ReorderDimensions parameters
Name Details

Cube

The Cube that should have its dimensions reordered.

Type: tm1.Cube

Nullable: false

Dimensions

The new order of Dimensions.

Type: Collection(tm1.Dimension)

Table 253. ReorderDimensions return types
Type Details
Edm.Double

The percent change in memory usage of the Cube due to the new order.

Nullable: false

RotateDataModelKey

Rotates the model key. Must be performed by a full admin.

IsBound: false

Dimension.SaveAs

Saves a dimension.

Added: 11.0.0

IsBound: true

Table 254. SaveAs parameters
Name Details

Dimension

The dimension to save.

Type: tm1.Dimension

Nullable: false

Name

The name to save the dimension as.

Type: Edm.String

Nullable: false

Overwrite

A Boolean that indicates whether to overwrite the dimension that was passed in if it already exists.

Type: Edm.Boolean

KeepExistingAttributes

A Boolean that indicates whether overwrite any existing attributes for the dimension, and all contained objects, we might be replacing with an overwrite. If the save is not overwriting, and this value is set to true, then no attributes will be created for the new dimension.

Added: 11.0.0

Type: Edm.Boolean

Table 255. SaveAs return types
Type Details
tm1.Dimension

The saved dimension.

Nullable: false

Hierarchy.SaveAs

Saves a hierarchy.

Added: 11.0.0

IsBound: true

Table 256. SaveAs parameters
Name Details

Hierarchy

The hierarchy to save.

Type: tm1.Hierarchy

Nullable: false

Name

The name to save the hierarchy as.

Type: Edm.String

Nullable: false

Overwrite

A Boolean that indicates whether to overwrite the hierarchy that was passed in if it already exists.

Type: Edm.Boolean

KeepExistingAttributes

A Boolean that indicates whether overwrite any existing attributes for the hierarchy, and all contained objects, we might be replacing with an overwrite. If the save is not overwriting, and this value is set to true, then no attributes will be created for the new hierarchy.

Added: 11.0.0

Type: Edm.Boolean

Table 257. SaveAs return types
Type Details
tm1.Hierarchy

The saved hierarchy.

Nullable: false

Subset.SaveAs

Saves a subset.

Added: 11.0.0

IsBound: true

Table 258. SaveAs parameters
Name Details

Subset

The subset to save.

Type: tm1.Subset

Nullable: false

Name

The name to save the subset as.

Type: Edm.String

Nullable: false

MakePrivate

A Boolean that indicates whether to save this subset as private.

Type: Edm.Boolean

MakeStatic

A Boolean that indicates whether to save this subset as static.

Type: Edm.Boolean

Table 259. SaveAs return types
Type Details
tm1.Subset

The saved subset.

Nullable: false

Cellset.SaveViewAs

Saves a view.

Added: 11.0.0

IsBound: true

Table 260. SaveViewAs parameters
Name Details

Cellset

The cellset whose underlying view is to save.

Type: tm1.Cellset

Nullable: false

Name

The name to save the view as.

Type: Edm.String

Nullable: false

Overwrite

A Boolean that indicates whether to overwrite the view that was passed in if it already exists.

Type: Edm.Boolean

MakePrivate

A Boolean that indicates whether to save this view as private.

Type: Edm.Boolean

Table 261. SaveViewAs return types
Type Details
tm1.View

The saved view.

Nullable: false

Element.SetComponent

Sets the child element of a particular element, allowing you to specify the relationship to the parent.

IsBound: true

Table 262. SetComponent parameters
Name Details

Parent

The parent element to set.

Type: tm1.Element

Nullable: false

Element

The element to set as a child of this parent.

Type: tm1.Element

Nullable: false

Before

Specifies the position where the new component should be created.

If NULL is specified, the new component is added to the beginning of the set. A POST operation appends to the end of a collection by default.

Type: tm1.Element

Weight

The weight of the element.

Type: Edm.Double

Hierarchy.SetElement

Inserts an element into a specified position by setting the parent.

IsBound: true

Table 263. SetElement parameters
Name Details

Hierarchy

The hierarchy where the element will be inserted.

Type: tm1.Hierarchy

Nullable: false

Element

The element to insert.

Type: tm1.Element

Nullable: false

Before

If specified, inserts the element before the element specified.

If NULL is specified, the new element is added to the beginning of the set. A POST operation appends to the end of a collection by default.

Type: tm1.Element

Subset.SetElement

Inserts an element into a specified subset at a specified location.

Added: 10.2.2.6

IsBound: true

Table 264. SetElement parameters
Name Details

Subset

The subset where the element will be inserted.

Type: tm1.Subset

Nullable: false

Element

The element to insert.

Type: tm1.Element

Nullable: false

Before

If specified, inserts the element before the element specified.

If NULL is specified, the new element is added to the beginning of the set. A POST operation appends to the end of a collection by default.

Type: tm1.Element

After

If specified, inserts the element after the element specified.

If NULL is specified, the new element is added to the end of the set. A POST operation appends to the end of a collection by default.

Type: tm1.Element

Chore.SetServerLocalStartTime

Sets the local start time for a server.

Added: 10.2.2.1

Deprecated: 11.8.3

IsBound: true

Table 265. SetServerLocalStartTime parameters
Name Details

Chore

The chore to set the server start time for.

Type: tm1.Chore

Nullable: false

StartDate

The start date to set for this chore.

Type: Edm.Date

Nullable: false

StartTime

The start time to set for this chore.

Type: Edm.TimeOfDay

Nullable: false

ProcessDebugContext.StepIn

Runs a single statement from the process.

If that statement is an ExecuteProcess function call, pause at the first statement inside that process.

IsBound: true

Table 266. StepIn parameters
Name Details

Context

The debug context.

Type: tm1.ProcessDebugContext

Nullable: false

Table 267. StepIn return types
Type Details
tm1.ProcessDebugContext  

ProcessDebugContext.StepOut

Resumes execution and runs until the current process has finished.

IsBound: true

Table 268. StepOut parameters
Name Details

Context

The debug context.

Type: tm1.ProcessDebugContext

Nullable: false

Table 269. StepOut return types
Type Details
tm1.ProcessDebugContext  

ProcessDebugContext.StepOver

Runs a single statement from the process.

If the statement is an ExecuteProcess function call, do not debug inside the function call.

IsBound: true

Table 270. StepOver parameters
Name Details

Context

The debug context.

Type: tm1.ProcessDebugContext

Nullable: false

Table 271. StepOver return types
Type Details
tm1.ProcessDebugContext  

Cube.TraceCellCalculation

Traces the calculation of a single cell. The result will contain, recursively, any components of the calculation.

Added: 11.1.0

IsBound: true

Table 272. TraceCellCalculation parameters
Name Details

Cube

Cube containing the cell that should be traced.

Type: tm1.Cube

Nullable: false

Tuple

Coordinates of the cell that should be traced.

Type: Collection(tm1.Element)

Table 273. TraceCellCalculation return types
Type Details
tm1.CalculationComponent

Represents the cell that was traced and the components of its calculation.

Nullable: false

Cube.TraceFeeders

Get a list of cells that are fed by the specified cell.

Added: 11.1.0

IsBound: true

Table 274. TraceFeeders parameters
Name Details

Cube

Cube containing the cell that should be traced.

Type: tm1.Cube

Nullable: false

Tuple

Coordinates of the cell that should be traced.

Type: Collection(tm1.Element)

Table 275. TraceFeeders return types
Type Details
tm1.FeederTrace

The feeder statements that use the source cell and the collection of resulting fed cells.

Nullable: false

UndoChangeSet

Reverts a change set.

Deleting the change set effectively removes all changes made to-date by the session.

Added: 10.2.2.6

IsBound: false

Table 276. UndoChangeSet parameters
Name Details

ChangeSetID

The ID of the change set to revert.

Type: Edm.String

Nullable: false

Cube.Unload

Unloads the cube from memory on the server.

Added: 11.6.0

IsBound: true

Table 277. Unload parameters
Name Details

Cube

The cube to be unloaded.

Type: tm1.Cube

Nullable: false

Sandbox.Unload

Unloads the sandbox from memory on the server.

This action is useful for freeing up resources when they are no longer needed.

IsBound: true

Table 278. Unload parameters
Name Details

Sandbox

The sandbox to be unloaded.

Type: tm1.Sandbox

Nullable: false

Cube.Unlock

Unlocks a cube, allowing modifications.

IsBound: true

Table 279. Unlock parameters
Name Details

Cube

The cube to unlock.

Type: tm1.Cube

Dimension.Unlock

Unlocks a dimension, allowing modifications.

IsBound: true

Table 280. Unlock parameters
Name Details

Dimension

The dimension to unlock.

Type: tm1.Dimension

Cellset.Update

Applies updates to a cell, or a range of cells, depending on the value of the parameters provided.

IsBound: true

Table 281. Update parameters
Name Details

Cellset

The cellset targeted by the update, specified in the resource path of the URL.

Type: tm1.Cellset

Nullable: false

BeginOrdinal

Specifies the cell to update if updating a single cell, or the beginning of the range if updating more than one cell.

Type: Edm.Int64

Nullable: false

EndOrdinal

The last cell position when updating a range of cells.

Type: Edm.Int64

ReferenceCube

The cube from which the data for the ReferenceCell is sourced.

Type: tm1.Cube

ReferenceCell

The cell, or slice, containing the source data required by the spreading command.

Type: Collection(tm1.Element)

Value

The actual value, typically a spreading command, with which the cell is updated.

Type: Edm.String

Nullable: false

Cube.Update

Applies updates to a cube, a slice of a cube, or cells of a cube, depending on the value of the parameters provided.

Added: 10.2.2.1

IsBound: true

Table 282. Update parameters
Name Details

Cube

The cube targeted by the update, specified in the resource path of the URL.

Type: tm1.Cube

Nullable: false

Slice

The slice of the cube targeted by the update.

Type: Collection(tm1.Element)

Cells

The cells of the cube targeted by the update.

Type: Collection(tm1.CellDescriptor)

ReferenceCube

The cube containing the source data required by the spreading command.

Type: tm1.Cube

ReferenceCell

The cell containing the source data required by the spreading command.

Type: Collection(tm1.Element)

Value

The actual value, typically a spreading command, with which the cell is updated.

Type: Edm.String

Nullable: false

Update

Applies updates to a cube, a slice of a cube, or cells of a cube, depending on the value of the parameters provided.

Added: 10.2.2.4

IsBound: false

Table 283. Update parameters
Name Details

Cube

The cube targeted by the update, specified in the resource path of the URL.

Type: tm1.Cube

Nullable: false

Slice

The slice of the cube targeted by the update.

Type: Collection(tm1.Element)

Cells

The cells of the cube targeted by the update.

Type: Collection(tm1.CellDescriptor)

ReferenceCube

The cube containing the source data required by the spreading command.

Type: tm1.Cube

ReferenceCell

The cell containing the source data required by the spreading command.

Type: Collection(tm1.Element)

Value

The actual value, typically a spreading command, with which the cell is updated.

Type: Edm.String

Nullable: false

Cellset.UpdateCells

Applies updates to cells in a cellset.

Added: 11.0.0

IsBound: true

Table 284. UpdateCells parameters
Name Details

Cellset

The cellset targeted by the update, specified in the resource path of the URL.

Type: tm1.Cellset

Nullable: false

Updates

Specifies the cells to update and the values with which to update the cells.

Type: Collection(tm1.CellsetUpdate)

Order

The update order to use. Specify 0 for no ordering.

The spreading commands are executed on each cell in the order that they are provided in Updates. Specify 1 to order the cells by level. Leaf cell values are set first and these leaf cells are held. Then, their parents are set and held, and so on, until the highest level consolidations are reached.

Type: tm1.UpdateOrder

Cube.UpdateCells

Applies updates to cells of a cube.

Added: 11.0.0

IsBound: true

Table 285. UpdateCells parameters
Name Details

Cube

The cube targeted by the update, specified in the resource path of the URL.

Type: tm1.Cube

Nullable: false

Updates

The cells of the cube targeted by the update and the values with which to update those cells.

Type: Collection(tm1.CubeUpdate)

Order

The update order to use. Specify 0 for no ordering.

The spreading commands are executed on each cell in the order that they are provided in Updates. Specify 1 to order the cells by level. Leaf cell values are set first and these leaf cells are held. Then, their parents are set and held, and so on, until the highest level consolidations are reached.

Type: tm1.UpdateOrder

Release notes

Release notes describe the entities, functions, and actions that were added for each release of IBM TM1 Server. All changes and additions apply to the current release of Planning Analytics.

What's new in 11.5.0

The following entity types were changed in 11.5.0:

The following complex types were changed in 11.5.0:

The following enumerated types were changed in 11.5.0:

The following actions were changed in 11.5.0:

The following properties were changed in 11.5.0:

  • Deprecated property ID in Entry
  • Added property Active in Session

What's new in 11.3.0

The following entity types were changed in 11.3.0:

The following enumerated types were changed in 11.3.0:

The following functions were changed in 11.3.0:

The following actions were changed in 11.3.0:

The following enumerated values were changed in 11.3.0:

  • Added member OperationsAdmin in UserType

What's new in 11.1.1

The following actions were changed in 11.1.1:

What's new in 11.1.0

The following complex types were changed in 11.1.0:

The following enumerated types were changed in 11.1.0:

The following actions were changed in 11.1.0:

The following properties were changed in 11.1.0:

What's new in 11.0.2

What's new in 11.0.0

The following entity types were changed in 11.0.0:

The following complex types were changed in 11.0.0:

The following enumerated types were changed in 11.0.0:

The following actions were changed in 11.0.0:

The following properties were changed in 11.0.0:

  • Added property AllLeavesHierarchyName in Dimension
  • Added property Visible in Hierarchy
  • Added property IncludeInSandboxDimension in Sandbox
  • Added property Enabled in User

The following parameters were changed in 11.0.0:

What's new in 10.2.2.7

The following navigation properties were changed in 10.2.2.7:

What's new in 10.2.2.6

The following entity types were changed in 10.2.2.6:

The following complex types were changed in 10.2.2.6:

The following actions were changed in 10.2.2.6:

The following properties were changed in 10.2.2.6:

  • Added property HasDrillthrough in CellsetCell
  • Added property DrillthroughRules in Cube

The following navigation properties were changed in 10.2.2.6:

  • Added navigation property DrillthroughScripts in CellsetCell

What's new in 10.2.2.5

The following entity types were changed in 10.2.2.5:

The following actions were changed in 10.2.2.5:

The following properties were changed in 10.2.2.5:

  • Added property ID in Thread
  • Added property FriendlyName in User

The following navigation properties were changed in 10.2.2.5:

  • Added navigation property DefaultHierarchy in Dimension
  • Added navigation property Level in Member
  • Added navigation property Sessions in User

What's new in 10.2.2.4

The following enumerated types were changed in 10.2.2.4:

The following actions were changed in 10.2.2.4:

The following properties were changed in 10.2.2.4:

  • Added property Type in User

What's new in 10.2.2.3

The following functions were changed in 10.2.2.3:

What's new in 10.2.2.2

The following entity types were changed in 10.2.2.2:

The following actions were changed in 10.2.2.2:

The following navigation properties were changed in 10.2.2.2:

  • Added navigation property ErrorLogs in Process

What's new in 10.2.2.1

The following entity types were changed in 10.2.2.1:

The following complex types were changed in 10.2.2.1:

The following enumerated types were changed in 10.2.2.1:

The following functions were changed in 10.2.2.1:

The following actions were changed in 10.2.2.1:

The following properties were changed in 10.2.2.1:

The following navigation properties were changed in 10.2.2.1:

  • Added navigation property ElementAttributes in Hierarchy

What's new in 10.2.2.0