-
TM1User function for IBM Planning Analytics (TM1)
TM1User function for IBM Planning Analytics (TM1) TM1User returns the client who ran the process. In this video, TM1User is used to retrieve the client who ran the process. Where can the TM1User function be used? Excel and TurboIntegrator Which TM1 Server version is the TM1User function available for? Version 11 and 12 What is the…
-
ServerActiveSandboxGet function for IBM Planning Analytics (TM1)
ServerActiveSandboxGet function for IBM Planning Analytics (TM1) ServerActiveSandboxGet returns the name of the active sandbox for the user. If no sandbox is set as active, the function returns a blank string. In this video, ServerActiveSandboxGet will be used to get the user’s active sandbox name. Where can the ServerActiveSandboxGet function be used? TurboIntegrator Which TM1 Server…
-
ViewColumnDimensionSet function for IBM Planning Analytics (TM1)
ViewColumnDimensionSet function for IBM Planning Analytics (TM1) ViewColumnDimensionSet sets the dimension in a column position for a cube view. In the video, ViewColumnDimensionSet will be used to set the dimension Year in the column position for the default view as the top-most stacked position. Where can the ViewColumnDimensionSet function be used? TurboIntegrator Which TM1 Server version is the ViewColumnDimensionSet function…
-
CellValueN function for IBM Planning Analytics (TM1)
CellValueN function for IBM Planning Analytics (TM1) CellValueN returns the numeric value of the specified element in a specified cube. In this video, CellValueN is used to retrieve data from Value to TestN in the Product Scorecard cube. Where can the CellValueN function be used? Rules Which TM1 Server version is the CellValueN function available for? Version 11 and 12 What…
-
DimensionAttrN function for IBM Planning Analytics (TM1)
DimensionAttrN function for IBM Planning Analytics (TM1) DimensionAttrN returns a numeric attribute for a specified dimension. In this video, DimensionAttrN will be used to retrieve the numeric attribute value of the dimension and apply it in the rule to populate the Product Scorecard cube. Where can the DimensionAttrN function be used? Rules and TurboIntegrator Which TM1…
-
CellValueS function for IBM Planning Analytics (TM1)
CellValueS function for IBM Planning Analytics (TM1) CellValueS returns the string value of the specified element in a specified cube. In this video, CellValueS is used to retrieve the string value from cube and apply it in the rule to populate the Comment measure in the Product Scorecard cube. Where can the CellValueS function be used?…
-
DimIx function for IBM Planning Analytics (TM1) – Rules
DimIx function for IBM Planning Analytics (TM1) – Rules DimIx returns an element’s index number in a dimension. In the video, DimIx will be used on the Account dimension to return the index for an element. Where can the DimIx function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the DimIx function…
-
Day function for IBM Planning Analytics (TM1)
Day function for IBM Planning Analytics (TM1) Day returns the day from a date in a numeric format. In this video, the Day function will be used to retrieve the day from a date. Where can the Day function be used? Rules and TurboIntegrator Which TM1 Server version is the Day function available for? Version…
-
DayNo function for IBM Planning Analytics (TM1)
DayNo function for IBM Planning Analytics (TM1) DayNo returns the serial number from a date in a numeric format. In this video, the DayNo function will be used to retrieve the serial number from a date. Where can the DayNo function be used? Rules and TurboIntegrator Which TM1 Server version is the DayNo function available for?…
-
AttrN function for IBM Planning Analytics (TM1)
AttrN function for IBM Planning Analytics (TM1) AttrN returns the numeric attribute for a specified element of a dimension. This function can be used to enhance data analysis, improve report quality and create more sophisticated calculations. In the video, AttrN will be used to retrieve an attribute’s value from the Organisation dimension. Where can the AttrN function be…