The SAS Visual Analytics Apps (formerly SAS Mobile BI) enable you to view reports without a connection to the server. However, there are special considerations and requirements for designing reports that can be successfully viewed in offline mode. If the SAS Visual Analytics App cannot open a report in offline mode, you see an error that is similar to this one:

Connection Failed. The data interaction between report objects failed.  
The server was unavailable for the data query.  Verify your network connection. 

This SAS KB article provides tips to determine whether a particular object has exceeded the maximum cell limit (250,000) for a single data query.

Note: For a more comprehensive list of requirements for offline mode, see SAS Mobile BI and Offline Mode.

1. Check the transport services log. The SASVisualAnalyticsTransport.log is typically located on the web application server in a location similar to /SAS-configuration-directory/Lev1/Web/Logs/SASServerX_X/. By default, debug logging is not turned on. However, the log should still display a note if the cell limit has been reached. Here is an example of what you might see:
   
   com.sas.onebi.transportservices.utils.DataUtils - Data Limits Exceeded - 
   skipping data processing and will retry for minimal
   
   
2. Determine how many cells your report object is using. Because any object in a report could exceed the maximum cell limit, you need to focus on which objects do not load in offline mode. The general formula is to calculate the distinct count of all of the categories that are used in the object combined with the categories that are used in filters that are applied to the object. You can get that distinct count by concatenating all of the categories together. You then multiply that distinct count by the total number of data items (categories and measures) used in the object and in the filters that are applied to the object. The following example illustrates this process.
    

Suppose that you need to know the cell count for the list table on the left. The table has three filters and an interaction with the pie chart.

There are six categories contributing to the list table. Three categories are from the drop-down list controls (Region, Product, Plant). One category is from the pie chart interaction (Weekday). Two categories are displayed in the list table (State, Product Grade).

Here are the steps to calculate the total number of cells used in the list table:

1. Create a data item that concatenates all of the categories.
   
   
   
   
2. Right-click the Combine data item and select Create Distinct Count.
   
   
   
   
3. Multiply the distinct count by the total number of data items (six categories plus one measure).

The total number of cells used in the list table is 27,146. You can use the results of this calculation to determine how much to increase the limit.