Modifying Smart List Dimension Properties

Use the Property Grid to set Smart List properties.

  To set Smart List properties:

  1. Select a Smart List dimension.

  2. Select the category, Planning. Define the Smart List properties for the dimension:

    Table 12. Smart List Dimension Properties

    Property

    Description

    Label

    Enter the text to display when the Smart List is selected. Smart Lists and Smart List members must have a Label assigned. Spaces and special characters are allowed. Smart List labels can reference a resource, which can be translated into different languages. See the Oracle Hyperion Planning Administrator's Guide.

    Auto Generate ID

    Generate a numeric ID for each Smart List entry. If you do not select this option, you can customize Smart List ID values.
    Start Value

    Populates the Value property of the first member in the Smart List. For example, if the Smart List dimension is Justification with Start Value set to 10, the first member added to this list has a value of 10.
    Increment

    This value is appended to the value of the last member in the list to determine the value for the selected member. For example:

    Justification (Start Value=0, Increment=10)

    Research (Value=0)

    Customer Feedback (Value=10)

    Survey (Value=20)

    Display Order

    How Smart Lists are sorted in the drop-down list: by ID, Name, or Label

    • ID—Unique number that sets the order for the displayed entry.

    • Name—Unique alphanumeric name containing alphanumeric and underscore characters (for example: Customer_Feedback) and no special characters or spaces

    • Label—Displayed text for the Smart List entry on the drop-down list (for example: Customer Feedback).

    #Missing Data Form Label

    Determines how #Missing values are represented in cells associated with Smart Lists. Options:

    • DropDown—Displays the label set in #Missing Drop-Down Label.

    • Grid—Displays #Missing or leaves cells blank, depending on the Display Missing Values As Blank selection for the data form (see the Oracle Hyperion Planning Administrator's Guide).

      This selection determines what is displayed in the cell when it is not the focus. When the cell is in focus, the Smart List item that is selected from the drop-down is displayed.

    #Missing Drop Down Label

    Enter a label (for example, No Justification) to be displayed as an entry in the Smart List whose value is #Missing. Notes:

    • This displays as the first selection in the Smart List drop-down, allowing #Missing as a selection in the data form.

    • When the cell is not in focus, this label displays only if the drop-down list is selected. Otherwise, #Missing or a blank cell is displayed, depending on the Display Missing Values As Blank selection for the data form.

    • #Missing labels determine only the display of cells with #Missing data; #Missing remains the stored value.