In the left pane, click on the object of interest, and then click
Add >.
See
Icon Descriptions for information about what the different objects represent. If you select the cube icon, you will get all data in the cube. When it comes to hierarchies, you always have to add the entire hierarchy to the list, but you can limit the data further, see step 12.
The selected data is added to the
Data selection in connection list.
Dimension columns and hierarchies can be further limited by clicking on the selected column or hierarchy in the
Data selection in connection list and then, in the
Settings pane, clicking
Limit....
The
Limit Data dialog opens.
Clear the check boxes for categories that you want to remove from the selection.
Click
OK to close the
Limit Data dialog.
When you are done with the data selection, click
OK.
The connection is added to the
Data tables list in the
Add Data Tables dialog.
Make sure the data table, and not the connection, is selected in the
Data tables list and, under
Load method, click
Keep data external.
Click
OK in the
Add Data Tables dialog.
Result
The external data table is shown in the
Data panel.
Tip: Do all of the data selection work in a shared data connection and save it to the library instead of adding it to the analysis directly. This way you can reuse the work you have done later, or share your selections with others.