TM1 Forum

Code: Select all

"@odata.context": "$metadata#Cubes",
    "value": [
        {
            "@odata.etag": "W/\"b19afc8c86a7cf1bec61a666767aade200b60d78\"",
            "Name": "Allocation Calculation",
            "Rules": "...",
            "DrillthroughRules": null,
            "LastSchemaUpdate": "2024-10-03T09:18:43.234Z",
            "LastDataUpdate": "2024-10-16T12:58:19.790Z",
            "ViewStorageMaxMemory": 999999999,
            "ViewStorageMinTime": 1,
            "CalculationThresholdForStorage": null,
            "CellSecurityDefaultValue": null,
            "CellSecurityMostRestrictive": false,
            "AllowPersistentHolds": false,
            [b]"Locked": false,[/b]
            "Attributes": {
                "Caption": "Allocation Calculation",
                "Caption_Default": "Allocation Calculation"
            }
        },

Code: Select all

{
    "@odata.context": "$metadata#Cubes(Name,Locked)/$entity",
    "@odata.etag": "W/\"b19afc8c86a7cf1bec61a666767aade200b60d78\"",
    "Name": "Allocation Calculation",
    "Locked": false
}

Code: Select all

# Locks will block any user and any TI process.
# One way to circumvent it, is the function CubeLockOverride (see: https://cubewise.com/blog/things-might-not-know-tm1-security-part-2)


# NOTE: I cannot locate where to find the owner of any given lock ! V11 Properties cubes where it was stored, are deprecated.


# Locking/unlocking a cube ( this locks/unlocks the entire cube, no data changes are possible )

# Our options include:
# - in Turbo Integrator:
#      * ExecuteHttpRequest() implementation of the TM1 REST API solutions below
#      * CubeSetLockStatus( <vCube>, <1=lock|0=unlock> ); (this appears to be an undocumented function, it is not recognized in PAW but the process saves and runs) (Security access checkbox is not needed)
# - manually, in PAW:
#      * right-click a cube > Cube operations > Lock cube (if it is currently unlocked) / Unlock cube (if it is currently locked) (a lock icon will appear when locked)
# - in the TM1 REST API:
#      * Is it locked/unlocked ? GET /api/v1/Cubes('<vCube>')/Locked (200 OK)
#      * Or: GET /api/v1/Cubes('<vCube>')?$select=Locked (200 OK)
#      * To lock/unlock ? POST /api/v1/Cubes('<vCube>')/tm1.Lock|tm1.Unlock (204 No Content)


# Locking/unlocking an element in a hierarchy of a dimension ( this locks/unlocks all cubes that use this dimension, on the specified element )
# No data changes are possible on this element
# Also, attributes for a locked element cannot be set or changed

# Our options include:
# - in Turbo Integrator:
#      * ExecuteHttpRequest() implementation of the TM1 REST API solutions below
#      * DimensionElementSetLockStatus( <vDim>, <vElement>, <1=lock|0=unlock> ); (this appears to be an undocumented function, it is not recognized in PAW but the process saves and runs) (Security access checkbox is not needed)
# - manually, in PAW:
#      * right-click an element in the Dimension Editor > Lock (if it is currently unlocked) / Unlock (if it is currently locked) (a lock icon will appear when locked)
# - in the TM1 REST API:
#      * Is it locked/unlocked ? GET /api/v1/Dimensions('<vDim>')/Hierarchies('<vHier>')/Elements('<vElement>')/Locked (200 OK)
#      * Or: GET /api/v1/Dimensions('<vDim>')/Hierarchies('<vHier>')/Elements('<vElement>')?$select=Locked (200 OK)
#      * To lock/unlock ? POST /api/v1/Dimensions('<vDim>')/Hierarchies('<vHier>')/Elements('<vElement>')/tm1.Lock|tm1.Unlock (204 No Content)



# Locking/unlocking a dimension ( this locks/unlocks the entire dimension, no metadata changes are possible )
# This does not block data changes in cube cells that reference any of the elements within the dimension, rather, changes to the contents and properties of the dimension

# Our options include:
# - in Turbo Integrator:
#      * ExecuteHttpRequest() implementation of the TM1 REST API solutions below
#      * DimensionSetLockStatus( <vDim>, <1=lock|0=unlock> ); (this appears to be an undocumented function, it is not recognized in PAW but the process saves and runs) (Security access checkbox is not needed)
# - manually, in PAW:
#      * right-click a dimension > Lock dimension (if it is currently unlocked) / Unlock dimension (if it is currently locked) (a lock icon will appear when locked)
# - in the TM1 REST API:
#      * Is it locked/unlocked ? GET /api/v1/Dimensions('<vDim>')/Locked (200 OK)
#      * Or: GET /api/v1/Dimensions('<vDim>')?$select=Locked (200 OK)
#      * To lock/unlock ? POST /api/v1/Dimensions('<vDim>')/tm1.Lock|tm1.Unlock (204 No Content)