Excel Add-in : Avoiding Partial Results
On a couple occasions the users of the OneStream Add-in have unintentionally reported partial results from a onestream cube. This has happened when data extends beyond the allowable page size ("Maximum Number of Rows").
It can sometimes come up by surprise. For example, a user may pull in all the YTD activity from a cube and it will fit within the page size for much of the year but towards the end of the year some of the data will go missing. If the Onestream data is retrieved on one of several sheets, and the data is used indirectly for calculations that are displayed elsewhere in the workbook, then the problem can be easy to miss.
In fact, this type of a problem can even be overlooked when you are staring right at the add-in itself, since the only indication of a problem is way down at the bottom of the results. That is where you can see the "Page 1" annotation (see image below)
This brings me to my question. Is there any setting that will simply generate an error if/when the results are incomplete? Users often build their cubeviews in the assumption that all the data will be presented. Anything less than that should be handled as a critical failure. Sometimes it is better for all the data to be missing than to get partial results!
