-
ASIN function for IBM Planning Analytics (TM1)
ASIN function for IBM Planning Analytics (TM1) ASIN returns the angle, in radians, whose sine is x. In the video, ASIN will be used to calculate the angle of a given sine value. Where can the ASIN function be used? Rules and TurboIntegrator Which TM1 Server version is the ASIN function available for? Version 11 and…
-
ServerSandboxClone function for IBM Planning Analytics (TM1)
ServerSandboxClone function for IBM Planning Analytics (TM1) ServerSandboxClone creates a sandbox that is a copy of an existing one. In this video, ServerSandboxClone will be used to create a new sandbox, Goal, from the existing sandbox, Training. Where can the ServerSandboxClone function be used? TurboIntegrator Which TM1 Server version is the ServerSandboxClone function available for? Version 11 and 12…
-
ViewMDXGet function for IBM Planning Analytics (TM1)
ViewMDXGet function for IBM Planning Analytics (TM1) ViewMDXGet retrieves the MDX expression for a cube view. In the video, ViewMDXGet will be used to retrieve the MDX used for the view, My new MDX View, from the Finance cube. Where can the ViewMDXGet function be used? TurboIntegrator Which TM1 Server version is the ViewMDXGet function available for?…
-
CHAR function for IBM Planning Analytics (TM1)
CHAR function for IBM Planning Analytics (TM1) CHAR converts the ASCII numeric code into the character. In the video, CHAR will convert the ASCII numeric code into a character and apply it in the rule to populate the Comment measure in the Product Scorecard cube. Where can the CHAR function be used? Rules and TurboIntegrator Which…
-
CODE function for IBM Planning Analytics (TM1)
CODE function for IBM Planning Analytics (TM1) CODE converts the character to the ASCII numeric code. In the video, CODE will be used to convert a specific character to an ASCII numeric code and apply it in the rule to populate the Product Scorecard cube. Where can the CODE function be used? Rules and TurboIntegrator…
-
ConsolidatedCount function for IBM Planning Analytics (TM1)
ConsolidatedCount function for IBM Planning Analytics (TM1) ConsolidatedCount returns the number of values in a consolidation. In this video, ConsolidatedCount is used to count the number of values in the consolidation and apply it in the rule to populate the Avg_Value element in the Product Scorecard cube. Where can the ConsolidatedCount function be used? Rules and TurboIntegrator Which…
-
ConsolidatedMax function for IBM Planning Analytics (TM1)
ConsolidatedMax function for IBM Planning Analytics (TM1) ConsolidatedMax returns the maximum value in a consolidation. In this video, ConsolidatedMax is used to calculate maximum value in a consolidation and apply it in the rule to populate the Max_Value measure in the Product Scorecard cube. Where can the ConsolidatedMax function be used? Rules and TurboIntegrator Which TM1 Server version…
-
ConsolidatedMin function for IBM Planning Analytics (TM1)
ConsolidatedMin function for IBM Planning Analytics (TM1) ConsolidatedMin returns the minimum value in a consolidation. In this video, ConsolidatedMin is used to calculate minimum value in a consolidation and apply it in the rule to populate the Min_Value measure in the Product Scorecard cube. Where can the ConsolidatedMin function be used? Rules and TurboIntegrator Which TM1 Server version…
-
SubsetElementGetIndex function for IBM Planning Analytics (TM1)
SubsetElementGetIndex function for IBM Planning Analytics (TM1) SubsetElementGetIndex retrieves an element’s index in a subset. If the element doesn’t exist in the subset, then the function returns 0. If the index is not between 1 and the size of the subset then the function return error and process will be aborted. In this video, SubsetElementGetIndex will be used to retrieve…
-
SubsetElementInsert function for IBM Planning Analytics (TM1)
SubsetElementInsert function for IBM Planning Analytics (TM1) SubsetElementInsert adds an element in an existing subset. In this video, SubsetElementInsert will be used to insert the element, Sales Amount, to the ‘All Elements’ subset in the Product Scorecard dimension into position 1 and 3 Where can the SubsetElementInsert function be used? TurboIntegrator Which TM1 Server version…