Changing the Sort Order of Subject Areas and Subject Area Folders

Subject area folders are displayed in the Subject Areas pane in the sort order specified in the "My Account dialog: Preferences tab" by default. This sort order, established in the Oracle BI metadata repository and initially set by the administrator, can be changed by modifying the Subject Area Sort Order option in the "My Account dialog: Preferences tab." See "Changing the Sort Order of Subject Areas and Subject Area Folders" for additional information.

To change the sort order for subject areas, subject area folders, and the columns within the subject area folders for all analyses, perform the following steps:

1. In the global header, click Signed In As username and select My Account.

   The "My Account dialog: Preferences tab" is displayed.

2. Click the Subject Area Sort Order list, and then make the appropriate selection. Your options follow:

   • Sort A to Z (ascending)

   • Sort Z to A (descending)

   • Sort in Saved Order (The subject areas sort order specified in an analysis is saved as the default and subsequently used as the default sort order.)

   • Default - Sort in Saved Order (The subject areas sort order is originally defined in the repository.)

     
     

     Note: The primary subject area specified when creating the analysis is always fixed at the top; that is, it will always display as the first subject area in the "Subject Areas pane." For example (see Figure 2-10), if you have three subject areas (A - Sample Sales, B - Sample Quotas, and C - Sample Headcount) participating in the analysis with C - Sample Headcount as the primary subject area, and the sort order is ascending, then the subject areas display as follows: C - Sample Headcount A - Sample Sales B - Sample Quotas

     
     

     Figure 2-10 Example of Three Subject Areas Sorted in Ascending Order with C - Sample Headcount as the Primary Subject Area

     
     

3. Click OK to save your changes.

To change the sort order for subject area folders and objects within each folder for the current analysis that you are creating or modifying, perform the following steps:

1. In the "Subject Areas pane," add the appropriate subject areas.

2. Click the Sort Subject Area button, and then select one of the following sort orders from the drop-down list

   • Sort A to Z

   • Sort Z to A

   • Sort in Saved Order

   There is a fixed sort order for column types. This fixed sort order is:

   • Nested folders

   • Measures

   • Attributes

   • Hierarchies

3. Complete your analysis.