KB487005: How to Create Table Aliases in Microstrategy Workstation

Introduction

To model an attribute with multiple roles, one must create separate attributes in the logical model for each role. This is achieved by establishing multiple logical table aliases that reference the same physical table, with each alias serving as the lookup table for its respective attribute role. 
Creating table aliases in Strategy Workstation is both quick and effortless, providing a user-friendly way to manage and reference complex tables.

Steps

1. Launch Strategy Workstation and connect to your environment.
2. Under the "Modeling" section click "Schemas".
3. Right-click the project which you wish to create table aliases for and select ""Edit Schema".
   

1. Right-click a table under the "Logical Table" column and select "Create New".
   

1. In the box that appears, type in your Table Alias name and click enter to save it.
2. Save and close the schema to save your changes.