Specifying Attribute Boolean, Date, and Numeric Ranges

  To specify attribute Boolean, date, and numeric ranges for a member:

1. Access the Essbase Model Properties dialog box using the procedure in Accessing the Essbase Model Properties Dialog Box.

2. Select the Attributes tab.

3. Locate the Boolean, date, and numeric ranges group.

4. In the True members text box, enter an attribute member name.

   If the member name “True” is used elsewhere in the outline, enter Yes, Allowed or another appropriate name in the True Member Name text box. The default member name is True.

5. In the Dates are drop-down list, select the date format.

   • mm-dd-yyyy—For example, October 19, 2000 is displayed as 10-19-2000.

     Note:

     For date type attribute members, a default mm-dd-yyyy format is assigned unless you specify a different value.

   • dd-mm-yyyy—For example, October 19, 2000 is displayed as 19-10-2000.

     Note:

     If you change the date member name format, the names of existing members may become invalid. For example, if the 10-19-2000 member exists, and you change the format to dd-mm-yyyy, this member may become invalid.

6. In the False members text box, enter an attribute member name.

   If the member name False is used elsewhere in the outline, enter Yes, Allowed or another appropriate name in the False Member Name text box. The default member name is False.

7. In the Numerics are drop–down list, specify the numeric range:

   • Tops of ranges—Sets the names of numeric attributes to the value at the top of the numeric range. If the range is 3,000,001 to 6,000,000, selecting this option sets the name as 6,000,000.

   • Bottoms of ranges—Sets the name of numeric attributes to the value at the bottom of the numeric range. If the range is 3,000,000 to 5,999,999, selecting this option sets the name as 3,000,000.

8. Click Apply.