SecurityOverlayGlobalLockCell function for IBM Planning Analytics (TM1)


SecurityOverlayGlobalLockCell function for IBM Planning Analytics (TM1)

SecurityOverlayGlobalLockCell 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, SecurityOverlayGlobalLockCell will be used to lock ‘Budget 2002’ cells for data entry in the ‘Sales Quota’ cube.

Where can the SecurityOverlayGlobalLockCell function be used?

TurboIntegrator

Which TM1 Server version is the SecurityOverlayGlobalLockCell function available for?

Version 11 and 12

What is the syntax for SecurityOverlayGlobalLockCell?

SecurityOverlayGlobalLockCell(LockFlag, CubeName, element1,…, elementN)

  • ​CubeName = cube for security overlay setting​
  • LockFlag = ‘1’ to lock and ‘0’ to unlock​
  • ElementN = dimension elements creating the intersection in the cube

Relevant Functions

Leave a Reply

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