Slice Worksheet Formulas
Complete reference of all 56 Slice functions and formulas.
# | Formula | Description |
|---|---|---|
1 |
| Makes a request to Arc Assistant |
2 |
| Makes a request to Arc Assistant with a data array |
3 |
| Returns a comma-separated list of dimensions in the cube |
4 |
| Read/Write data from a cube with hierarchy |
5 |
| Read/Write data to a cube with hierarchy |
6 |
| Read/Write data from a cube IBM docs |
7 |
| Gets attribute of an element IBM docs |
8 |
| Same as DBRA but avoid batching. |
9 |
| Read/Write data to a cube IBM docs |
10 |
| Sets a value in a cube IBM docs |
11 |
| Sets an attribute value in a dimension IBM docs |
12 |
| Sets a value in a cube (shortcut for DBS) IBM docs |
13 |
| Sends DBS in the active worksheet |
14 |
| Sends DBS in the active workbook |
15 |
| Writes a value to a cube IBM docs |
16 |
| Creates synthetic members that can be incorporated into reporting. IBM docs |
17 |
| Returns the first element of a specified hierarchy IBM docs |
18 |
| Returns the index number of an element within a hierarchy IBM docs |
19 |
| Returns the element of a hierarchy that corresponds to the index provided IBM docs |
20 |
| Returns hierarchy size IBM docs |
21 |
| Returns following element of a hierarchy IBM docs |
22 |
| Returns the number of levels in a hierarchy IBM docs |
23 |
| Returns element type IBM docs |
24 |
| Returns the name of the n-th child of a consolidated element IBM docs |
25 |
| Returns the number of components of an element IBM docs |
26 |
| Returns true if element1 is a component of element2 IBM docs |
27 |
| Returns true if element1 is a parent of element2 IBM docs |
28 |
| Returns the level of an element in a hierarchy IBM docs |
29 |
| Returns the name of the n-th parent of an element IBM docs |
30 |
| Returns the number of parents of an element IBM docs |
31 |
| Returns the length of an element principal name IBM docs |
32 |
| Returns the weight of element2 in consolidation of element1 IBM docs |
33 |
| Executes a Button. Not to be used in a worksheet |
34 |
| Connects to a TM1 server using UDF |
35 |
| Runs a TI Process |
36 |
| Returns true if the user is logged in |
37 |
| Returns an element from a hierarchy IBM docs |
38 |
| Returns the number of elements in a hierarchy subset IBM docs |
39 |
| Returns the cube dimension name corresponding to the index IBM docs |
40 |
| Returns the array of hierarchy elements IBM docs |
41 |
| Returns database names. 0=First server, 1=Logged in servers, 2=All servers IBM docs |
42 |
| Recalculates the active worksheet |
43 |
| Rebuilds all worksheets in a workbook |
44 |
| Rebuilds the active worksheet |
45 |
| Defines a master column used by an Active Form |
46 |
| Returns boolean indicating whether an Active Form element is consolidated IBM docs |
47 |
| Returns boolean indicating whether an Active Form element is expanded IBM docs |
48 |
| Returns integer indicating element level IBM docs |
49 |
| Creates a filter on an Active Form column IBM docs |
50 |
| Defines a master row used by an Active Form IBM docs |
51 |
| Returns Active Form title dimension IBM docs |
52 |
| Defines a view used by an Active Form IBM docs |
53 |
| Takes a set expression as input and returns a member of a set (similar to DBRW and SUBNM). IBM docs |
54 |
| Returns current user name IBM docs |
55 |
| Hierarchy-aware writeback formula. Writes a value to a cube using fully-qualified [dimension].[hierarchy].[element] member references. IBM docs |
56 |
| Returns the instance and cube name IBM docs |