MicroStrategy ONE

Organizing project tables: Layers

You can improve the organization and clarity of your project in Architect by creating groups of tables that can be easily accessed and focused on. These groups of tables are referred to as layers, and they can help organize MicroStrategy projects that require a large number of tables.

In the Project Tables View of Architect, you can select one or more tables and define the group of tables as a layer. This layer can be accessed from the Layers drop-down list to focus on only the tables included in the layer. Any modifications performed while viewing a layer are applied to the project as a whole.

For example, you can select all of the fact tables in your project and create a new layer named Fact Tables. This allows you to quickly focus on only the fact tables included in your project.

The All Project Tables layer is a default layer that includes all tables included in a project. This layer cannot be deleted.

The procedure below describes how to create a layer in Architect.

To create a layer in Architect

  1. In MicroStrategy Developer, log in to a project.
  2. From the Schema menu, select Architect.
  3. If a message is displayed asking if you want to open Architect in read only mode or edit mode, select Edit and click OK to open Architect in edit mode so that you can make changes to the project. MicroStrategy Architect opens.

If you are only given the option of opening Architect in read only mode, this means another user is modifying the project's schema. You cannot open Architect in edit mode until the other user is finished with their changes and the schema is unlocked.

For information on how you can use read only mode and edit mode for various schema editors, see Using read only or edit mode for schema editors.

  1. From the Project Tables View, select all the tables to include in a layer.

    To remove a table from a layer, right-click the table, and select Remove From Layer.

  1. From the Home tab, in the Layer area click the Create New Layer option. A dialog box to name the layer opens.
  2. In the Please enter the layer name field, type a name for the layer and click OK. You are returned to Architect and the new layer is displayed in the Project Tables View.
  3. Use the Layers drop-down list to switch between layers.