Create offline cube file

Improve this question. Community Bot 1 1 1 silver badge. Mike M Mike M 1 1 gold badge 11 11 silver badges 17 17 bronze badges. Add a comment. Active Oldest Votes. Improve this answer. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password.

Post as a guest Name. Email Required, but never shown. It is not always necessary to be connected with OLAP cube to create reports in excel. There can be situations when you need to analyze the data when you are not connected to your network or you are out of office. In those cases you can create an offline cube file with. You need to click next to go to next step. The following procedure provides the basic steps for taking data offline and then bringing the data back online.

Create an offline cube file on your computer. Reconnect to your network and reconnect the offiline cube file. Refresh the offline cube file with new data and then recreate the offline cube file. See the section Refresh and recreate an offline cube file below, in this article.

Note: If your OLAP database is large and you want the cube file to provide access to a large subset of the data, you will need to provide ample disk space, and you will find that saving the file may prove to be time consuming. To improve performance, consider creating the offline cube file by using an MDX script. Click the PivotTable report for which you want to create an offline cube file — you can also click the associated PivotTable report for a PivotChart report.

Contact the vendor for your OLAP provider for more information. Click Create offline data file or, if an offline cube file already exists for the report, click Edit offline data file. In step 2 of the wizard, select each dimension from your server cube that has data that you want to include in the offline cube file.

Click the box next to each such dimension, and select the levels that you want to include. To reduce the size of the cube file, omit lower levels that you don't need to view in the report. Be sure to include any dimensions where you have grouped items, so that Microsoft Office Excel can maintain these groupings when you switch between the server database and the offline file.

Dimensions that do not have a box don't allow you to exclude levels. You can only include or exclude all of this type of dimension. In step 3 of the wizard, click the box next to Measures , and select the fields that you want to use as data fields in the report.

You must select at least one measure; otherwise the dimensions associated with the measure will contain no data. For each dimension listed under Measures , click the box next to the dimension, and then select the top-level items to include in the offline cube file. To limit the size of the cube file so that you don't run out of disk space and to reduce the amount of time required to save the file, select only the items that you need to view in the report. Any property fields that are available for the items that you select are automatically included in the cube.

If items that you want to include are missing, you may not have included the dimension that contains them in the previous step. Click Back in the wizard and select the missing dimension in step 2, and then return to step 3. Requirement is for the customer to view data offline and once he is online to synchronize the data from the SSAS server.

Yohan, you can switch between offline and online modes from the same wizard Fig 6 in the post but this has to be done manually. I am not aware of code that can do this automatically. Masson, I am not aware of any difference in cube browsing between online and offline browsing modes. It also produces a. You are commenting using your WordPress. You are commenting using your Google account. You are commenting using your Twitter account. You are commenting using your Facebook account.