SSAS: Refining a Dimension

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.

1-SSAS-Refining-a-Dimension

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.

2-SSAS-Refining-a-Dimension

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.

3-SSAS-Refining-a-Dimension

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.

4-SSAS-Refining-a-Dimension

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

5-SSAS-Refining-a-Dimension

Now I will open the Geography dimension.

6-SSAS-Refining-a-Dimension

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

7-SSAS-Refining-a-Dimension

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s