Extracting data from Strategy cubes with R requires the get_cube () function from the mstrio R package. This function has 2 required parameter and 2 optional parameters.
Required:
- connection - this is a connection object that is passed in to all functions when using mstrio for R
- cube_id - this is the ID of the cube in Strategy and gets passed in as a string. The cube ID can be obtained by right clicking the object in Strategy Web and selecting properties. Developer may also be used to get the cube ID.
Optional:
- offset - this parameter is an integer that indicates which row of the cube the server should begin fetching from
- limit - this parameter is an integer that indicates how many rows the server should fetch at a time, until complete
KB442336
