ViewAttrInsert function for IBM Planning Analytics (TM1) ViewAttrInsert creates a new attribute for a cube view.  In this video, ViewAttrInsert will be used to create an attribute, ‘Description’, for the Employee cube. Where can the ViewAttrInsert function be used? TurboIntegrator Which TM1 Server version is the ViewAttrInsert function available for? Version 11 and 12 What is the…

ViewAttrN function for IBM Planning Analytics (TM1) ViewAttrN returns a numeric attribute from a cube view. In this video, ViewAttrN will be used to retrieve the Reference Number attribute, from the Employee cube’s default view. Where can the ViewAttrN function be used? TurboIntegrator Which TM1 Server version is the ViewAttrN function available for? Version 11 and 12 What is the syntax for…

ViewAttrNL function for IBM Planning Analytics (TM1) ViewAttrNL returns a numeric attribute from a cube view for a locale. In this video, ViewAttrNL will be used to retrieve the ‘Reference Number’ from the Employee cube’s default view for the locale pt-BR. Where can the ViewAttrNL function be used? TurboIntegrator Which TM1 Server version is the ViewAttrNL function available for? Version…

ViewAttrPutN function for IBM Planning Analytics (TM1) ViewAttrPutN deletes a view attribute from a cube. In this video, ViewAttrPutN will be used to insert a numeric value from the Employee cube to the attribute, Reference Number. Where can the ViewAttrPutN function be used? TurboIntegrator Which TM1 Server version is the ViewAttrPutN function available for? Version…

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