-
ViewExtractFilterByTitlesSet function for IBM Planning Analytics (TM1)
ViewExtractFilterByTitlesSet function for IBM Planning Analytics (TM1) ViewExtractFilterByTitlesSet skips or includes elements in the title axis when exporting a view using ASCIIOutput. Use in the Prolog tab. In the video, learn how to use ViewExtractFilterByTitlesSet to export the Summary view from the Product Scorecard cube and exclude title elements. Where can the ViewExtractFilterByTitlesSet function be used? TurboIntegrator Which TM1 Server version is…
-
DBS function for IBM Planning Analytics (TM1)
DBS function for IBM Planning Analytics (TM1) DBS is used to send a value to a cube’s cell. This function cannot send a string to a cube. This function would typically be when you need to bulk upload data in Excel. To send strings, use the DBSS function. In the video, the DBS will be…
-
ElPar Excel function for IBM Planning Analytics (TM1)
ElPar Excel function for IBM Planning Analytics (TM1) ElPar returns the parent of an element in a dimension. In the video, ElPar will be used to return the parents for the element, Bike Racks. Where can the ElPar function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the ElPar function available for?…
-
DBSA function for IBM Planning Analytics (TM1)
DBSA function for IBM Planning Analytics (TM1) DBSA is used to send a value to a dimension attribute. Depending on the attribute type, the value sent can be either a string or numeric. In the video, the DBSA function will be used to Populate the attribute Active Status from the Product Type dimension. Where can the DBSA…
-
ElParN Excel function for IBM Planning Analytics (TM1) – Excel
ElParN Excel function for IBM Planning Analytics (TM1) – Excel ElParN returns the number of parents of an element. In the video, ElParN will be demoed in Excel to return the number of parents ‘Bikes’ belongs to, from the Product Type dimension. Please note that the same logic can be used in TurboIntegrator and Excel.…
-
DBSS function for IBM Planning Analytics (TM1)
DBSS function for IBM Planning Analytics (TM1) DBSS is used to send text to a cube’s cell. In the video, the DBSS will add text to the System Info cube under the Comments measure. Where can the DBSS function be used? Excel Which TM1 Server version is the DBSS function available for? Version 11 and…
-
DBSW function for IBM Planning Analytics (TM1)
DBSW function for IBM Planning Analytics (TM1) DBSW sends a numeric value to a cube’s cell and is more efficient than DBS over WAN. This function cannot send a string to a cube. To send strings, use the DBSS function. This function would typically be used when the data comes from a person who does…
-
DFrst function for IBM Planning Analytics (TM1)
DFrst function for IBM Planning Analytics (TM1) DFrst returns the first element in a dimension. In the video, DFrst will be used to return the first element in the Account dimension. Where can the DFrst function be used? Excel Which TM1 Server version is the DFrst function available for? Version 11 and 12 What is…
-
DimIx function for IBM Planning Analytics (TM1) – Excel
DimIx function for IBM Planning Analytics (TM1) – Excel DimIx returns an element’s index number in a dimension. In the video, DimIx will be used on the Account dimension to return the index for an element. Where can the DimIx function be used? Excel, Rules and TurboIntegrator Which TM1 Server version is the DimIx function…
-
DBRW function for IBM Planning Analytics (TM1)
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…