Limiting data in a cube data connection

When select data from a cube data source in the Data Selection in Connection dialog, can limit the data selection further on dimensions. Single sublevels in hierarchies can be selected or deselected. Limiting the dimension to view only the required data is of particular interest when you intend to import your cube data, since too large amounts of data cannot be imported from the cube. Some data sources may also have limits on the number of cells which you may import.

About this task

Note: If you are using SAP BW BEx queries, data has already been limited due to the selections in the BEx query, so further limiting is often unnecessary. Make sure that you do not filter out all data by selecting values that have already become invalid by the selection of BEx variables.

Procedure

In the Files and data flyout, click Connect to.
Select a cube data source (Microsoft SQL Server Analysis Services, SAP BW, or Oracle Essbase) and then click New connection. Provide the required information for the connection to the data source.
In the Data Selection in Connection dialog, click on the column or hierarchy to limit in the Data selection in connection list.
In the Settings pane, click Limit....
In the Limit Data dialog, clear the check boxes for those categories that you do not want to include in your selection.

Tip: You can also right-click in the dialog to display a pop-up menu where you can Select All Values or Deselect Other Values (clears the check boxes for all values except for the value you right-clicked on).
Click OK.