-
ViewExtractSkipZeroesSet function for IBM Planning Analytics (TM1)
ViewExtractSkipZeroesSet function for IBM Planning Analytics (TM1) ViewExtractSkipZeroesSet skips or includes zeros when exporting a view using ASCIIOutput. Use in the Prolog tab. In the video, learn how to use ViewExtractSkipZeroesSet to export the view, By Year, from the Product Scorecard cube to exclude zeros then show the result when zeros are included. Where can the ViewExtractSkipZeroesSet function be used? TurboIntegrator…
-
ViewMDXSet function for IBM Planning Analytics (TM1)
ViewMDXSet function for IBM Planning Analytics (TM1) ViewMDXSet sets the MDX expression for a cube view. In the video, ViewMDXSet will be used to modify the view, My new MDX View, from the Finance cube using an MDX. Where can the ViewMDXSet function be used? TurboIntegrator Which TM1 Server version is the ViewMDXSet function available for? Version 11…
-
DimensionElementInsertDirect function for IBM Planning Analytics (TM1)
DimensionElementInsertDirect function for IBM Planning Analytics (TM1) DimensionElementInsertDirect adds an element in a dimension by directly editing 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 DimensionElementInsert. In the video, the DimensionElementInsertDirect will be used to create a dimension called ‘A New Dimension’.…
-
DimNm function for IBM Planning Analytics (TM1) – Excel
DimNm function for IBM Planning Analytics (TM1) – Excel DimNm returns an element’s member ID based on an index in a dimension. In the video, DimNm will be used on the Account dimension to return the element’s name, based on an index. Where can the DimNm function be used? Excel, Rules and TurboIntegrator Which TM1…
-
DimSiz function for IBM Planning Analytics (TM1)
DimSiz function for IBM Planning Analytics (TM1) DimSiz returns the first element in a dimension. In the video, DimSiz will be used to return the number of elements in the Account dimension Where can the DimSiz function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the DimSiz function available for? Version 11…
-
DNext function for IBM Planning Analytics (TM1)
DNext function for IBM Planning Analytics (TM1) DNext returns the first element in a dimension. In the video, DNext will be used on the Account dimension to return the next element after Net Income %. Where can the DNext function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the DNext function available…
-
DType function for IBM Planning Analytics (TM1)
DType function for IBM Planning Analytics (TM1) DType returns the element type in a dimension. In the video, DType will be used on the Account dimension to return the element type for Net Income and Trade Sales. Where can the DType function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the DType…
-
ElComp Excel function for IBM Planning Analytics (TM1)
ElComp Excel function for IBM Planning Analytics (TM1) ElComp returns the name of a child element from a consolidated element based on the position. In the video, ElComp will be used to delete the file ‘Price and Cost.csv’ in Excel. Where can the ElComp function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is…
-
ViewExists function for IBM Planning Analytics (TM1)
ViewExists function for IBM Planning Analytics (TM1) ViewExists checks whether a view exists. If the view exists, the result is 1, and if it does not exist, the result is 0. In the video, ViewExists will be used to check if the default view exists in the Sales Quota cube. Where can the ViewExists function be used? TurboIntegrator Which TM1 Server…
-
SubsetAttrPutN function for IBM Planning Analytics (TM1)
SubsetAttrPutN function for IBM Planning Analytics (TM1) SubsetAttrPutN updates a numeric attribute from a subset. In this video, SubsetAttrPutN will be used to update the numeric attribute, No of Elements, from the ‘All Elements’ subset in the Product Scorecard dimension. Where can the SubsetAttrPutN function be used? TurboIntegrator Which TM1 Server version is the SubsetAttrPutN function available for?…