CELL.GETC

Get values (clustered)

You can get values from a cube using the CELL.GETC formula. The CELL.GETC formula is similar to the CELL.GET formula in terms of structure and arguments. However, CELL.GETC gets the data as a cluster, which takes less time.

This table describes the arguments of the function:
Argument Description Example
Alias Name of the database alias Best Practices OLAP
Cube Name of the cube [Sales]

Memb 1,

Memb 2, ...

Element name (unique name, or a name which includes the dimension or hierarchy prefix)

[Product].[Car Tires Summer].[s7000 powergy].[s7000/165] or,

[Product].[s7000/165]

Note:  Unlike CELL.GET, CELL.GETC requires the unique names of elements (or element names that contain the dimension or hierarchy prefix (for example,[Product].[s7000/165] ).
Related topics