To create an alternative sort order, you must use an item class to link together two items:Īn item to define the list of values to be sorted But Discoverer end users might need sales regions sorted in a different order (for example, North, South, East, West). However, Discoverer end users might require some items to be sorted in a different order.įor example, by default, Discoverer sorts a series of sales regions alphabetically (for example, East, North, South, West). Alternative sorts enable you to specify a different sort order to the one that Discoverer uses by default.īy default, Discoverer sorts items in ascending or descending order using ASCII values. Note that an item class to support an alternative sort must also support a list of values.Īn alternative sort is an instruction to Discoverer about how to sort the values in an item. You can create a different item class for each feature or you can specify that Discoverer uses the same item class for more than one feature. Without the item class, you would have to define the properties individually for each item.ĭiscoverer uses item classes to implement the following features:Īs the Discoverer manager, it is your responsibility to create suitable item classes to support these Discoverer features. In other words, you only have to define the properties once. To enable both items to share common properties (for example, a list of values), you might create one item class to define the properties, and apply it to both items. A similar item also called Product Name may be required in the Sales Revenue folder. An item class enables you to define item properties once, and then assign the item class to other items that share similar properties.įor example, assume the Product folder includes an item called Product Name that describes each product. Item classes are groups of items that share some similar properties. "Notes about items based on columns with user-defined datatypes" "How to assign an indexed item to an item" "About improving performance when end users select parameter values in worksheets" "How to view the list of values for an item class"
"How to view the list of values for an item" "How to view the items that use an item class" "How to create a list of values using a custom folder" "How to create a drill to detail item class" "How to create an alternative sort item class" "About generating and updating EUL item names automatically" "About drilling out to other applications"
"About applying conditions to truncated date items" "About truncating date items and the EUL_DATE_TRUNC function"
"Examples of different ways to implement alternative sorts" This chapter explains how to maintain items and item classes using Discoverer Administrator, and contains the following topics: