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 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

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
columns.
Reference: Oracle Fusion Middleware Metadata Repository Builder’s Guide for Oracle Business
Intelligence Enterprise Edition. Working with Logical Dimensions



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Leo Yu

Leo Yu

http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1221/rpd/rpd.html
creating time series measure
To create time series measures, you perform the following steps:
•Identifying a Logical Dimension as a Time Dimension
•Identifying Level Keys as Chronological Keys
•Creating a Measure Using the AGO/TODATE/PERIODROLLING Function

Suppose the aggregation content rule(what level of granularity dimension is stored in the fact table) has been setup within the source of logical table