Category: Education

  • DatasourceQuery function for IBM Planning Analytics (TM1)

    DatasourceQuery function for IBM Planning Analytics (TM1)

    DatasourceQuery function for IBM Planning Analytics (TM1) DatasourceQuery sets the query for the data source. In the video, learn how to use DatasourceQuery to retrieve records from an ODBC database. Where can the DatasourceQuery function be used? TurboIntegrator Which TM1 Server version is the DatasourceQuery function available for? Version 11 and 12 What is the syntax for…

  • DatasourceType function for IBM Planning Analytics (TM1)

    DatasourceType function for IBM Planning Analytics (TM1)

    DatasourceType function for IBM Planning Analytics (TM1) DatasourceType sets the type used for the data source. In the video, learn how to use DatasourceType to show what happens when you use the right and wrong type. Where can the DatasourceType function be used? TurboIntegrator Which TM1 Server version is the DatasourceType function available for? Version 11…

  • CubeDRGet function for IBM Planning Analytics (TM1)

    CubeDRGet function for IBM Planning Analytics (TM1)

    CubeDRGet function for IBM Planning Analytics (TM1) CubeDRGet finds existing reservations on a specific cube for all or one user. This function applies to dimensions with one or more hierarchies, while CubeDataReservationGet is used for dimensions with a single hierarchy. Learn how to use the CubeDRGet to return the data reconversion set for the user, TEST, in the Product…

  • CubeDRGetConflicts function for IBM Planning Analytics (TM1)

    CubeDRGetConflicts function for IBM Planning Analytics (TM1)

    CubeDRGetConflicts function for IBM Planning Analytics (TM1) CubeDRGetConflicts gets the current data reservation conflicts of the cube. This function applies to dimensions with one or more hierarchies, while CubeDataReservationGetConflicts is used for dimensions with a single hierarchy. Learn how to use the CubeDRGetConflicts to check if there are data reservation conflicts for user TEST in the Product Type by Region cube. The result will…

  • CubeDRRelease function for IBM Planning Analytics (TM1)

    CubeDRRelease function for IBM Planning Analytics (TM1)

    CubeDRRelease function for IBM Planning Analytics (TM1) CubeDRRelease releases the data reservation specified in the element list. This function applies to dimensions with one or more hierarchies, while CubeDataReservationRelease is used for dimensions with a single hierarchy. Learn how to use the CubeDRRelease to release data reserved by user TEST2, so that user TEST can update the data in the Product Type by Region cube.…

  • CubeDRReleaseAll function for IBM Planning Analytics (TM1)

    CubeDRReleaseAll function for IBM Planning Analytics (TM1)

    CubeDRReleaseAll function for IBM Planning Analytics (TM1) CubeDRReleaseAll releases all the data reservations specified in the element list. This function applies to dimensions with one or more hierarchies, while CubeDataReservationReleaseAll is used for dimensions with a single hierarchy. Learn how to use the CubeDRReleaseAll to release all data reservations for everyone in the Product Type by Region cube. Where can the CubeDRReleaseAll…

  • DimensionCreate function for IBM Planning Analytics (TM1)

    DimensionCreate function for IBM Planning Analytics (TM1)

    DimensionCreate function for IBM Planning Analytics (TM1)  DimensionCreate creates a new dimension. In the video, the DimensionCreate will be used to create a dimension called ‘A New Dimension’. Where can the DimensionCreate function be used? TurboIntegrator Which TM1 Server version is the DimensionCreate function available for? Version 11 and 12 What is the syntax for DimensionCreate?…

  • CubeClearData function for IBM Planning Analytics (TM1)

    CubeClearData function for IBM Planning Analytics (TM1)

    CubeClearData function for IBM Planning Analytics (TM1) CubeClearData clears all the data for a Cube. In this video, CubeClearData is used to clear all the data in the Product Scorecard_Copy cube. Where can the CubeClearData function be used? TurboIntegrator Which TM1 Server version is the CubeClearData function available for? Version 11 and 12 What is the syntax…

  • DimensionDestroy function for IBM Planning Analytics (TM1)

    DimensionDestroy function for IBM Planning Analytics (TM1)

    DimensionDestroy function for IBM Planning Analytics (TM1)  DimensionDestroy deletes a dimension. In the video, the DimensionDestroy will be used to delete the dimension, A New Dimension. Where can the DimensionDestroy function be used? TurboIntegrator Which TM1 Server version is the DimensionDestroy function available for? Version 11 and 12 What is the syntax for DimensionDestroy? DimensionDestroy(DimName)​ Relevant Functions

  • CubeDimensionCountGet function for IBM Planning Analytics (TM1)

    CubeDimensionCountGet function for IBM Planning Analytics (TM1)

    CubeDimensionCountGet function for IBM Planning Analytics (TM1) CubeDimensionCountGet returns the number of dimensions in a cube. In this video, CubeDimensionCountGet is used to count the number of dimensions in the Product Scorecard cube. Where can the CubeDimensionCountGet function be used? TurboIntegrator Which TM1 Server version is the CubeDimensionCountGet function available for? Version 11 and 12 What is…