CubeAttrSL function for IBM Planning Analytics (TM1) CubeAttrSL retrieves data from a string attribute for a Cube, based on the language locale. In the video, CubeAttrSL will be used to retrieve data from the description attribute of the Employee cube. Where can the CubeAttrSL function be used? TurboIntegrator Which TM1 Server version is the CubeAttrSL function available for?…

CubeTimeLastUpdated function for IBM Planning Analytics (TM1) CubeTimeLastUpdated returns a serial value which refers to the last time the cube was updated.  In this video, CubeTimeLastUpdated is used to retrieve when the cube, zTest, was last updated Where can the CubeTimeLastUpdated function be used? TurboIntegrator Which TM1 Server version is the CubeTimeLastUpdated function available for? Version…

DimensionElementComponentAdd function for IBM Planning Analytics (TM1)  DimensionElementComponentAdd adds an element to a consolidated element in a rollup according to a specific weight in a dimension. 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 DimensionElementComponentAddDirect. In the video, the DimensionElementComponentAdd will be used to…

CubeUnload function for IBM Planning Analytics (TM1) CubeUnload unloads a cube and its view from the memory. In this video, CubeUnload is used to unload the Product Scorecard cube. Where can the CubeUnload function be used? TurboIntegrator Which TM1 Server version is the CubeUnload function available for? Version 11 and 12 What is the syntax for CubeUnload? CubeUnload(CubeName)…

DimensionElementComponentAddDirect function for IBM Planning Analytics (TM1)  DimensionElementComponentAddDirect adds an element to a consolidated element in a rollup according to a specific weight in a dimension. 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), use DimensionElementComponentAdd. In the video, the DimensionElementComponentAddDirect will be…

DataMinorErrorCount function for IBM Planning Analytics (TM1) DataMinorErrorCount counts minor errors that occur in the Data tab. In this video, DataMinorErrorCount is used to count minor errors when exporting data from the Finance cube. Where can the DataMinorErrorCount function be used? TurboIntegrator Which TM1 Server version is the DataMinorErrorCount function available for? Version 11 and 12 What is…

DimensionElementComponentDelete function for IBM Planning Analytics (TM1)  DimensionElementComponentDelete deletes an element from a consolidated element in a rollup. 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 DimensionElementComponentDeleteDirect. In the video, the DimensionElementComponentDelete will be used to delete the element Denmark from the consolidated element Scandinavia in…

DimensionDeleteElements function for IBM Planning Analytics (TM1)  DimensionDeleteElements delete elements in a dimension based on a subset. In the video, the DimensionDeleteElements will be used to delete elements in the dimension, ‘A New Dimension’, from the UK subset. Where can the DimensionDeleteElements function be used? TurboIntegrator Which TM1 Server version is the DimensionDeleteElements function available for? Version 11…

DimensionElementPrincipalName function for IBM Planning Analytics (TM1)  DimensionElementPrincipalName returns the principal name of an element or element alias. In the video, the DimensionElementPrincipalName will be used to get the principal name of the Australian Dollar in the Currency dimension. Where can the DimensionElementPrincipalName function be used? TurboIntegrator Which TM1 Server version is the DimensionElementPrincipalName function available for? Version 11…

DimensionExists function for IBM Planning Analytics (TM1)  DimensionExists checks whether a dimension exists. If the dimension exists, the result is 1; if it does not, the result is 0. In the video, the DimensionExists will be used to check if the dimension, A New Dimension, exist. Where can the DimensionExists function be used? TurboIntegrator Which TM1 Server version…