-
GetUseActiveSandboxProperty function for IBM Planning Analytics (TM1)
GetUseActiveSandboxProperty function for IBM Planning Analytics (TM1) GetUseActiveSandboxProperty determines if the process can read/write to the base or active sandbox for the user. In this video, GetUseActiveSandboxProperty will be used to get the user’s active sandbox name. Where can the GetUseActiveSandboxProperty function be used? TurboIntegrator Which TM1 Server version is the GetUseActiveSandboxProperty function available for?…
-
HierarchyAttrN function for IBM Planning Analytics (TM1)
HierarchyAttrN function for IBM Planning Analytics (TM1) HierarchyAttrN retrieves a numeric attribute from a dimension’s hierarchy. Where can the HierarchyAttrN function be used? TurboIntegrator Which TM1 Server version is the HierarchyAttrN function available for? Version 11 and 12 What is the syntax for HierarchyAttrN? HierarchyAttrN(Dimension, Hierarchy, Attribute) Relevant Functions
-
HierarchyAttrNL function for IBM Planning Analytics (TM1)
HierarchyAttrNL function for IBM Planning Analytics (TM1) HierarchyAttrNL retrieves a numeric attribute from a dimension’s hierarchy given a language locale. Where can the HierarchyAttrNL function be used? TurboIntegrator Which TM1 Server version is the HierarchyAttrNL function available for? Version 11 and 12 What is the syntax for HierarchyAttrNL? HierarchyAttrNL(Dimension, Hierarchy, Attribute, [Locale]) Relevant Functions
-
DatasourceODBOHierarchyName function for IBM Planning Analytics (TM1)
DatasourceODBOHierarchyName function for IBM Planning Analytics (TM1) DatasourceODBOHierarchyName is used for OLAP products like SAP BW; this function sets the name of the hierarchy from a dimension. Where can the DatasourceODBOHierarchyName function be used? TurboIntegrator Which TM1 Server version is the DatasourceODBOHierarchyName function available for? Version 11 What is the syntax for DatasourceODBOHierarchyName? DatasourceODBOHierarchyName =…
-
DatasourceODBOLocation function for IBM Planning Analytics (TM1)
DatasourceODBOLocation function for IBM Planning Analytics (TM1) DatasourceODBOLocation sets the name of the OLAP server’s location. Where can the DatasourceODBOLocation function be used? TurboIntegrator Which TM1 Server version is the DatasourceODBOLocation function available for? Version 11 What is the syntax for DatasourceODBOLocation? DatasourceODBOLocation = ‘Location’ Relevant Functions
-
DatasourceODBOProvider function for IBM Planning Analytics (TM1)
DatasourceODBOProvider function for IBM Planning Analytics (TM1) DatasourceODBOProvider sets the name of the ODBO provider installed on your server. Where can the DatasourceODBOProvider function be used? TurboIntegrator Which TM1 Server version is the DatasourceODBOProvider function available for? Version 11 What is the syntax for DatasourceODBOProvider? DatasourceODBOProvider = ‘Provider’ Relevant Functions
-
DatasourceODBOSAPClientID function for IBM Planning Analytics (TM1)
DatasourceODBOSAPClientID function for IBM Planning Analytics (TM1) DatasourceODBOSAPClientID sets the client ID that connects to the SAP Server. Where can the DatasourceODBOSAPClientID function be used? TurboIntegrator Which TM1 Server version is the DatasourceODBOSAPClientID function available for? Version 11 What is the syntax for DatasourceODBOSAPClientID? DatasourceODBOSAPClientID = ‘ID’ Relevant Functions
-
HierarchySubsetAttrN function for IBM Planning Analytics (TM1)
HierarchySubsetAttrN function for IBM Planning Analytics (TM1) HierarchySubsetAttrN retrieves a field from a numeric attribute from a subset tied to a dimension’s hierarchy. Where can the HierarchySubsetAttrN function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetAttrN function available for? Version 11 and 12 What is the syntax for HierarchySubsetAttrN? HierarchySubsetAttrN(Dimension, Hierarchy, Subset, Attribute)…
-
HierarchySubsetAttrS function for IBM Planning Analytics (TM1)
HierarchySubsetAttrS function for IBM Planning Analytics (TM1) HierarchySubsetAttrS retrieves a field from a string attribute of a subset tied to a dimension’s hierarchy. In this video, HierarchySubsetAttrS will be used to retrieve data from the Office attribute associated with the Benelux subset in the Western Europe hierarchy from the Sales Region dimension. Where can the HierarchySubsetAttrS function be used? TurboIntegrator Which TM1 Server…
-
HierarchySubsetAttrPutN function for IBM Planning Analytics (TM1)
HierarchySubsetAttrPutN function for IBM Planning Analytics (TM1) HierarchySubsetAttrPutN writes a numeric value to a subset’s attribute or set of elements in a hierarchy for a dimension. Where can the HierarchySubsetAttrPutN function be used? TurboIntegrator Which TM1 Server version is the HierarchySubsetAttrPutN function available for? Version 11 and 12 What is the syntax for HierarchySubsetAttrPutN? HierarchySubsetAttrPutS(String, DimName, HierName, SubName, AttrName,…