Create the Logical Time Dimension in a Semantic Model

To enable the time series functions on the dimension, select the Time hierarchy type in the logical dimension table and then designate a chronological key for every level of each dimension hierarchy.

See About Creating Logical Time Dimensions in a Semantic Model and About Setting Chronological Keys in a Semantic Model.

  1. On your home page, click Navigator Navigator icon and then click Semantic Models.
  2. In the Semantic Models page, click a semantic model to open it.
  3. Click Logical layer Logical layer icon, double-click the logical table where you want to enable time series functions, and in the logical table's tabs click Hierarchy.
  4. Click the Hierarchy Type field and select Time.
  5. Click a hierarchy level and in its details click Chronological Key and choose a key.
  6. For each hierarchy level that you need to set a key for, go the level's details, click the Chronological Key, and choose a key.
  7. Click Save.