Select and Sort Chronological Keys in a Time Dimension

At least one level of a time dimension must have a chronological key. You can select one or more chronological keys for any level and then sort keys in the level, but Oracle Analytics uses only the first chronological key.

Pay attention to the column order in a chronological key with many columns. You set the column order using a SQL ORDER BY clause on the columns to reflect the real-world chronological order in the Chronological Key field. Since the range for quarters is 1 to 4 with 4 quarters in a year, using an ORDER BY clause with the Quarter before the Year (Quarter, Year) is incorrect. The incorrect order shows all first quarters across all years, before displaying any second quarters, and so on. To correct the results, use (Year, Quarter) in the ORDER BY clause.

For information about creating a time dimension, see Manually Create Dimensions in Level-Based Hierarchies.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Logical layer and locate and double-click the logical table with the chronological key you want to select.
4. Click Hierarchies and then click a logical level below the Grand Total level.
5. Click the Chronological Key field and select a chronological key.
6. Click Save.