Your current block storage option design includes two dimensions: Markets and Regions.
The Market dimension looks like:
Users need to be able to report by both regions and markets. Subtotals for Northeast and
Southwest will display on some reports.
A.
Add another level to the market dimension for Northeast with North and East as children
andSouthwest with West and South as children
B.
Add analternate hierarchy to the market dimension with the states as shared members,
rolling upto Northeast and Southwest
C.
Create a UDA with members Northeast and Southwest (associated to states in the Market
dimension)
D.
Create an attribute dimensionwith members Northeast and Southwest (associated to
states inthe Market dimension)
E.
Create a Text list with the values containing the members Northeast and Southwest.