Category: Education

  • DimensionElementComponentDelete function for IBM Planning Analytics (TM1)

    DimensionElementComponentDelete function for IBM Planning Analytics (TM1)

    DimensionElementComponentDelete function for IBM Planning Analytics (TM1)  DimensionElementComponentDelete deletes an element from a consolidated element in a rollup. This action occurs after a commitment to the process (e.g., at the end of executing the metadata tab). To action this function immediately, use DimensionElementComponentDeleteDirect. In the video, the DimensionElementComponentDelete will be used to delete the element Denmark from the consolidated element Scandinavia in…

  • DatasourceASCIIHeaderRecords function for IBM Planning Analytics (TM1)

    DatasourceASCIIHeaderRecords function for IBM Planning Analytics (TM1)

    DatasourceASCIIHeaderRecords function for IBM Planning Analytics (TM1) DatasourceASCIIHeaderRecords sets the header records for a text file. In the video, learn how to use DatasourceASCIIHeaderRecords to change the header record to 1. Where can the DatasourceASCIIHeaderRecords function be used? TurboIntegrator Which TM1 Server version is the DatasourceASCIIHeaderRecords function available for? Version 11 and 12 What is the…

  • DatasourceASCIIQuoteCharacter function for IBM Planning Analytics (TM1)

    DatasourceASCIIQuoteCharacter function for IBM Planning Analytics (TM1)

    DatasourceASCIIQuoteCharacter function for IBM Planning Analytics (TM1) DatasourceASCIIQuoteCharacter sets the quote character for a text file In the video, learn how to use DatasourceASCIIQuoteCharacter to fix the quote character.  Where can the DatasourceASCIIQuoteCharacter function be used? TurboIntegrator Which TM1 Server version is the DatasourceASCIIQuoteCharacter function available for? Version 11 and 12 What is the syntax…

  • DatasourceASCIIThousandSeparator function for IBM Planning Analytics (TM1)

    DatasourceASCIIThousandSeparator function for IBM Planning Analytics (TM1)

    DatasourceASCIIThousandSeparator function for IBM Planning Analytics (TM1) DatasourceASCIIThousandSeparator sets the thousand separator for a text file. In the video, learn how to use DatasourceASCIIThousandSeparator to change the thousand separator to a full stop.  Where can the DatasourceASCIIThousandSeparator function be used? TurboIntegrator Which TM1 Server version is the DatasourceASCIIThousandSeparator function available for? Version 11 and 12 What is the…

  • DatasourceCubeview function for IBM Planning Analytics (TM1)

    DatasourceCubeview function for IBM Planning Analytics (TM1)

    DatasourceCubeview function for IBM Planning Analytics (TM1) DatasourceCubeview sets the cube view in the data source. In the video, learn how to use DatasourceCubeview to change the view set in the Data Source to the view, Test. Where can the DatasourceCubeview function be used? TurboIntegrator Which TM1 Server version is the DatasourceCubeview function available for? Version 11…

  • CubeTimeLastUpdated function for IBM Planning Analytics (TM1)

    CubeTimeLastUpdated function for IBM Planning Analytics (TM1)

    CubeTimeLastUpdated function for IBM Planning Analytics (TM1) CubeTimeLastUpdated returns a serial value which refers to the last time the cube was updated.  In this video, CubeTimeLastUpdated is used to retrieve when the cube, zTest, was last updated Where can the CubeTimeLastUpdated function be used? TurboIntegrator Which TM1 Server version is the CubeTimeLastUpdated function available for? Version…

  • DimensionElementComponentAdd function for IBM Planning Analytics (TM1)

    DimensionElementComponentAdd function for IBM Planning Analytics (TM1)

    DimensionElementComponentAdd function for IBM Planning Analytics (TM1)  DimensionElementComponentAdd adds an element to a consolidated element in a rollup according to a specific weight in a dimension. This action occurs after a commitment in the process (e.g. at the end of executing the metadata tab). To action this function immediately, use DimensionElementComponentAddDirect. In the video, the DimensionElementComponentAdd will be used to…

  • CubeUnload function for IBM Planning Analytics (TM1)

    CubeUnload function for IBM Planning Analytics (TM1)

    CubeUnload function for IBM Planning Analytics (TM1) CubeUnload unloads a cube and its view from the memory. In this video, CubeUnload is used to unload the Product Scorecard cube. Where can the CubeUnload function be used? TurboIntegrator Which TM1 Server version is the CubeUnload function available for? Version 11 and 12 What is the syntax for CubeUnload? CubeUnload(CubeName)…

  • DimensionElementPrincipalName function for IBM Planning Analytics (TM1)

    DimensionElementPrincipalName function for IBM Planning Analytics (TM1)

    DimensionElementPrincipalName function for IBM Planning Analytics (TM1)  DimensionElementPrincipalName returns the principal name of an element or element alias. In the video, the DimensionElementPrincipalName will be used to get the principal name of the Australian Dollar in the Currency dimension. Where can the DimensionElementPrincipalName function be used? TurboIntegrator Which TM1 Server version is the DimensionElementPrincipalName function available for? Version 11…

  • DimensionExists function for IBM Planning Analytics (TM1)

    DimensionExists function for IBM Planning Analytics (TM1)

    DimensionExists function for IBM Planning Analytics (TM1)  DimensionExists checks whether a dimension exists. If the dimension exists, the result is 1; if it does not, the result is 0. In the video, the DimensionExists will be used to check if the dimension, A New Dimension, exist. Where can the DimensionExists function be used? TurboIntegrator Which TM1 Server version…