Details on Limit Data

When specifying what data to work with in the Data Selection in Connection dialog, you also have the possibility to limit further on dimensions. This dialog will look different depending on what you have selected to limit. Hierarchies can be expanded using the plus sign, so that single sublevels 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.

Note: If you are connecting to an SAP BW BEx query with variables, avoid limiting characteristics in the Limit Data dialog. Data has already been limited by the selections in the BEx variables, so, generally, further limiting is not necessary. Because of restrictions in SAP BW, if you both limit a characteristic and define a BEx variable that filters out values for that characteristic, you might get unpredictable results when loading and analyzing data.

To reach the Limit Data dialog:

1. Select to add a data connection from a cube data source, such as Microsoft SQL Server Analysis Services.

2. In the Data Selection in Connection dialog, click on the column or hierarchy to filter in the Data selection in connection list.

3. In the Settings pane click Limit....

Clear the check boxes for items that are not of interest, in order to limit the data selection further. You can use the arrow keys on the keyboard to navigate in the dialog. Use the space bar on the keyboard to select or clear a check box.

You can also right-click in the dialog to display a pop-up menu with the following content: