A customer has a requirement for rolling period calculations. What two additional steps will need to be done to enable this in the repository?

Question

Options

• AClicking the "Time" option in the Logical Dimension Dialog
• BDesignating a chronological key for every level of every dimension hierarchy
• CClicking the "Time" option in the Logical Table Source Dialog
• DDesignating a chronological key for every logical column in the Logical Table Source
• ESpecifying a sort order in the Logical Table dialog

• A
  83% (19)
• C
  9% (2)
• D
  4% (1)
• E
  4% (1)

Explanation

Creating Logical Time Dimensions Compared to modeling an ordinary dimension, the time dimension requires just two additional steps: selecting the Time option in the Logical Dimension dialog, and designating a chronological key for every level of every dimension hierarchy. Note: Time dimensions and chronological keys. You can identify a dimension as a time dimension. At least one level of a time dimension must have a chronological key. The following is a list of some guidelines you should use when setting up and using time dimensions: * At least one level of a time dimension must have a chronological key. * All time series measures using the AGO, TODATE, and PERIODROLLING functions must be on time levels. AGO, TODATE, and PERIODROLLING aggregates are created as derived logical Intelligence Enterprise Edition. Working with Logical Dimensions

No community discussion yet for this question.