Extracting data from Strategy cubes with Python requires the get_cube () function from the mstrio Python package. This function has 1 required parameter and 3 optional parameters.
Required:
- 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
KB442241
