Excel Function : CUBESET
Category
Cube
Description
Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel.
Microsoft Excel Reference Page
https://support.office.com/en-us/article/CUBESET-function-5b2146bd-62d6-4d04-9d8f-670e993ee1d9
Syntax and Description of the CUBESET Excel Function
sas sql_server sql_server2008 sql_server_2008 sql_server_2005 sql_server_2000 sql_server_7.0 access oracle networking sql server databases db2 sybase mysql informix postgresql db2. This will keep the individual cube in a separate file and the underlying data in separate file. The thing to notice here is that the size of the cube is much smaller as compared to the size of the cube dataset. The cube will have the data in the format of the dimension, measure and measure. Das Dataset-Objekt besitzt eine Methode zum Importieren von Daten aus einer CSV-Datei. Die Methode Read
About CUBESET Excel Function
CUBESET is a function that returns a subset of data from a cube. The function takes three arguments: a reference to a cube, a set of members, and an optional flag to return a set of tuples.