TIME DIMENSION Table - Data Element Index   Tables and Data Elements   Tuition Distribution Home   Data Warehouse Home

TIME DIMENSION Table

Explanation
All Time related data in the Tuition Distribution Collection.

Common Uses
Displaying the Extract Dates and Term data for the Tuition Distribution Collection

DATE_KEY



     

DATE_KEY

TD_DISTRIBUTION_FACT, 
TD_STUDENT_REGISTRATION_FACT,
TD_DEFERRED_INCOME_FACT,
TD_INSTRUCTOR_SECTION_FACT,
TD_INSTR_PROGRAM_TUITION_FACT,
TD_RESERVE_RATE_FACT

• When querying data from the Universe, you will always need to return the SRS_TERM and EXTRACT_DATE in order to see each distinct snapshot. If you don't follow this advice, you will get all snapshots aggregated to the fields that you return.
• The user will never see the joins between Time and the other Business Objects tables in this Universe. All joins are done behind the scenes.

Sources

• Data in the Business Objects TIME table are drawn from TD_TIME_DIMENSION.

TIME DIMENSION Table - Data Element Index   Tables and Data Elements   Tuition Distribution Home   Data Warehouse Home