Adding New Dimension Fields

Often in the cycle of cube development it become necessary to add new fields to a dimension for future reporting purposes.

In this article, I will demonstrate adding an aggregation of [City, State] to the data source view.

First, I’ll open the AW data source view.

Now I need to find a table. The most efficient method is to right-click a blank space within the designer and use Find Table.

After selecting the Geography table, it automatically move’s the screen focus to that table.
Next, I’ll r-click to add a New Named Calculation.

I will created an aggregation of the City and State Fields.
Note: The column names used must match those in the table. For assistance you may also select to Explore Data.

When I’m finished, the new City + State calculation appears in the Geography table.

Now I will open the Geography dimension.

I’ll drag my City + State calculation from the Data Source View to the left into the Geography dimension attributes.