-
ABS function for IBM Planning Analytics (TM1)
ABS function for IBM Planning Analytics (TM1) ABS converts a number into an absolute value. In the video, ABS will be used to convert a negative value into an absolute value and apply it in the rule to populate the Commission measure in the Product Scorecard cube. Where can the ABS function be used? Rules…
-
NumericGlobalVariable function for IBM Planning Analytics (TM1)
NumericGlobalVariable function for IBM Planning Analytics (TM1) NumericGlobalVariable declares a numeric global variable that is recognised by other processes within a Chore or from sub-processes called by the ExecuteProcess function. Where can the NumericGlobalVariable function be used? TurboIntegrator Which TM1 Server version is the NumericGlobalVariable function available for? Version 11 and 12 What is the…
-
StringGlobalVariable function for IBM Planning Analytics (TM1)
StringGlobalVariable function for IBM Planning Analytics (TM1) StringGlobalVariable declares a string global variable that is recognised by other processes within a Chore or from sub-processes called by the ExecuteProcess function. In this video, StringGlobalVariable will be used to declare a string global variable, sGlobalVariable, and show that the variable can be accessed from processes that are called…
-
DimensionAttrS function for IBM Planning Analytics (TM1)
DimensionAttrS function for IBM Planning Analytics (TM1) DimensionAttrS returns a string attribute for a specified dimension. In this video, DimensionAttrS will be used to retrieve string attribute value of the dimension and apply it in the rule to populate the Comment measure in the Product Scorecard cube. Where can the DimensionAttrS function be used? Rules and…
-
DatasourceODBOCatalog function for IBM Planning Analytics (TM1)
DatasourceODBOCatalog function for IBM Planning Analytics (TM1) DatasourceODBOCatalog sets the name of the ODBO database collection that you want to connect. Where can the DatasourceODBOCatalog function be used? TurboIntegrator Which TM1 Server version is the DatasourceODBOCatalog function available for? Version 11 What is the syntax for DatasourceODBOCatalog? DatasourceODBOCatalog = Catalog Relevant Functions
-
DatasourceODBOConnectionString function for IBM Planning Analytics (TM1)
DatasourceODBOConnectionString function for IBM Planning Analytics (TM1) DatasourceODBOConnectionString sets the connection parameters required to connect to the OLAP server. Where can the DatasourceODBOConnectionString function be used? TurboIntegrator Which TM1 Server version is the DatasourceODBOConnectionString function available for? Version 11 What is the syntax for DatasourceODBOConnectionString? DataSourceODBOConnectionString = ‘String’ Relevant Functions
-
DatasourceODBOCubeName function for IBM Planning Analytics (TM1)
DatasourceODBOCubeName function for IBM Planning Analytics (TM1) DatasourceODBOCubeName sets the name of the cube you want to connect to from the OLAP Server. Where can the DatasourceODBOCubeName function be used? TurboIntegrator Which TM1 Server version is the DatasourceODBOCubeName function available for? Version 11 What is the syntax for DatasourceODBOCubeName? DatasourceODBOCubeName = ‘Name’ Relevant Functions
-
DimensionAttrDelete function for IBM Planning Analytics (TM1)
DimensionAttrDelete function for IBM Planning Analytics (TM1) DimensionAttrDelete deletes a dimension’s attribute. Where can the DimensioDimensionAttrDeletenAttrN function be used? TurboIntegrator Which TM1 Server version is the DimensionAttrDelete function available for? Version 11 and 12 What is the syntax for DimensionAttrDelete? DimensionAttrDelete(AttributeName) Relevant Functions
-
EvalJavaN function for IBM Planning Analytics (TM1)
EvalJavaN function for IBM Planning Analytics (TM1) EvalJavaN is a rules function that executes a Java TI process that returns a number. Where can the EvalJavaS function be used? Rules Which TM1 Server version is the EvalJavaN function available for? Version 11 What is the syntax for EvalJavaN? EvalJavaN(‘Class’, [‘OptionalParameter1’, ‘OptionalParameter2’, …]) Relevant Functions
-
DimensionAttrInsert function for IBM Planning Analytics (TM1)
DimensionAttrInsert function for IBM Planning Analytics (TM1) DimensionAttrInsert inserts a string, numeric or alias attribute for dimensions. Where can the DimensionAttrInsert function be used? TurboIntegrator Which TM1 Server version is the DimensionAttrInsert function available for? Version 11 and 12 What is the syntax for DimensionAttrInsert? DimensionAttrInsert(PreviousAttribute, NewAttribute, AttributeType) Relevant Functions