We have been handling the partial results of BusinessObjects Web Intelligence through different ways.
However, here I woud like to suggest one of the best practices we follow which helps the end-users be aware of
what is really happening with the users prompt selection.
We can display appropriate message to the users based on output of document and data provider functions.
For an instance, to start whether the document is partially refreshed can be checked through DocumentpartiallyRefreshed().
Example : DocumentPartiallyRefreshed() = 1
If the above condition is TRUE, then we can check whether the dataprovider returns more rows than the allowed limit using NumberOfRows().
By default, we set 5000 as rowlimit. However, it varies depends on the requirement and best practices.
Example : If NumberOfRows() > 5000 Then “Exceeded the allowed row limit”
Also, we can check whether the partial result occured due to bursting of the time limit using LastExecutionDuration(). By default, we set 60.
Example : If LastExecutionDuration() > 60 Then “Time Limit Exceeded”
If None of the above is TRUE, we can say “No Data Available for the provided prompt selection”
We can define variables for each function per dataprovider. Using this method, we will be able to communicate with user effectively and let
them know the cause of the Partial Result and action them appropriately.
Hope this blog helps to set the best practices for Web Intelligence documents. Please rate & comment.