Reviewing the Dimensional Structure

Before loading data, ensure that you defined child members for the following dimensions and parent members. If you modified the dimensional outline, synchronize Smart Lists with dimension members and refresh the database before using the Outline Load Utility.

Note:

You need not define the child members displayed below. These members are used in the sample load files, and are not required.

Table 25. Required Dimensionality and Sample Children

DimensionParent MemberSample Child Members and Smart List Entries
Scenario Forecast and Current.

Note:

Select BegBalance

Version Stage 1
Stage 2
PositionTotal Existing Positions

  • Mrk_4

  • Admin_12

  • Fac_Mngr

  • survey_2

  • education_hs_snr

  • prk_sec_pa

  • Fire_1

  • Instructor

EmployeeExisting Employees

  • Fergusson, Deborah

  • Day, John

  • Daniels, Mark

  • MacKay, Derek

  • Wu, Jonathan

EntityTotal Entity

  • tourism

  • dept_tourism

  • Parks and Recreation

  • Department of Conservation

  • Yorkville_Lib

ElementCompensation elements:

  • Benefits

  • Salary grades

  • Employer-paid taxes

  • Additional earnings

  • Benefits:

    • Benefit 5

    • benefit_1

    • Dental

  • Salary Grades

    • Grade 1

    • Grade 2

  • Employer-paid taxes:

    • Medicare

    • SUTA

Account

  • Personnel Expenses

  • General Ledger accounts

  • Personnel Expenses

    • A100

    • A120

  • General Ledger accounts

    • 600

    • 601

JobTotal Job Class

  • entry Faclty_Cor

  • job_56