Category: Education

  • HierarchySubsetDestroy function for IBM Planning Analytics (TM1)

    HierarchySubsetDestroy function for IBM Planning Analytics (TM1)

    HierarchySubsetDestroy function for IBM Planning Analytics (TM1) HierarchySubsetDestroy destroys a subset from a hierarchy. In this video, HierarchySubsetDestroy will be used to remove the Departments subset associated with the Employee hierarchy and Employee dimension.  Where can the HierarchySubsetDestroy function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetDestroy function available for? Version 11 and 12 What is the syntax for…

  • ServerActiveSandboxSet function for IBM Planning Analytics (TM1)

    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…

  • SaveDataAll function for IBM Planning Analytics (TM1)

    SaveDataAll function for IBM Planning Analytics (TM1)

    SaveDataAll function for IBM Planning Analytics (TM1)  SaveDataAll saves all changes made on the TM1 server. This moves the changes from memory to disk and restarts the log file. In the video, SaveDataAll will be used to save all changes on the TM1 Server and show how it impacts log files. Where can the BatchUpdateFinishWait function…

  • SecurityOverlayCreateGlobalDefault function for IBM Planning Analytics (TM1)

    SecurityOverlayCreateGlobalDefault function for IBM Planning Analytics (TM1)

    SecurityOverlayCreateGlobalDefault function for IBM Planning Analytics (TM1) SecurityOverlayCreateGlobalDefault creates a Security Overlay cube for a specific cube with a dimension map based on the dimension order in the cube. A security Overlay cube locks and unlocks specific intersections at the cell level according to the combination of dimension elements assigned. In the video, SecurityOverlayCreateGlobalDefault will be used…

  • SecurityOverlayDestroyGlobalDefault function for IBM Planning Analytics (TM1)

    SecurityOverlayDestroyGlobalDefault function for IBM Planning Analytics (TM1)

    SecurityOverlayDestroyGlobalDefault function for IBM Planning Analytics (TM1) SecurityOverlayDestroyGlobalDefault deletes the Security Overlay cube for a specific cube with a dimension map based on the dimension order in the cube.  In the video, SecurityOverlayDestroyGlobalDefault will be used to delete the Security Overlay for the ‘General Ledger’ cube (}SecurityOvelayGlobal_General Ledger) from the TM1 database. Where can the SecurityOverlayDestroyGlobalDefault function be…

  • SecurityOverlayGlobalLockCell function for IBM Planning Analytics (TM1)

    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 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 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 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 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…