Slice Excel Formulas

1. **CubeDimensions**

• Description: Returns a comma-separated list of dimensions in the cube.

• Parameters:

• string instanceName: The name of the server.

• string cubeName: The name of the cube.

2. **SUBNM**

• Description: Returns an element from a hierarchy.

• Parameters:

• string instanceDimension: Server:Dimension or Server:Dimension:Hierarchy for the element.

• string subset: The subset to be displayed.

• object element: The element selected.

• string alias: The alias to be displayed.

3. **ExecuteActionButton**

• Description: Executes Button. Not to be used in a worksheet.

• Parameters:

• string id: Button ID.

4. **DBRA**

• Description: Gets attribute of an element.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

• string element: Element.

• string attribute: Attribute.

5. **DBRASingle**

• Description: Gets attribute of an element.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

• string element: Element.

• string attribute: Attribute.

6. **TM1User**

• Description: Returns current user name.

• Parameters:

• string serverName: TM1 Server Name.

7. **DFRST**

• Description: Returns the first element of a specified hierarchy.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

8. **DIMIX**

• Description: Returns the index number of an element within a hierarchy.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

• string element: Element name.

9. **DIMNM**

• Description: Returns the element of a hierarchy that corresponds to the index provided.

• Parameters:

• string instanceDimension: Server:Dimension or Server:Dimension:Hierarchy.

• object index: Element index.

• string alias: Alias.

10. **DIMSIZ**

• Description: Returns hierarchy size.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

11. **DNEXT**

• Description: Returns following element of a hierarchy.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

• string element: Element.

12. **DNLEV**

• Description: Returns the number of levels in a hierarchy.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

13. **DTYPE**

• Description: Returns element type.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

• string element: Element name.

14. **ELCOMP**

• Description: Returns the name of n-th child of a consolidated element provided.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

• string element: Element name.

• object index: Component Index.

15. **ELCOMPN**

• Description: Returns the number of components of an element provided.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

• string element: Element name.

16. **ELISCOMP**

• Description: Returns true if element 1 is a component of element 2.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

• string element1: Element 1 name.

• string element2: Element 2 name.

17. **ELISPAR**

• Description: Returns true if element 1 is a parent of element 2.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

• string element1: Element 1 name.

• string element2: Element 2 name.

18. **ELLEV**

• Description: Returns the level of an element in a hierarchy.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

• string element: Element name.

19. **ELPAR**

• Description: Returns the name of n-th parent of an element provided.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

• string element: Element name.

• object index: Component Index.

20. **ELPARN**

• Description: Returns the number of parents of an element provided.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

• string element: Element name.

21. **ELSLEN**

• Description: Returns the length of an element principal name.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

• string element: Element name.

22. **ELWEIGHT**

• Description: Returns the weight of element 2 in consolidation of Element 1.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

• string element1: Element 1 name.

• string element2: Element 2 name.

23. **SUBSIZ**

• Description: Returns the number of elements in a hierarchy subset.

• Parameters:

• string instanceDim: Server:Dimension or Server:Dimension:Hierarchy.

• string subset: Subset Name.

24. **TABDIM**

• Description: Returns the cube dimension name corresponding to the index provided.

• Parameters:

• string instanceCube: Server:Cube.

• object index: Dimension Index.

25. **TM1ELLIST**

• Description: Returns the array of hierarchy elements.

• Parameters:

• string instanceDimension: Server:Dimension or Server:Dimension:Hierarchy.

• string subset: Subset Name.

• object[] elementList: Array of hierarchy elements.

• string alias: Alias to display.

• object expandAbove: 1 or 0.

• string mdx: MDX.

• object indentRate: Indent Rate.

• string indentCharacter: Indent Character.

26. **TM1PRIMARYDBNAME**

• Description: Returns data bases names.

• Parameters:

• object option: 0 - First server. 1 - Logged in servers. 2 - All servers.

27. **SliceIsLoggedIn**

• Description: Returns true if the user is logged in.

• Parameters:

• string instanceName: The name of the server.

28. **TM1RptTitle**

• Description: Returns Active Form title dimension.

• Parameters:

• string instanceDimension: Server:Dimension or Server:Dimension:Hierarchy.

• object element: Element 1, Element 2, etc.

29. **TM1RptRow**

• Description: Defines a master row used by an Active Form.

• Parameters:

• string instanceCubeView: Reference to TM1RPTVIEW formula.

• string instanceDimension: Server:Dimension for the view.

• string subset: Subset.

• object[,] subElements: Subelements.

• string alias: Alias.

• object exabove: Expand above (0 or 1).

• string mdx: MDX.

• object indent: Indent.

• object drill: Allow drill.

30. **TM1RptColumn**

• Description: Defines a master column used by an Active Form.

• Parameters:

• string instanceCubeView: Reference to TM1RPTVIEW formula.

• string instanceDimension: Server:Dimension for the view.

• string subset: Subset.

• object[,] subElements: Subelements.

• string alias: Alias.

