Dimension Editor

Dimension Editor - Browse

Enables you to examine and edit a dimension and its levels. It appears in two views, Browse and Schema. You can switch from one view to another by clicking the Preview Dimension Data button or the View Source Tables button. You can also click Data or Schema on the View menu.

The Dimension editor appears when you do either of the following:

In the OLAP Manager, in the Library folder, open the Shared Dimensions folder. Right-click a dimension, and then click Edit.
In the OLAP Manager, in the Library folder, open the Shared Dimensions folder. Click a dimension, and then on the Action menu, click Edit.

The Dimension browser is identical to the Browse pane in the Dimension editor. It appears when you do the following:

In the OLAP Manager, in the Library folder, open the Shared Dimensions folder. Right-click a dimension, and then click Browse Dimension Data.

In this topic, you can read about:

The Browse pane.
The Dimension editor menus.
The Dimension editor toolbar.
The tree view.
The Properties pane.
Working in the Dimension editor.

Browse Pane

The Dimension editor Browse pane displays the dimension in a graphical format, allowing you to easily view multilevel dimension hierarchies. The Browse pane is divided vertically into two panes. The left pane displays the dimension members in a tree format. Expand or collapse individual levels to browse them.

The right pane contains a list of the member properties of the member selected in the left pane. The list of member properties contains all user-defined member properties for the selected member.

Each member property has its name shown in the first column of the list and its value in the second column of the list. The member properties are sorted in the same order as in the tree view.

Dimension Editor Menus

Menu	Option	Description
File	New Dimension - Wizard	Creates a new dimension using the Dimension wizard.
	New Dimension - Editor	Creates a new dimension using the Dimension editor.
	Save	Saves the dimension.
	Save As	Saves the dimension under a different file name.
	Exit	Closes the Dimension editor.
Edit	Rename	Renames the selected object.
	Delete	Deletes the selected object.
	Remove Join	Removes all joins from selected column (Schema pane only).
View	Schema	Displays the Schema pane.
	Data	Displays the Browse pane.
	Properties	Expands the Properties pane.
Insert	Tables	Adds a table to the dimension.
	Level	Adds a new level.
	Member Property	Adds a new member property.
	Join	Adds a join to selected column (Schema pane only).
Tools	Process Dimension	Processes the dimension.
	Count Dimension Members	Counts the number of members in a dimension.
	Validate Dimension Structure	Verifies that the dimension structure doesn't contain invalid components that would prevent processing of the dimension.
Help	Help on Dimension Editor	Displays this Help topic.
	Contents and Index	Opens Microsoft® SQL Server™ OLAP Services Books Online.

Toolbar

Tree View

The tree view previews the structure of your dimension in a hierarchical tree. In the tree view, right-click an object to see a shortcut menu for that object.

Right-click	Shortcut menu option	Description
Dimension name	New Dimension	Adds a new dimension.
	Process Dimension	Processes the dimension.
	New Level	Adds a new level.
Level	New Level	Adds a new level.
	New Member Property	Adds a new member property.
	Delete	Deletes the level.
	Rename	Renames the level.
Member Property Folder	New Member Property	Adds a new member property.
Member Property	New Member Property	Adds a new member property.
	Delete	Deletes the member property.
	Rename	Renames the member property.

Properties Pane

The Properties pane displays the properties of a selected object in the tree view. Each type of object (dimension, level, or member property) contains a different set of properties. Use the Properties pane to modify the property settings for the selected object.

To expand the Properties pane for an object in the tree view

Select the object, and then click the arrow on the Properties pane.
-Or-
On the View menu, click Properties. The Properties pane displays the properties for the object.

Note The MemberKeyColumn property for a dimension level can refer to a column or to a value derived from a column, such as a formula that extracts the year value from a date-formatted column. However, the column or the value derived from the column must be a string or a number.

For more information about properties, see Properties Cross-Reference.

Working in the Dimension Editor

This section lists the actions that can be performed in the Dimension editor. Many actions can be performed in multiple ways. For example, an action can be accomplished either by clicking a menu item, by clicking a button on the toolbar, or by right-clicking an object and then clicking an item on the shortcut menu.

To view a different dimension

Click the down arrow on the Dimension list on the toolbar, and then click a dimension.

To create a new dimension using the Dimension wizard

On the File menu, point to New Dimension, and then click Wizard.
-Or-
Click the New Dimension button on the toolbar.

To create a new dimension using the Dimension editor

On the File menu, point to New Dimension, and then click Editor.
-Or-
On the Dimension list on the toolbar, click New.
-Or-
In the tree view, right-click a dimension, and then click New Dimension.

To save the current dimension

On the File menu, click Save.
-Or-
Click the Save button on the toolbar.

To save the current dimension under a different name

On the File menu, click Save As.
In the New Dimension Name dialog box, enter a name in the Dimension Name box, and then click OK.

To add a table

On the Insert menu, click Tables.
-Or-
Click the Insert Table button on the toolbar.

Note Adding a table automatically switches you to the Schema pane.

To add a level

On the Insert menu, click Level.
-Or-
Click the Insert Level button on the toolbar.
-Or-
In the tree view, right-click a dimension, and then click New Level.
-Or-
In the tree view, right-click a level, and then click New Level.

To delete a level

In the tree view, click a level, and then on the Edit menu, click Delete.
-Or-
In the tree view, right-click a level, and then click Delete.

To rename a level

In the tree view, click a level, and then on the Edit menu, click Rename.
-Or-
In the tree view, right-click a level, and then click Rename.

To add a member property

On the Insert menu, click Member Property.
-Or-
In the tree view, click a level, member property folder, or member property, and then click the Insert Member Property button on the toolbar.
-Or-
In the tree view, right-click a level, member property folder, or member property, and then click New Member Property.

To delete a member property

In the tree view, click a member property, and then on the Edit menu, click Delete.
-Or-
In the tree view, right-click a member property, and then click Delete.

To rename a member property

In the tree view, click a member property, and then on the Edit menu, click Rename.
-Or-
In the tree view, right-click a member property, and then click Rename.

To process a dimension

On the Tools menu, click Process Dimension.
-Or-
In the tree view, right-click a dimension, and then click Process Dimension.

To count dimension members

On the Tools menu, click Count Dimension Members.

To validate a dimension structure

On the Tools menu, click Validate Dimension Structure.

To view the Schema pane

On the View menu, click Schema.
-Or-
On the lower toolbar, click the View Source Tables button.

To expand the Properties pane

On the View menu, click Properties.
-Or-
Click the down arrow on the Properties pane.

To edit the properties of an object

In the Properties pane, place the pointer in a cell and then type in the new value, or select a value from the list, if a list is presented.

To close the Dimension editor

On the File menu, click Exit.