Adding units

You can add new units to the Unit dimension.

When loading data into the Organization Unit dimension for the first time, you can use any IDs you like as long as the top unit is the smallest number for all IDs. You must use 0 for top unit. You can then use 1, 2… for rest of the members.

Before you can add members to the Unit dimension, you must set the AttributeHierarchyVisible property to True. This property is set through the Unit - Key attribute of the Unit dimension. After making this change, you must exit the application. Or, you can add the members directly to the relational table.

To add units:

  1. On the Analysis Services computer, from the Business Intelligence Development Studio (BIDS), open the Analysis Services database.
  2. Open the Unit dimension in the Browser tab.
  3. Enable writeback.
  4. Go to where you want to add a unit.
  5. Create a sibling or a child. You must specify a unique key for the new unit.
  6. Process the cube.
  7. Exit the application.

Once you have added the members, change the value of the AttributeHierarchyVisible property back to False.

In SQL Server Management Studio, you can delete units by deleting the rows in the table. You must process the dimension and the database after deleting units.