-
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…
-
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…
-
RemoveCAMIDAssociation function for IBM Planning Analytics (TM1)
RemoveCAMIDAssociation function for IBM Planning Analytics (TM1) RemoveCAMIDAssociation removes all associations of a specified CAMID with TM1 user groups. In the video, the RemoveCAMIDAssociation will be used to remove “CAMID Group A” associations with TM1 user groups by deleting the CAMID from }ClientCAMAssociatedGroups control cube and also remove “CAMID Group B” associations but leaving the CAMID in…
-
RemoveCAMIDAssociationFromGroup function for IBM Planning Analytics (TM1)
RemoveCAMIDAssociationFromGroup function for IBM Planning Analytics (TM1) RemoveCAMIDAssociationFromGroup removes an association between a TM1 user group and a CAMID. In the video, the RemoveCAMIDAssociationFromGroup will be used to remove “CAMID Group C” association with ‘Group C” TM1 user group in }ClientCAMAssociatedGroups control cube. Where can the RemoveCAMIDAssociationFromGroup function be used? TurboIntegrator Which TM1 Server version is…
-
RuleLoadFromFile function for IBM Planning Analytics (TM1)
RuleLoadFromFile function for IBM Planning Analytics (TM1) RuleLoadFromFile loads a text file that contains rules to a Cube In this video, RuleLoadFromFile is used to load a rule from a text file to the Product Scorecard cube. Where can the RuleLoadFromFile function be used? TurboIntegrator Which TM1 Server version is the RuleLoadFromFile function available for? Version 11 and…
-
RunProcess function for IBM Planning Analytics (TM1)
RunProcess function for IBM Planning Analytics (TM1) RunProcess can run multiple processes in parallel. This function can speed up data loads and other processes by dividing work into multiple parts. Each process thread is managed by TM1 Server. In this video, RunProcess is used to execute the same process, RunProcess_Test, multiple times in parallel with a different year. Where can…
-
ServerActiveSandboxSet function for IBM Planning Analytics (TM1)
ServerActiveSandboxSet function for IBM Planning Analytics (TM1) ServerActiveSandboxSet sets an existing sandbox as active for the user. In this video, ServerActiveSandboxSet will be used to set an active sandbox for the user. Where can the ServerActiveSandboxSet function be used? TurboIntegrator Which TM1 Server version is the ServerActiveSandboxSet function available for? Version 11 and 12 What is the syntax…
-
SubsetGetSize function for IBM Planning Analytics (TM1)
SubsetGetSize function for IBM Planning Analytics (TM1) SubsetGetSize returns the number of elements in a subset. In this video, SubsetGetSize will be used to retrieve the size of the ‘All Elements’ subset in the Product Scorecard dimension. Where can the SubsetGetSize function be used? TurboIntegrator Which TM1 Server version is the SubsetGetSize function available for? Version 11…
-
StringToNumber function for IBM Planning Analytics (TM1)
StringToNumber function for IBM Planning Analytics (TM1) StringToNumber converts a string into a numeric value. In this video, StringToNumber will be used to convert a string variable into a numeric value when exporting to a text file. Where can the StringToNumber function be used? TurboIntegrator Which TM1 Server version is the StringToNumber function available for? Version…
-
SubsetGetElementName function for IBM Planning Analytics (TM1)
SubsetGetElementName function for IBM Planning Analytics (TM1) SubsetGetElementName retrieves an element’s name from a subset based on an index. In this video, SubsetGetElementName will be used to retrieve the 2nd positioned element from the ‘All Elements’ subset in the Product Scorecard dimension. Where can the SubsetGetElementName function be used? TurboIntegrator Which TM1 Server version is the SubsetGetElementName function available…