SecurityOverlayGlobalLockNode function for IBM Planning Analytics (TM1)


SecurityOverlayGlobalLockNode function for IBM Planning Analytics (TM1)

SecurityOverlayGlobalLockNode locks or unlocks a specific intersection or cell in the cube based on the combination of dimension elements assigned in the Security Overlay cube of a specific cube.

In the video, SecurityOverlayGlobalLockNode will be used to lock the ‘Actual 2020’ and ‘Budget 2002’ cells for data entry in the ‘Sales Quota’ cube.

Where can the SecurityOverlayGlobalLockNode function be used?

TurboIntegrator

Which TM1 Server version is the SecurityOverlayGlobalLockNode function available for?

Version 11 and 12

What is the syntax for SecurityOverlayGlobalLockNode?

SecurityOverlayGlobalLockNode (LockLock, CubeName, Address, [AddressDelimiter])​

  • CubeName = cube for security overlay setting​
  • LockFlag = ‘1’ to lock and ‘0’ to unlock​
  • Address = the string sequence of overlay element names with delimiter creating the intersection in the cube.​
  • AddressDelimiter = delimiter for the address. The default is ‘|’

Relevant Functions

Leave a Reply

Your email address will not be published. Required fields are marked *