Add Data dialog

This dialog appears when you do either of the following:

• In the Query Editor, click the Add Table button on the toolbar or select Add Table from the Query menu.
• In the Catalog Browser, right-click the Business Cubes node and select Add Business Cube from the shortcut menu. Then in the Input Business Cube Name dialog provide a name and click OK.

It helps you to add resources to use in a query or a business cube. See the dialog.

All Data

List all the tables, views, queries, imported SQLs, stored procedures, and user defined data sources in the current data source that can be added to the query or business cube.

When two resources (for example, a table and a view) use the same name, they cannot be added at the same time, and when a table is already contained in a query, you cannot add the table and the query at the same time.

Selected data

Lists all the added resources.

Adds the selected resources from the left box to the right box.

Removes the selected resources from the right box.

OK

Adds the selected resources to the current query or business cube. When a query, imported SQL, stored procedure or user defined data source is added, it will be added as a single table with all of its columns.

Cancel

Exits the dialog and discards the setting.

Help

Displays the help document of this feature.

Related topics:

• Adding and deleting tables in a query