One of the most powerful uses of dimensions is segmenting your drivers. For example, you might have an Amount driver segmented by both Account and Class, and another version rolled up by just Account.
Growth Rate - US
, Growth Rate - EMEA
, etc.—but that naming convention gets messy fast.
When you segment drivers without using dimensions, you have to create formulas for your totals that reference each driver individually.
sum(Growth Rate [All Regions])
stay maintained as new items get added to a dimension.Account Name
, Class
, and Vendor
.Class
.