CUBESET(connection, set_expression [,caption] [,sort_order] [,sort_by])

Returns the calculated members returns from a cube.

connectionThe name of the connection.
set_expressionA SET expression.
caption(Optional) The text to overwrite any caption.
sort_order(Optional) The type of sort order to perform:
0 = SortNone (default)
1 = SortAscending
2 = SortDescending
3 = SortAlphaAscending
4 = SortAlphaDescending
5 = SortNaturalAscending
6 = SortNaturalDescending
sort_by(Optional) The name of the measure to sort by.

Remarks

* Added in Excel 2007.
* Defines a calculated set of members or tuples by sending a set of expressions to the cube which creates the set and then returns that set.
* While the data is being retrieved #GETTING_DATA is displayed in the cell.
* For the Microsoft documentation refer to support.office.com

 AB
1????


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top