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…

HierarchyTimeLastUpdated function for IBM Planning Analytics (TM1) HierarchyTimeLastUpdated returns a number that refers to the last time the hierarchy was updated. This is a consecutive number that counts the days since 01/01/1900.  In the video, HierarchyTimeLastUpdated will be used to retrieve the date number when the Employee Hierarchies’ hierarchy and ‘Employee Hierarchies’ dimension was last updated. Where can the HierarchyTimeLastUpdated function…

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…

DimensionTopElementInsertDirect function for IBM Planning Analytics (TM1)  DimensionTopElementInsertDirect creates a root element in a dimension by directly editing a dimension. This can only be created if the dimension does not have a standalone root element. This function is actioned immediately.  To action this function until the process makes a commitment (e.g. at the end of executing the metadata tab),…

ItemReject function for IBM Planning Analytics (TM1) ItemReject skips the current source data transaction like ItemSkip. However, ItemReject allows us to write a custom message in the log file. In this video, ItemReject is used to output an error message for a specific measure. Where can the ItemReject function be used? TurboIntegrator Which TM1 Server version is the ItemReject…

HierarchyElementComponentDelete function for IBM Planning Analytics (TM1) HierarchyElementComponentDelete deletes a component (child) from a consolidated element in a hierarchy. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use HierarchyElementComponentDeleteDirect. In the video, HierarchyElementComponentDelete will be used to delete Netherlands as a child of Benelux in the Western Europe hierarchy…

HierarchyHasOrphanedLeaves function for IBM Planning Analytics (TM1) HierarchyHasOrphanedLeaves returns 1 if a hierarchy in a dimension has an orphaned element or returns 0 if there is no orphaned element in that hierarchy. In the video, HierarchyHasOrphanedLeaves will be used to see if there are any orphaned elements in the Employee Hierarchies dimension. Where can the HierarchyHasOrphanedLeaves function be used? TurboIntegrator…