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.