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?

Question

Options

• ACreate a physical time table in your database.
• BCreate a Logical Table that is sourced from the time key in the fact table.
• CCreate an "Opaque View" in the physical layer that contains the time columns from the fact and map
• DCreate a Logical Table that is sourced from a time field in one of your dimension tables.
• ECreate a time table that is joined through a intervening Table so there is no foreign key relationship.

• A
  81% (21)
• B
  4% (1)
• C
  4% (1)
• E
  12% (3)

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

No community discussion yet for this question.