DimensionDestroy function for IBM Planning Analytics (TM1)  DimensionDestroy deletes a dimension. In the video, the DimensionDestroy will be used to delete the dimension, A New Dimension. Where can the DimensionDestroy function be used? TurboIntegrator Which TM1 Server version is the DimensionDestroy function available for? Version 11 and 12 What is the syntax for DimensionDestroy? DimensionDestroy(DimName)​ Relevant Functions

CubeDimensionCountGet function for IBM Planning Analytics (TM1) CubeDimensionCountGet returns the number of dimensions in a cube. In this video, CubeDimensionCountGet is used to count the number of dimensions in the Product Scorecard cube. Where can the CubeDimensionCountGet function be used? TurboIntegrator Which TM1 Server version is the CubeDimensionCountGet function available for? Version 11 and 12 What is…

DimensionTopElementInsert function for IBM Planning Analytics (TM1)  DimensionTopElementInsert creates a root element in a dimension. This can only be created if the dimension does not have a standalone root element. This action occurs after a commitment to the process (e.g., at the end of executing the metadata tab). To action this function immediately, use DimensionTopElementInsertDirect. In the video, the DimensionTopElementInsert will…

CubeDRAcquire function for IBM Planning Analytics (TM1) CubeDRAcquire acquires data reservation for a user in a cube according to an element list. This function applies to dimensions with one or more hierarchies, while CubeDataReservationAcquire is used for dimensions with a single hierarchy. Learn how to use the CubeDRAcquire to acquire data reservation for the user, Test, in the Product Type by…

CubeDRGet function for IBM Planning Analytics (TM1) CubeDRGet finds existing reservations on a specific cube for all or one user. This function applies to dimensions with one or more hierarchies, while CubeDataReservationGet is used for dimensions with a single hierarchy. Learn how to use the CubeDRGet to return the data reconversion set for the user, TEST, in the Product…

CubeDRGetConflicts function for IBM Planning Analytics (TM1) CubeDRGetConflicts gets the current data reservation conflicts of the cube. This function applies to dimensions with one or more hierarchies, while CubeDataReservationGetConflicts is used for dimensions with a single hierarchy. Learn how to use the CubeDRGetConflicts to check if there are data reservation conflicts for user TEST in the Product Type by Region cube. The result will…

CubeDRRelease function for IBM Planning Analytics (TM1) CubeDRRelease releases the data reservation specified in the element list. This function applies to dimensions with one or more hierarchies, while CubeDataReservationRelease is used for dimensions with a single hierarchy. Learn how to use the CubeDRRelease to release data reserved by user TEST2, so that user TEST can update the data in the Product Type by Region cube.…

HierarchySubsetExists function for IBM Planning Analytics (TM1) HierarchySubsetExists checks if a public subset exists for a hierarchy. 1 is returned if the subset exists or 0 if the subset does not exist. In this video, HierarchySubsetExists will be used to check if the Department subset is associated with the Employee hierarchy and Employee dimension. Where can the HierarchySubsetExists function be used?…

HierarchySubsetGetSize function for IBM Planning Analytics (TM1) HierarchySubsetGetSize returns the number of elements in a subset associated with a hierarchy. In this video, HierarchySubsetGetSize will be used to retrieve the number of elements the Departments subset that’s associated with the Employee hierarchy and Employee dimension. Where can the HierarchySubsetGetSize function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetGetSize function…

HierarchySubsetMDXSet function for IBM Planning Analytics (TM1) HierarchySubsetMDXSet inserts an MDX expression to a public subset. In this video, HierarchySubsetMDXSet will be used to insert an MDX express to the Departments subsets, that’s associated with the Employee hierarchy and Employee dimension. Where can the HierarchySubsetMDXSet function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetMDXSet function available for? Version 11…