Category: Content Type

  • ViewRowDimensionSet function for IBM Planning Analytics (TM1)

    ViewRowDimensionSet function for IBM Planning Analytics (TM1)

    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 function for IBM Planning Analytics (TM1)

    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 function for IBM Planning Analytics (TM1)

    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 function for IBM Planning Analytics (TM1)

    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…

  • ViewTitleDimensionSet function for IBM Planning Analytics (TM1)

    ViewTitleDimensionSet function for IBM Planning Analytics (TM1)

    ViewTitleDimensionSet function for IBM Planning Analytics (TM1)  ViewTitleDimensionSet sets a dimension to the title position for a cube view. In the video, ViewTitleDimensionSet will be used to publish the Finance view from the Employee cube. Where can the ViewTitleDimensionSet function be used? TurboIntegrator Which TM1 Server version is the ViewTitleDimensionSet function available for? Version 11 and 12 What is…

  • SubsetMDXGet function for IBM Planning Analytics (TM1)

    SubsetMDXGet function for IBM Planning Analytics (TM1)

    SubsetMDXGet function for IBM Planning Analytics (TM1) SubsetMDXGet retrieves the MDX statement used for a subset.  In this video, SubsetMDXGet will be used to retrieve the MDX statement from the ‘All Elements’ subset in the Product Scorecard dimension. Where can the SubsetMDXGet function be used? TurboIntegrator Which TM1 Server version is the SubsetMDXGet function available for? Version…

  • ViewConstruct function for IBM Planning Analytics (TM1)

    ViewConstruct function for IBM Planning Analytics (TM1)

    ViewConstruct function for IBM Planning Analytics (TM1)  ViewConstruct pre-calculates a view and stores the view in memory for faster access.  In the video, ViewConstruct will be used to pre-calculate the ViewContruct_Test view from the General Ledger cube. Where can the ViewConstruct function be used? TurboIntegrator Which TM1 Server version is the ViewConstruct function available for? Version 11 and 12…

  • SubsetMDXSet function for IBM Planning Analytics (TM1)

    SubsetMDXSet function for IBM Planning Analytics (TM1)

    SubsetMDXSet function for IBM Planning Analytics (TM1) SubsetMDXSet applies an MDX expression to a public subset. If the subset doesn’t exist, then an error will occur.  In this video, SubsetMDXSet will be used to set an MDX expression in the ‘All Elements’ subset from the Product Scorecard dimension. Where can the SubsetMDXSet function be used? TurboIntegrator Which…

  • ViewCreate function for IBM Planning Analytics (TM1)

    ViewCreate function for IBM Planning Analytics (TM1)

    ViewCreate function for IBM Planning Analytics (TM1)  ViewCreate creates an empty view for a cube.  In the video, ViewCreate will be used to create the view, My Reporting View, in the Sales Quota cube. Where can the ViewCreate function be used? TurboIntegrator Which TM1 Server version is the ViewCreate function available for? Version 11 and 12 What is the…

  • SValue function for IBM Planning Analytics (TM1)

    SValue function for IBM Planning Analytics (TM1) SValue is a TM1 reserved local variable determining whether the current cell is a string. In this video, SValue will be used to identify if the ‘Product Scorecard’ cube’s data type is string or numeric. Where can the SValue function be used? TurboIntegrator Which TM1 Server version is…