After you build the numeric attribute dimension ranges, you need a rules file to associate the members of the base dimension with their attributes. The source data includes fields for the members of the base dimension and fields for the data values that Essbase uses to associate the appropriate Population attribute.
Define the rules file as shown in Figure 88, Rules File for Associating Numeric Range Attributes.
When you define the association field (for example, Population3, Market), place the attribute members within a range. In Data Prep Editor, on the Dimension Build Properties tab of the Field Properties dialog box, select “Place attribute members within a numeric range.”
Figure 88, Rules File for Associating Numeric Range Attributes includes a city, Boston, whose population of 3,227,707 is outside the ranges of the attribute dimension in Figure 86, Numeric Attribute Dimension with Different-Sized Ranges, where the ranges extend only to 3,000,000. To allow for values in the source data that are outside the ranges in the attribute dimension, enter a range size, such as 1000000. Essbase uses the range size to add members to the attribute dimension above the existing highest member or below the existing lowest member, as needed. |