• object exabove: Expand above (0 or 1).

• string mdx: MDX.

• object drill: Allow drill.

31. **TM1RptView**

• Description: Defines a view used by an Active Form.

• Parameters:

• string instanceCubeID: Server:Cube:ViewName for the view.

• int zeroSuppression: 0: None, 1: On Rows, 2: On Columns, 3: On Rows and Columns.

• params object[] arguments: View titles.

32. **TM1RptElIsConsolidated**

• Description: Returns boolean value to indicate whether an element in an Active Form is consolidated.

• Parameters:

• object ref1: An absolute reference to a cell containing TM1RPTROW formula.

• object ref2: A relative reference containing an element from TM1RPTROW formula.

33. **TM1RptElLev**

• Description: Returns integer value to indicate element level.

• Parameters:

• object ref1: An absolute reference to a cell containing TM1RPTROW formula.

• object ref2: A relative reference containing an element from TM1RPTROW formula.

34. **TM1RptElIsExpanded**

• Description: Returns boolean value to indicate whether an element in an Active Form is expanded.

• Parameters:

• object ref1: An absolute reference to a cell containing TM1RPTROW formula.

• object ref2: A relative reference containing an element from TM1RPTROW formula.

35. **TM1RptFilter**

• Description: Creates a filter to an active form column.

• Parameters:

• string viewRef: Active Form View reference.

• string tuple: Tuple of active form column.

• string function: Function name.

• object value: Function value.

• string order: Order (asc or desc).

36. **View**

• Description: Returns the instance and cube name.

• Parameters:

• string instanceCube: Server:Cube for the cell.

• params string[] elements: Element 1, Element 2, etc.

37. **DBRW**

• Description: Writes data to a cube.

• Parameters:

• string instanceCube: Server:Cube for the cell.

• params object[] elements: Element 1, Element 2, etc.

38. **DBR**

• Description: Reads data from a cube.

• Parameters:

• string instanceCube: Server:Cube for the cell.

• params object[] elements: Element 1, Element 2, etc.

39. **DBH**

• Description: Reads data from a cube with hierarchy.

• Parameters:

• string instanceCube: Server:Cube for the cell.

• params object[] parameters: P1:Dimension Name 1 (or Dimension:Hierarchy Name 1). P2: Element Name 1, etc.

40. **DBHW**

• Description: Writes data to a cube with hierarchy.

• Parameters:

• string instanceCube: Server:Cube for the cell.

• params object[] parameters: P1:Dimension Name 1 (or Dimension:Hierarchy Name 1). P2: Element Name 1, etc.

41. **DBS**

• Description: Sets a value in a cube.

• Parameters:

• object value: Value.

• string instanceCube: Server:Cube for the cell.

• params object[] elements: Element 1, Element 2, etc.

42. **DBSW**

• Description: Writes a value to a cube.

• Parameters:

• object value: Value.

• string instanceCube: Server:Cube for the cell.

• params object[] elements: Element 1, Element 2, etc.

43. **DBSS**

• Description: Sets a value in a cube (shortcut for DBS).

• Parameters:

• object value: Value.

• string instanceCube: Server:Cube for the cell.

• params object[] elements: Element 1, Element 2, etc.

44. **DBSA**

• Description: Sets an attribute value in a dimension.

• Parameters:

• object value: Value.

• string instanceDim: Server:Dimension.

• string element: Element name.

• string attribute: Attribute name.

45. **TM1RECALC1**

• Description: Recalculates the active worksheet.

• Parameters: None.

46. **TM1REFRESH**

• Description: Rebuilds the active worksheet.

• Parameters: None.

47. **TM1REBUILDALL**

• Description: Rebuilds all worksheets in a workbook.

• Parameters: None.

48. **DBSSEND**

• Description: Sends DBS in the active worksheet.

• Parameters: None.

49. **DBSSENDALL**

• Description: Sends DBS in the active workbook.

• Parameters: None.

50. **RunTIProcess**

• Description: Runs a TI Process.

• Parameters:

• string instanceName: Server Name.

• string processName: Process to execute.

• params object[] parameters: Parameters.

51. **N_CONNECT**

• Description: Connects to a TM1 server using UDF.

• Parameters:

• string groupInstance: Group:Server or Server.

• string userName: User Name.

• string password: Password.

• string camNamespace: Cam Namespace [optional].

Here is the list of UDF (User Defined Function) names extracted from the provided

52. **ArcAssistant**

• Description: Makes a request to Arc Assistant.

• Parameters:

• object message: Text message to Arc Assistant.

• object maxTokens: Optional. Max tokens for generating response. Value between 1 and 2048.

• object temperature: Optional. Temperature. Value between 0 and 2.

53. **ArcAssistant.Data**

• Description: Makes a request to Arc Assistant and provide data array.

• Parameters:

• string message: Text message to Arc Assistant.

• object data: Data array.

• object maxTokens: Optional. Max tokens for generating response. Value between 1 and 2048.

• object temperature: Optional. Temperature. Value between 0 and 2.