Extracting data from Strategy reports with R requires the get_report () 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
- report_id - this is the ID of the report in Strategy and gets passed in as a string. The report ID can be obtained by right clicking the object in Strategy Web and selecting properties. Developer may also be used to get the report ID.
Optional:
- offset - this parameter is an integer that indicates which row of the report 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
KB442337
