Home » Oracle » 1z0-591 » What two additional steps will need to be done to enable this in the repository?
A customer has a requirement for rolling period calculations. What two additional steps will need to be done to enable this in the repository?
A. Clicking the "Time" option in the Logical Dimension Dialog
B. Designating a chronological key for every level of every dimension hierarchy
C. Clicking the "Time" option in the Logical Table Source Dialog
D. Designating a chronological key for every logical column in the Logical Table Source
E. Specifying a sort order in the Logical Table dialog
Correct Answer: AB
Explanation/Reference:
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 columns.
Reference: Oracle Fusion Middleware Metadata Repository Builder’s Guide for Oracle Business Intelligence Enterprise Edition. Working with Logical Dimensions
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
