Work Order Data Mart Build (WODM.1)
Use Work Order Data Mart Build (WODM.1) to define your data mart. Select the Dimensions tab to define the required and optional dimensions of your data mart. Select the Data Parameters tab to define data load options.
Process at a Glance
1. Load the preassigned data mart types.
2. Create an OLAP destination.
3. Define the data mart.
4. Define the dimensions for the data mart.
5. Define the information transfer profile.
6. Load the data mart.
Descriptions
Dimensions tab
Organization: Select a previously defined organization dimension or choose Define to create a new one.
Time: Select a previously defined time dimension or choose Define to create a new one.
Measure: Select a previously defined measure dimension or choose Define to create a new one.
Product: Select a previously defined product dimension or choose Define to create a new one.
Scenario: Select a previously defined scenario dimension or choose Define to create a new one.
Years: Select a previously defined year dimension or choose Define to create a new one.
Data Parameters tab
Data Load Opt: Select a data load option:
A (Load All Data). Select this option to load all data. Values that exist from previous updates will be overwritten.
P (Partial Load). Select this option to load only data values for a specific beginning and ending period. Existing values that exist outside the period will not be affected.
N (No data load). Select this option to verify your outline or star schema format before loading any data.
Beginning Period/Year: If you selected P (Partial Load) in the Data Load Opt field, type a beginning period and year.
Ending Period/Year: If you selected P (Partial Load) in the Data Load Opt field, type an ending period and year.