Members of numeric attribute dimensions can represent single numeric values or ranges of values. Consider using ranges of values when you want data to be accumulated and retrieved based on ranges of values rather than on individual values. For example, to enable a view of sales values in various states grouped into population categories, you can define an attribute to represent populations between 1 and 100,000. Another attribute can represent populations between 100,001 and 1,000,000.
For each numeric attribute dimension that uses ranges, you must define whether the attribute dimension member name represents the bottom of the range or the top of the range.
To define a rule for assigning, in numeric attribute dimensions, names to members representing ranges of values:
Open the outline in edit mode and select the Properties tab.
In the Boolean, date, and numeric attribute settings option group, select the Numeric ranges represent option that sets whether numeric attribute values define the tops or bottoms of the ranges that they represent.
Click OK.
“Setting Up Member Names Representing Ranges of Values” in the Oracle Essbase Database Administrator's Guide