Excel Function : CUBESET

Download now!

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.