SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2012
Product Documentation
Books Online for SQL Server 2012
Analysis Services
Technical Reference
User Interface Reference
Analysis Services Designers and Dialog Boxes (Multidimensional)
Add Cube Dimension Dialog Box
Add Reference Dialog Box
Add Table Dialog Box
Add/Remove Tables Dialog Box
Analysis Server Properties Dialog Box
Assembly Properties Dialog Box
Assign Aggregation Design Dialog Box
Attribute Data Translation Dialog Box
Backup Database Dialog Box
Browse Data Source Dialog Box
Browse Data Source View Dialog Box
Browse for Remote Folder Dialog Box
Calculated Member Builder Dialog Box
Calculation Properties Dialog Box
Change Settings Dialog Box
Connect To Database Dialog Box
Create Attribute Relationship and Edit Attribute Relationship Dialog Boxes
Create/Edit Named Calculation Dialog Box
Create/Edit Named Query Dialog Box
Create/Edit Relationship Dialog Box
Create Polling Query Dialog Box
Create Processing Query Dialog Box
Cube Designer
Cube or Model Properties Dialog Box
Data Exploration Options Dialog Box
Data Sample Viewer Dialog Box
Data Source View Designer
Data Source View Properties Dialog Box
Database Designer
Database Properties Dialog Box
Define Relationship Dialog Box
Dimension Designer
Dimension Properties Dialog Box
Dismiss Warning Dialog Box
Duplicate Role Dialog Box
Enable/Disable Writeback Dialog Box
Filter Members Dialog Box
Find Table Dialog Box
Generate Named Query Dialog Box
Impact Analysis Dialog Box
Incremental Update Dialog Box
Key Columns Dialog Box
Level Naming Template Dialog Box
Locate Database Files Dialog Box
MDX Builder Dialog Box
MDX Query Editor
Measure Group Bindings Dialog Box
Merge Partition Dialog Box
New Database Dialog Box
New Measure Dialog Box
New Measure Group Dialog Box (Cube Designer)
Object Binding Dialog Box
Partition Properties Dialog Box
Partition Source Dialog Box
Process Dialog Box
Process Progress Dialog Box
Refresh Data Source View Dialog Box
Register Database Assembly Dialog Box
Relational Objects Dialog Box
Remote Partitions - Advanced Settings Dialog Box
Rename Instance Dialog Box
Replace Table with Other Table Dialog Box
Restore Database Dialog Box
Role Designer
Save File As Dialog Box
Security Context Dialog Box
Select Language Dialog Box
Select Parent Member Dialog Box
Show Table Dialog Box
Storage Options Dialog Box
Storage Settings Dialog Box
User Selection Dialog Box
View Details Dialog Box
XMLA Query Editor
Expand Minimize
This topic has not yet been rated - Rate this topic

Show Table Dialog Box (Analysis Services - Multidimensional Data)

SQL Server 2012

Use the Show Table dialog box in SQL Server Data Tools (SSDT) to include tables from the data source view associated with a dimension, cube, or mining structure. You can display this dialog box in SQL Server Data Tools (SSDT) by:

  • Clicking Show Tables from the Toolbar pane on the Dimension Structure page of Dimension Designer.

  • Right-clicking the background of the Data Source View pane on the Dimension Structure page of Dimension Designer and selecting Show Tables.

  • Clicking Show Tables from the Toolbar pane on the Cube Structure page of Cube Designer.

  • Right-clicking the background of the Data Source View pane on the Cube Structure page of Cube Designer and selecting Show Tables.

  • Right-clicking the background of the Data Source View pane on the Mining Structure page of Data Mining Model Designer and selecting Show Tables.

Select additional tables to be shown

Select the tables to add to the Data Source View pane. This option displays a grid of available objects and their types that match the filter set in Filter (or all tables if Filter is not set) and have not yet been shown in the current diagram.

Filter

Type the filter used to restrict the objects listed, and then click the button to filter the tables listed in Select additional tables to be shown.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.