ViewRowDimensionSet function for IBM Planning Analytics (TM1)  ViewRowDimensionSet sets the row for a cube view.  In the video, ViewRowDimensionSet will be used to set the Year dimension to the 1st position for the default view in the Sales Quota cube. Where can the ViewRowDimensionSet function be used? TurboIntegrator Which TM1 Server version is the ViewRowDimensionSet function available for? Version 11 and 12 What…

ViewRowSuppressZeroesSet function for IBM Planning Analytics (TM1)  ViewRowSuppressZeroesSet hides or displays rows containing zero values in a cube view.   In the video, ViewRowSuppressZeroesSet will be used to show rows containing zero values in the default view from the Sales Quota cube. Where can the ViewRowSuppressZeroesSet function be used? TurboIntegrator Which TM1 Server version is the ViewRowSuppressZeroesSet function available…

ViewSubsetAssign function for IBM Planning Analytics (TM1)  ViewSubsetAssign assigns a named subset for a view.  In the video, ViewSubsetAssign will be used to set the Quarter subset from the Period dimension to the default view in the Sales Quota cube. Where can the ViewSubsetAssign function be used? TurboIntegrator Which TM1 Server version is the ViewSubsetAssign function available for? Version 11 and 12 What is the…

ViewSuppressZeroesSet function for IBM Planning Analytics (TM1) ViewSuppressZeroesSet hides or displays all rows and columns containing zero values in a cube view. In the video, ViewSuppressZeroesSet will be used to hide all rows and columns containing zero values in the default view from the Sales Quota cube. Where can the ViewSuppressZeroesSet function be used? TurboIntegrator Which TM1 Server version…

ViewExtractSkipConsolidatedStringsSet function for IBM Planning Analytics (TM1) ViewExtractSkipConsolidatedStringsSet skips or includes strings on consolidated cells when exporting a view using ASCIIOutput.​Use in the Prolog tab. In the video, learn how to use ViewExtractSkipConsolidatedStringsSet to export the comments view from the Product Scorecard cube to include consolidations and then show the result when consolidations are excluded. Where can the ViewExtractSkipConsolidatedStringsSet function be…

ViewExtractSkipRuleValuesSet function for IBM Planning Analytics (TM1) ViewExtractSkipRuleValuesSet skips or includes ruled values when exporting a view using ASCIIOutput.​ Use in the Prolog tab.  In the video, learn how to use ViewExtractSkipRuleValuesSet to export the view, vs LY, from the Product Scorecard cube to exclude ruled cells, then show the result when rules are included. Where can the ViewExtractSkipRuleValuesSet function…

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

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