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…

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

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…

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

DBRW function for IBM Planning Analytics (TM1) The DBRW serves as a fundamental tool for interacting with multidimensional data cubes on IBM Planning Analytics (TM1), enabling precise retrieval and modification of data within the context of financial planning, analysis and reporting. This function is used directly in Excel, enabling users to create dynamic and interactive…

ElLev Excel function for IBM Planning Analytics (TM1) ElLev returns an element’s level in the dimension. In the video, ElLev will be used to return the consolidation and the descendants of All Products by Category and show each element’s level. Where can the ElLev function be used? Excel, Rules and TurboIntegrator Which TM1 Server version…