TM1ProcessError.LOG function for IBM Planning Analytics (TM1) TM1ProcessError.LOG generates a log file when a process encounters an error. In this video, a process will be executed which will cause an error that creates a TM1ProcessError log file. Where can the TM1ProcessError.LOG function be used? TurboIntegrator Which TM1 Server version is the TM1ProcessError.LOG function available for?…

Value_Is_String function for IBM Planning Analytics (TM1) Value_Is_String is a reserved local variable that checks if the data source type is a string or number. If the function return ‘1’, then the value is a string,  otherwise it is numeric. For reserved variables, we don’t need to define it in the script. In this video, Value_Is_String will be used to…

ViewAttrDelete function for IBM Planning Analytics (TM1) ViewAttrDelete deletes a view attribute from a cube. In this video, ViewAttrDelete will be used to delete the view attribute, Developers Commentary, from the Employee cube. Where can the ViewAttrDelete function be used? TurboIntegrator Which TM1 Server version is the ViewAttrDelete function available for? Version 11 and 12 What is the…

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…

ViewCreateByMDX function for IBM Planning Analytics (TM1)  ViewCreateByMDX creates a cube view with an MDX expression. In the video, ViewCreateByMDX will be used to create a view for the Finance cube using an MDX expression. Where can the ViewCreateByMDX function be used? TurboIntegrator Which TM1 Server version is the ViewCreateByMDX function available for? Version 11 and 12…

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…