You do not have a physical time table in your database but would like to use the time series
functions that OBIEE offers. What two options do you have?
A.
Create a physical time table in your database.
B.
Create a Logical Table that is sourced from the time key in the fact table.
C.
Create an “Opaque View” in the physical layer that contains the time columns from the fact and
map it into your physical model.
D.
Create a Logical Table that is sourced from a time field in one of your dimension tables.
E.
Create a time table that is joined through a intervening Table so there is no foreign key
relationship.
Explanation:
Modeling Time Series Function in OBIEE
Modeling Time Series Data
Time series functions provide the ability to compare business performance with previous time
periods, allowing you to analyze data that spans multiple time periods. For example, time series
functions enable comparisons between current sales and sales a year ago, a month ago, and so
on.
Because SQL does not provide a direct way to make time comparisons, you must model time
series data in the Oracle BI repository. First, set up time dimensions based on the period table in
your data warehouse. Then, you can define measures that take advantage of this time dimension
to use the AGO, TODATE, and PERIODROLLING functions.
b & c
D is wrong. C is correct.
so A and C, I think.
An opaque view is in the physical layer a physical table that consists of a Select statement .
In the repository, opaque views appear as tables in the physical layer but the view does not actually exist.
Thanks Pedro, I agree, “opaque view” and “logical table” are the correct answers.
So what is the answer?
B) D) are incorrect: logical table source cannot be another logical table, logical table source can only be one physical layer table, the physical layer can be one opaque table which is populated from one select, store procedure
Sorry D) is correct, create a logical table which is derived from the time column of another (physical) dimension table, not (physical) fact table.
C and D
Ans: A, C
Modeling Time Series Function in OBIEE
Modeling Time Series Data
Time series functions provide the ability to compare business performance with previous time
periods, allowing you to analyze data that spans multiple time periods. For example, time series
functions enable comparisons between current sales and sales a year ago, a month ago, and so
on.
Because SQL does not provide a direct way to make time comparisons, you must model time
series data in the Oracle BI repository. First, set up time dimensions based on the period table in
your data warehouse. Then, you can define measures that take advantage of this time dimension
to use the AGO, TODATE, and PERIODROLLING functions.