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

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

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…

HierarchySubsetAliasSet function for IBM Planning Analytics (TM1) HierarchySubsetAliasSet sets an alias for a subset of a hierarchy. Returns 1 if successful or 0 if not. In this video, HierarchySubsetAliasSet will be used to set the alias, Full Name, to the Finance subset in the Employee Hierarchy from the Employee dimension. Where can the HierarchySubsetAliasSet function be used? TurboIntegrator Which TM1 Server version…

HierarchySubsetAttrInsert function for IBM Planning Analytics (TM1) HierarchySubsetAttrInsert adds a new attribute for subsets. In this video, HierarchySubsetAttrInsert will be used to add an Office attribute in the Western Europe hierarchy from the Sales Region dimension. Where can the HierarchySubsetAttrInsert function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetAttrInsert function available for? Version…