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.
Createa time table that is joined through a intervening Table so there is no foreign
keyrelationship.
C.
Create a LogicalTable that is sourced from a time field in one of your dimension tables.
D.
Create aLogical Table that is sourced fromthe time keyin the fact table.
E.
Create an “Opaque View” in the physicallayer that contains the time columns from the
fact and map itinto your physical model.
C) should be refined to “create a logical table which is sourced from the time field of one physical dimension table”.
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