Hi,
I have tried to create a simple Olap report and it works fine if I use a star schema. However, when it starts to look like a snowflake schema it does not work. I am using WebFocus 7.6.6 on AIX 5.1, JDK 1.4.2, Apache 5.0.19 The reason we are using Apache 5.0.19 instead of Apache 5.5.25 is because our AIX version cannot support a JDK version higher than 1.4.2
I edited the master files in Synonym Editor and created a separate master file and called it image_analysis.mas
The dimensions were added in the dimension builder so that's why the other master files also appear in the image_analysis master that I created for our report.
Can someone tell me if WebFocus Olap reports will work only with a star schema or it can work with a snowflake schema?
Here are the original access and master files and the access and master that I created as well as the Olap code.

For e.g. I want to join the PCT_CASE_FACT table to the PCT_REQUEST_FACT table by REQUEST_ID and then join the PCT_REQUEST_FACT table to the CARD_TYPE_DIM dimension table by CARD_TYPE_ID. Then I will join the CALENDAR_DIM table to the PCT_CASE_FACT table by the ID_COMPLETE_ID. Then I want to get the CASE_GENERATED_QUANTITY from the PCT_CASE_FACT table to show up as a measure on the olap report. Can this be done?

SEGNAME=PCT_CASE_FACT, TABLENAME=PROTOTYPE_READ.PCT_CASE_FACT,
CONNECTION=INTD, KEYS=1, $

FILENAME=PCT_CASE_FACT, SUFFIX=SQLORA , $
SEGMENT=PCT_CASE_FACT, SEGTYPE=S0, $
FIELDNAME=ID, ALIAS=ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=CASE_ID, ALIAS=CASE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=REQUEST_ID, ALIAS=REQUEST_ID, USAGE=A100, ACTUAL=A100, $
FIELDNAME=REQUEST_TYPE_ID, ALIAS=REQUEST_TYPE_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=ID_METHOD_TYPE_ID, ALIAS=ID_METHOD_TYPE_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=CASE_ORIGIN_ID, ALIAS=CASE_ORIGIN_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=ID_RECEIVED_DATE_ID, ALIAS=ID_RECEIVED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=ID_PROCESSED_DATE_ID, ALIAS=ID_PROCESSED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=ID_COMPLETE_DATE_ID, ALIAS=ID_COMPLETE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_EXAMINE_DATE_ID, ALIAS=CASE_EXAMINE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_EXAMINE_COMPLETE_DATE_ID, ALIAS=CASE_EXAMINE_COMPLETE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_RESEARCH_DATE_ID, ALIAS=CASE_RESEARCH_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_RESEARCH_COMPLETE_DATE_ID, ALIAS=CASE_RESEARCH_COMPLETE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_FURTHER_REVIEW_DATE_ID, ALIAS=CASE_FURTHER_REVIEW_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE__FR_COMPLETE_DATE_ID, ALIAS=CASE__FR_COMPLETE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=ID_REQ_RECEIVED_TS, ALIAS=ID_REQ_RECEIVED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=ID_PROCESSED_TS, ALIAS=ID_PROCESSED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=ID_COMPLETE_TS, ALIAS=ID_COMPLETE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE_EXAMINE_TS, ALIAS=CASE_EXAMINE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE_EXAMINE_COMPLETE_TS, ALIAS=CASE_EXAMINE_COMPLETE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE_RESEARCH_TS, ALIAS=CASE_RESEARCH_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE_RESEARCH_COMPLETE_TS, ALIAS=CASE_RESEARCH_COMPLETE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE_FURTHER_REVIEW_TS, ALIAS=CASE_FURTHER_REVIEW_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE__FR_COMPLETE_TS, ALIAS=CASE__FR_COMPLETE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE_EXAMINER_ID, ALIAS=CASE_EXAMINER_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_INVESTIGATOR_ID, ALIAS=CASE_INVESTIGATOR_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_SENIOR_INVESTIGATOR_ID, ALIAS=CASE_SENIOR_INVESTIGATOR_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=ID_RECEIVED_QUANTITY, ALIAS=ID_RECEIVED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=ID_PROCESSED_QUANTITY, ALIAS=ID_PROCESSED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=ID_COMPLETE_QUANTITY, ALIAS=ID_COMPLETE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_GENERATED_QUANTITY, ALIAS=CASE_GENERATED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_NOT_GEN_QUANTITY, ALIAS=CASE_NOT_GEN_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_EXAMINE_QUANTITY, ALIAS=CASE_EXAMINE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_EXAMINE_COMPLETE_QUANTITY, ALIAS=CASE_EXAMINE_COMPLETE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_RESEARCH_QUANTITY, ALIAS=CASE_RESEARCH_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_RESEARCH_COMPLETE_QUANTIT, ALIAS=CASE_RESEARCH_COMPLETE_QUANTIT, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_FURTHER_REVIEW_QUANTITY, ALIAS=CASE_FURTHER_REVIEW_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_FR_COMPLETE_QUANTITY, ALIAS=CASE_FR_COMPLETE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_EXAMINE_PASS_QUANTITY, ALIAS=CASE_EXAMINE_PASS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_EXAMINE_FAILED_QUANTITY, ALIAS=CASE_EXAMINE_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_RESEARCH_PASS_QUANTITY, ALIAS=CASE_RESEARCH_PASS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_RESEARCH_FAILED_QUANTITY, ALIAS=CASE_RESEARCH_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_POSSIBLE_CE_QUANTITY, ALIAS=CASE_POSSIBLE_CE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_POSSIBLE_SP_QUANTITY, ALIAS=CASE_POSSIBLE_SP_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_REVIEW_PASS_QUANTITY, ALIAS=CASE_REVIEW_PASS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_REVIEW_FAILED_QUANTITY, ALIAS=CASE_REVIEW_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_CLERICAL_ERROR_QUANTITY, ALIAS=CASE_CLERICAL_ERROR_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_CE_REASON_TYPE_ID, ALIAS=CASE_CE_REASON_TYPE_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=CASE_FALSE_INFO_QUANTITY, ALIAS=CASE_FALSE_INFO_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_RR_REASON_TYPE_ID, ALIAS=CASE_RR_REASON_TYPE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_REL_AND_REDIRECT_QUANTITY, ALIAS=CASE_REL_AND_REDIRECT_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=SAMPLE1_LAG, ALIAS=SAMPLE1_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=SAMPLE2_LAG, ALIAS=SAMPLE2_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=SAMPLE3_LAG, ALIAS=SAMPLE3_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=CASE_CURRENT_STATUS_ID, ALIAS=CASE_CURRENT_STATUS_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_CURRENT_STATUS_TS, ALIAS=CASE_CURRENT_STATUS_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE_CURRENT_STATUS_QUANTITY, ALIAS=CASE_CURRENT_STATUS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_INVEST_STATUS_ID, ALIAS=CASE_INVEST_STATUS_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_INVEST_STATUS_TS, ALIAS=CASE_INVEST_STATUS_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CANDIDATE_CNT, ALIAS=CANDIDATE_CNT, USAGE=P23, ACTUAL=P12,
MISSING=ON, $
FIELDNAME=CREATE_USER, ALIAS=CREATE_USER, USAGE=A30, ACTUAL=A30, $
FIELDNAME=CREATE_TS, ALIAS=CREATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $
FIELDNAME=UPDATE_USER, ALIAS=UPDATE_USER, USAGE=A30, ACTUAL=A30, $
FIELDNAME=UPDATE_TS, ALIAS=UPDATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $


SEGNAME=PCT_REQUEST_FACT, TABLENAME=PROTOTYPE_READ.PCT_REQUEST_FACT,
CONNECTION=INTD, KEYS=1, $

FILENAME=PCT_REQUEST_FACT, SUFFIX=SQLORA , $
SEGMENT=PCT_REQUEST_FACT, SEGTYPE=S0, $
FIELDNAME=ID, ALIAS=ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=REQUEST_ID, ALIAS=REQUEST_ID, USAGE=A100, ACTUAL=A100, $
FIELDNAME=REQUEST_TYPE_ID, ALIAS=REQUEST_TYPE_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=CARD_TYPE_ID, ALIAS=CARD_TYPE_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=PSR_REQUEST_RECEIVED_DATE_ID, ALIAS=PSR_REQUEST_RECEIVED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=PSR_REQUEST_SUBMITTED_DATE_ID, ALIAS=PSR_REQUEST_SUBMITTED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=PCT_REQUEST_RECEIVED_DATE_ID, ALIAS=PCT_REQUEST_RECEIVED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=PSR_REQUEST_FAILED_DATE_ID, ALIAS=PSR_REQUEST_FAILED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=ENROLMENT_PROCESSED_DATE_ID, ALIAS=ENROLMENT_PROCESSED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=MANUAL_ENROL_ASSIGNED_DATE_ID, ALIAS=MANUAL_ENROL_ASSIGNED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=ENROLMENT_COMPLETE_DATE_ID, ALIAS=ENROLMENT_COMPLETE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=MAN_ENROLMENT_COMPLETE_DATE_ID, ALIAS=MAN_ENROLMENT_COMPLETE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=MANUAL_APPRL_ASSIGNED_DATE_ID, ALIAS=MANUAL_APPRL_ASSIGNED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=MANUAL_APPRL_COMPLETE_DATE_ID, ALIAS=MANUAL_APPRL_COMPLETE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=RECORD_STATUS_CHANGE_DATE_ID, ALIAS=RECORD_STATUS_CHANGE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=MANUAL_UPLD_SUBMITTED_DATE_ID, ALIAS=MANUAL_UPLD_SUBMITTED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=PSR_REQUEST_RECEIVED_TS, ALIAS=PSR_REQUEST_RECEIVED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=PSR_REQUEST_SUBMITTED_TS, ALIAS=PSR_REQUEST_SUBMITTED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=PCT_REQUEST_RECEIVED_TS, ALIAS=PCT_REQUEST_RECEIVED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=PSR_REQUEST_FAILED_TS, ALIAS=PSR_REQUEST_FAILED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=ENROLMENT_SUBMITTED_TS, ALIAS=ENROLMENT_SUBMITTED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=MANUAL_ENROL_ASSIGNED_TS, ALIAS=MANUAL_ENROL_ASSIGNED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=ENROLMENT_COMPLETE_TS, ALIAS=ENROLMENT_COMPLETE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=MAN_ENROLMENT_COMPLETE_TS, ALIAS=MAN_ENROLMENT_COMPLETE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=MANUAL_APPROVAL_ASSIGNED_TS, ALIAS=MANUAL_APPROVAL_ASSIGNED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=MANUAL_APPROVAL_COMPLETE_TS, ALIAS=MANUAL_APPROVAL_COMPLETE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=RECORD_STATUS_CHANGE_TS, ALIAS=RECORD_STATUS_CHANGE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=MANUAL_UPLOAD_SUBMITTED_TS, ALIAS=MANUAL_UPLOAD_SUBMITTED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=MANUAL_UPLD_SUBMITTER_ID, ALIAS=MANUAL_UPLD_SUBMITTER_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=PSR_REQ_RECEIVED_QUANTITY, ALIAS=PSR_REQ_RECEIVED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=PSR_REQ_SUBMITTED_QUANTITY, ALIAS=PSR_REQ_SUBMITTED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=PCT_REQ_RECEIVED_QUANTITY, ALIAS=PCT_REQ_RECEIVED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=PCT_REQ_FAILED_QUANTITY, ALIAS=PCT_REQ_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=PSR_REQ_FAILED_QUANTITY, ALIAS=PSR_REQ_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=ENROL_PROCESSED_QUANTITY, ALIAS=ENROL_PROCESSED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=ENROL_COMPLETE_QUANTITY, ALIAS=ENROL_COMPLETE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MAN_ENROL_ASSIGNED_QUANTITY, ALIAS=MAN_ENROL_ASSIGNED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MAN_ENROL_COMPLETE_QUANTITY, ALIAS=MAN_ENROL_COMPLETE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=AUTO_ENROL_PASS_QUANTITY, ALIAS=AUTO_ENROL_PASS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=AUTO_ENROL_FAILED_QUANTITY, ALIAS=AUTO_ENROL_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MANUAL_ENROL_PASS_QUANTITY, ALIAS=MANUAL_ENROL_PASS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MANUAL_ENROL_FAILED_QUANTITY, ALIAS=MANUAL_ENROL_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MAN_APPROVAL_DECLINED_QUANTITY, ALIAS=MAN_APPROVAL_DECLINED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MAN_APPROVAL_ASSIGNED_QUANTITY, ALIAS=MAN_APPROVAL_ASSIGNED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MAN_APPROVAL_FAILED_QUANTITY, ALIAS=MAN_APPROVAL_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MAN_APPROVAL_PASS_QUANTITY, ALIAS=MAN_APPROVAL_PASS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=RECORD_STCHG_CASE_QUANTITY, ALIAS=RECORD_STCHG_CASE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=RECORD_STCHG_RESET_QUANTITY, ALIAS=RECORD_STCHG_RESET_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=IA_COMPLETE_L1_ASSIGNED_LAG, ALIAS=IA_COMPLETE_L1_ASSIGNED_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=ST_ENROL_MAN_ENROL_ASS_LAG, ALIAS=ST_ENROL_MAN_ENROL_ASS_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=L1_ADJ_COMPLETE_L2_ASS_LAG, ALIAS=L1_ADJ_COMPLETE_L2_ASS_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=L2_ADJ_COMPLETE_L3_ASS_LAG, ALIAS=L2_ADJ_COMPLETE_L3_ASS_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=MAN_DECLINE_PH_RETAK_LAG, ALIAS=MAN_DECLINE_PH_RETAK_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=REQ_CURRENT_STATUS_ID, ALIAS=REQ_CURRENT_STATUS_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=REQ_CURRENT_STATUS_TS, ALIAS=REQ_CURRENT_STATUS_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=REQ_CURRENT_STATUS_QUANTITY, ALIAS=REQ_CURRENT_STATUS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=RECORD_STATUS_CHG_QUANTITY, ALIAS=RECORD_STATUS_CHG_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=RECORD_STATUS_ID, ALIAS=RECORD_STATUS_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=DIN_NUMBER, ALIAS=DIN_NUMBER, USAGE=A9, ACTUAL=A9, $
FIELDNAME=LCS_OPERATOR_ID, ALIAS=LCS_OPERATOR_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=LCS_OFFICE_ID, ALIAS=LCS_OFFICE_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=SEX_ID, ALIAS=SEX_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=AGE_GROUP_ID, ALIAS=AGE_GROUP_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=FACENESS_VALUE, ALIAS=FACENESS_VALUE, USAGE=P24.2, ACTUAL=P12,
MISSING=ON, $
FIELDNAME=CREATE_USER, ALIAS=CREATE_USER, USAGE=A30, ACTUAL=A30, $
FIELDNAME=CREATE_TS, ALIAS=CREATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $
FIELDNAME=UPDATE_USER, ALIAS=UPDATE_USER, USAGE=A30, ACTUAL=A30, $
FIELDNAME=UPDATE_TS, ALIAS=UPDATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $


SEGNAME=CALENDAR_DIM, TABLENAME=ENT_OWNER.CALENDAR_DIM, CONNECTION=DW_PCT,
KEYS=1, $

FILENAME=CALENDAR_DIM, SUFFIX=SQLORA , $
SEGMENT=CALENDAR_DIM, SEGTYPE=S0, $
FIELDNAME=ID, ALIAS=ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=CALENDAR_DATE, ALIAS=CALENDAR_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS, $
FIELDNAME=FULL_DATE_DESC, ALIAS=FULL_DATE_DESC, USAGE=A30, ACTUAL=A30,
MISSING=ON, $
FIELDNAME=PERIOD_NAME, ALIAS=PERIOD_NAME, USAGE=A10, ACTUAL=A10,
MISSING=ON, $
FIELDNAME=DAY_OF_WEEK, ALIAS=DAY_OF_WEEK, USAGE=A10, ACTUAL=A10,
MISSING=ON, $
FIELDNAME=DAY_NUMBER_WEEK, ALIAS=DAY_NUMBER_WEEK, USAGE=P2, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=DAY_NUMBER_MONTH, ALIAS=DAY_NUMBER_MONTH, USAGE=P3, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=DAY_NUMBER_YEAR, ALIAS=DAY_NUMBER_YEAR, USAGE=P4, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=DAY_NUMBER_FISCAL_WEEK, ALIAS=DAY_NUMBER_FISCAL_WEEK, USAGE=P2, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=DAY_NUMBER_FISCAL_MONTH, ALIAS=DAY_NUMBER_FISCAL_MONTH, USAGE=P3, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=DAY_NUMBER_FISCAL_YEAR, ALIAS=DAY_NUMBER_FISCAL_YEAR, USAGE=P4, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=LAST_DAY_IN_WEEK_IND, ALIAS=LAST_DAY_IN_WEEK_IND, USAGE=A1, ACTUAL=A1,
MISSING=ON, $
FIELDNAME=LAST_DAY_IN_MONTH_IND, ALIAS=LAST_DAY_IN_MONTH_IND, USAGE=A1, ACTUAL=A1,
MISSING=ON, $
FIELDNAME=WEEK_ENDING_DATE, ALIAS=WEEK_ENDING_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=WEEK, ALIAS=WEEK, USAGE=P3, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=WEEK_NUMBER_YEAR, ALIAS=WEEK_NUMBER_YEAR, USAGE=P7, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=MONTH_NAME, ALIAS=MONTH_NAME, USAGE=A10, ACTUAL=A10,
MISSING=ON, $
FIELDNAME=DAYS_IN_MONTH, ALIAS=DAYS_IN_MONTH, USAGE=P3, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=BUSINESS_DAYS_IN_MONTH, ALIAS=BUSINESS_DAYS_IN_MONTH, USAGE=P3, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=MONTH_NUMBER_YEAR, ALIAS=MONTH_NUMBER_YEAR, USAGE=P7, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=YEAR_MONTH, ALIAS=YEAR_MONTH, USAGE=P7, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=QUARTER, ALIAS=QUARTER, USAGE=A2, ACTUAL=A2,
MISSING=ON, $
FIELDNAME=YEAR_QUARTER, ALIAS=YEAR_QUARTER, USAGE=A6, ACTUAL=A6,
MISSING=ON, $
FIELDNAME=HALF_YEAR, ALIAS=HALF_YEAR, USAGE=P2, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=YEAR, ALIAS=YEAR, USAGE=P5, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=FISCAL_WEEK, ALIAS=FISCAL_WEEK, USAGE=P3, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=FISCAL_WEEK_NUMBER_YEAR, ALIAS=FISCAL_WEEK_NUMBER_YEAR, USAGE=P7, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=FISCAL_MONTH, ALIAS=FISCAL_MONTH, USAGE=A10, ACTUAL=A10,
MISSING=ON, $
FIELDNAME=FISCAL_MONTH_NUMBER, ALIAS=FISCAL_MONTH_NUMBER, USAGE=P3, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=FISCAL_YEAR_MONTH, ALIAS=FISCAL_YEAR_MONTH, USAGE=P7, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=FISCAL_QUARTER, ALIAS=FISCAL_QUARTER, USAGE=A2, ACTUAL=A2,
MISSING=ON, $
FIELDNAME=FISCAL_HALF_YEAR, ALIAS=FISCAL_HALF_YEAR, USAGE=P2, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=FISCAL_YEAR, ALIAS=FISCAL_YEAR, USAGE=P5, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=DAYS_IN_FISCAL_PERIOD, ALIAS=DAYS_IN_FISCAL_PERIOD, USAGE=P4, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=BUSINESS_DAYS_IN_FISCAL_PERIOD, ALIAS=BUSINESS_DAYS_IN_FISCAL_PERIOD, USAGE=P4, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=HOLIDAY_IND, ALIAS=HOLIDAY_IND, USAGE=A1, ACTUAL=A1,
MISSING=ON, $
FIELDNAME=HOLIDAY_NAME, ALIAS=HOLIDAY_NAME, USAGE=A30, ACTUAL=A30,
MISSING=ON, $
FIELDNAME=WEEKDAY_IND, ALIAS=WEEKDAY_IND, USAGE=A1, ACTUAL=A1,
MISSING=ON, $
FIELDNAME=MAJOR_EVENT, ALIAS=MAJOR_EVENT, USAGE=A20, ACTUAL=A20,
MISSING=ON, $
FIELDNAME=CREATE_DATE, ALIAS=CREATE_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CREATE_BY, ALIAS=CREATE_BY, USAGE=A100, ACTUAL=A100,
MISSING=ON, $
FIELDNAME=UPDATE_DATE, ALIAS=UPDATE_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=UPDATE_BY, ALIAS=UPDATE_BY, USAGE=A100, ACTUAL=A100,
MISSING=ON, $
FIELDNAME=MONTH_NUMBER, ALIAS=MONTH_NUMBER, USAGE=P3, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=QUARTER_NUMBER, ALIAS=QUARTER_NUMBER, USAGE=P2, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=FISCAL_QUARTER_NUMBER, ALIAS=FISCAL_QUARTER_NUMBER, USAGE=P2, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=WEEK_NUMBER_MONTH, ALIAS=WEEK_NUMBER_MONTH, USAGE=P2, ACTUAL=P8,
MISSING=ON, $


SEGNAME=CARD_TYPE_DIM, TABLENAME=PROTOTYPE_READ.CARD_TYPE_DIM,
CONNECTION=INTD, KEYS=1, $

FILENAME=CARD_TYPE_DIM, SUFFIX=SQLORA , $
SEGMENT=CARD_TYPE_DIM, SEGTYPE=S0, $
FIELDNAME=ID, ALIAS=ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=CARD_TYPE_CODE, ALIAS=CARD_TYPE_CODE, USAGE=A30, ACTUAL=A30, $
FIELDNAME=CARD_TYPE_NAME, ALIAS=CARD_TYPE_NAME, USAGE=A100, ACTUAL=A100,
MISSING=ON, $
FIELDNAME=CREATE_USER, ALIAS=CREATE_USER, USAGE=A30, ACTUAL=A30,
MISSING=ON, $
FIELDNAME=CREATE_TS, ALIAS=CREATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $
FIELDNAME=UPDATE_USER, ALIAS=UPDATE_USER, USAGE=A30, ACTUAL=A30,
MISSING=ON, $
FIELDNAME=UPDATE_TS, ALIAS=UPDATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $

Here is the image_analysis access and master files:

SEGNAME=PCT_REQUEST_FACT, TABLENAME=PROTOTYPE_READ.PCT_REQUEST_FACT,
CONNECTION=INTD, GUI_PARAMS='0,228,19,276,67,278,160', KEYS=1, $
SEGNAME=CARD_TYPE_DIM, TABLENAME=PROTOTYPE_READ.CARD_TYPE_DIM,
CONNECTION=INTD, KEYFLD=ID, IXFLD=ID,
GUI_PARAMS='0,100,154,148,202,278,160', KEYS=1, $
SEGNAME=PCT_CASE_FACT, TABLENAME=PROTOTYPE_READ.PCT_CASE_FACT,
CONNECTION=INTD, KEYFLD=ID, IXFLD=ID,
GUI_PARAMS='0,200,154,248,202,278,160', KEYS=1, $
SEGNAME=IDENTIFICATION_METHOD_TYPE_DIM,
TABLENAME=PROTOTYPE_READ.IDENTIFICATION_METHOD_TYPE_DIM, CONNECTION=INTD,
KEYFLD=ID, IXFLD=ID, GUI_PARAMS='0,98,283,146,331,278,160', KEYS=1, $
SEGNAME=PCT_ORIGIN_DIM, TABLENAME=PROTOTYPE_READ.PCT_ORIGIN_DIM,
CONNECTION=INTD, KEYFLD=ID, IXFLD=ID,
GUI_PARAMS='0,199,284,247,332,278,160', KEYS=1, $
SEGNAME=PCT_REQUEST_TYPE_DIM, TABLENAME=PROTOTYPE_READ.PCT_REQUEST_TYPE_DIM,
CONNECTION=INTD, KEYFLD=ID, IXFLD=ID,
GUI_PARAMS='0,302,282,350,330,278,160', KEYS=1, $
SEGNAME=CALENDAR_DIM, TABLENAME=ENT_OWNER.CALENDAR_DIM, CONNECTION=DW_PCT,
KEYFLD=ID, IXFLD=ID, GUI_PARAMS='0,300,154,348,202,278,160', KEYS=1, $


FILENAME=image_analysis, SUFFIX=SQLORA , $
SEGMENT=PCT_REQUEST_FACT, SEGTYPE=S0, $
FIELDNAME=ID, ALIAS=ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=REQUEST_ID, ALIAS=REQUEST_ID, USAGE=A100, ACTUAL=A100, $
FIELDNAME=REQUEST_TYPE_ID, ALIAS=REQUEST_TYPE_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=CARD_TYPE_ID, ALIAS=CARD_TYPE_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=PSR_REQUEST_RECEIVED_DATE_ID, ALIAS=PSR_REQUEST_RECEIVED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=PSR_REQUEST_SUBMITTED_DATE_ID, ALIAS=PSR_REQUEST_SUBMITTED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=PCT_REQUEST_RECEIVED_DATE_ID, ALIAS=PCT_REQUEST_RECEIVED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=PSR_REQUEST_FAILED_DATE_ID, ALIAS=PSR_REQUEST_FAILED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=ENROLMENT_PROCESSED_DATE_ID, ALIAS=ENROLMENT_PROCESSED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=MANUAL_ENROL_ASSIGNED_DATE_ID, ALIAS=MANUAL_ENROL_ASSIGNED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=ENROLMENT_COMPLETE_DATE_ID, ALIAS=ENROLMENT_COMPLETE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=MAN_ENROLMENT_COMPLETE_DATE_ID, ALIAS=MAN_ENROLMENT_COMPLETE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=MANUAL_APPRL_ASSIGNED_DATE_ID, ALIAS=MANUAL_APPRL_ASSIGNED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=MANUAL_APPRL_COMPLETE_DATE_ID, ALIAS=MANUAL_APPRL_COMPLETE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=RECORD_STATUS_CHANGE_DATE_ID, ALIAS=RECORD_STATUS_CHANGE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=MANUAL_UPLD_SUBMITTED_DATE_ID, ALIAS=MANUAL_UPLD_SUBMITTED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=PSR_REQUEST_RECEIVED_TS, ALIAS=PSR_REQUEST_RECEIVED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=PSR_REQUEST_SUBMITTED_TS, ALIAS=PSR_REQUEST_SUBMITTED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=PCT_REQUEST_RECEIVED_TS, ALIAS=PCT_REQUEST_RECEIVED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=PSR_REQUEST_FAILED_TS, ALIAS=PSR_REQUEST_FAILED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=ENROLMENT_SUBMITTED_TS, ALIAS=ENROLMENT_SUBMITTED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=MANUAL_ENROL_ASSIGNED_TS, ALIAS=MANUAL_ENROL_ASSIGNED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=ENROLMENT_COMPLETE_TS, ALIAS=ENROLMENT_COMPLETE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=MAN_ENROLMENT_COMPLETE_TS, ALIAS=MAN_ENROLMENT_COMPLETE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=MANUAL_APPROVAL_ASSIGNED_TS, ALIAS=MANUAL_APPROVAL_ASSIGNED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=MANUAL_APPROVAL_COMPLETE_TS, ALIAS=MANUAL_APPROVAL_COMPLETE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=RECORD_STATUS_CHANGE_TS, ALIAS=RECORD_STATUS_CHANGE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=MANUAL_UPLOAD_SUBMITTED_TS, ALIAS=MANUAL_UPLOAD_SUBMITTED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=MANUAL_UPLD_SUBMITTER_ID, ALIAS=MANUAL_UPLD_SUBMITTER_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=PSR_REQ_RECEIVED_QUANTITY, ALIAS=PSR_REQ_RECEIVED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=PSR_REQ_SUBMITTED_QUANTITY, ALIAS=PSR_REQ_SUBMITTED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=PCT_REQ_RECEIVED_QUANTITY, ALIAS=PCT_REQ_RECEIVED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=PCT_REQ_FAILED_QUANTITY, ALIAS=PCT_REQ_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=PSR_REQ_FAILED_QUANTITY, ALIAS=PSR_REQ_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=ENROL_PROCESSED_QUANTITY, ALIAS=ENROL_PROCESSED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=ENROL_COMPLETE_QUANTITY, ALIAS=ENROL_COMPLETE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MAN_ENROL_ASSIGNED_QUANTITY, ALIAS=MAN_ENROL_ASSIGNED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MAN_ENROL_COMPLETE_QUANTITY, ALIAS=MAN_ENROL_COMPLETE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=AUTO_ENROL_PASS_QUANTITY, ALIAS=AUTO_ENROL_PASS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=AUTO_ENROL_FAILED_QUANTITY, ALIAS=AUTO_ENROL_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MANUAL_ENROL_PASS_QUANTITY, ALIAS=MANUAL_ENROL_PASS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MANUAL_ENROL_FAILED_QUANTITY, ALIAS=MANUAL_ENROL_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MAN_APPROVAL_DECLINED_QUANTITY, ALIAS=MAN_APPROVAL_DECLINED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MAN_APPROVAL_ASSIGNED_QUANTITY, ALIAS=MAN_APPROVAL_ASSIGNED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MAN_APPROVAL_FAILED_QUANTITY, ALIAS=MAN_APPROVAL_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=MAN_APPROVAL_PASS_QUANTITY, ALIAS=MAN_APPROVAL_PASS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=RECORD_STCHG_CASE_QUANTITY, ALIAS=RECORD_STCHG_CASE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=RECORD_STCHG_RESET_QUANTITY, ALIAS=RECORD_STCHG_RESET_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=IA_COMPLETE_L1_ASSIGNED_LAG, ALIAS=IA_COMPLETE_L1_ASSIGNED_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=ST_ENROL_MAN_ENROL_ASS_LAG, ALIAS=ST_ENROL_MAN_ENROL_ASS_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=L1_ADJ_COMPLETE_L2_ASS_LAG, ALIAS=L1_ADJ_COMPLETE_L2_ASS_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=L2_ADJ_COMPLETE_L3_ASS_LAG, ALIAS=L2_ADJ_COMPLETE_L3_ASS_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=MAN_DECLINE_PH_RETAK_LAG, ALIAS=MAN_DECLINE_PH_RETAK_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=REQ_CURRENT_STATUS_ID, ALIAS=REQ_CURRENT_STATUS_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=REQ_CURRENT_STATUS_TS, ALIAS=REQ_CURRENT_STATUS_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=REQ_CURRENT_STATUS_QUANTITY, ALIAS=REQ_CURRENT_STATUS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=RECORD_STATUS_CHG_QUANTITY, ALIAS=RECORD_STATUS_CHG_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=RECORD_STATUS_ID, ALIAS=RECORD_STATUS_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=DIN_NUMBER, ALIAS=DIN_NUMBER, USAGE=A9, ACTUAL=A9, $
FIELDNAME=LCS_OPERATOR_ID, ALIAS=LCS_OPERATOR_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=LCS_OFFICE_ID, ALIAS=LCS_OFFICE_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=SEX_ID, ALIAS=SEX_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=AGE_GROUP_ID, ALIAS=AGE_GROUP_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=FACENESS_VALUE, ALIAS=FACENESS_VALUE, USAGE=P24.2, ACTUAL=P12,
MISSING=ON, $
FIELDNAME=CREATE_USER, ALIAS=CREATE_USER, USAGE=A30, ACTUAL=A30, $
FIELDNAME=CREATE_TS, ALIAS=CREATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $
FIELDNAME=UPDATE_USER, ALIAS=UPDATE_USER, USAGE=A30, ACTUAL=A30, $
FIELDNAME=UPDATE_TS, ALIAS=UPDATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $
SEGMENT=CARD_TYPE_DIM, SEGTYPE=U, PARENT=PCT_REQUEST_FACT, $
FIELDNAME=ID, ALIAS=ID, USAGE=I11, ACTUAL=I4,
WITHIN='*Card Type',
PROPERTY=UID, $
FIELDNAME=CARD_TYPE_CODE, ALIAS=CARD_TYPE_CODE, USAGE=A30, ACTUAL=A30,
REFERENCE=CARD_TYPE_DIM.ID, PROPERTY=CAPTION, $
FIELDNAME=CARD_TYPE_NAME, ALIAS=CARD_TYPE_NAME, USAGE=A100, ACTUAL=A100,
MISSING=ON,
REFERENCE=CARD_TYPE_DIM.ID, PROPERTY=PARENT_OF, $
FIELDNAME=CREATE_USER, ALIAS=CREATE_USER, USAGE=A30, ACTUAL=A30,
MISSING=ON, $
FIELDNAME=CREATE_TS, ALIAS=CREATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $
FIELDNAME=UPDATE_USER, ALIAS=UPDATE_USER, USAGE=A30, ACTUAL=A30,
MISSING=ON, $
FIELDNAME=UPDATE_TS, ALIAS=UPDATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $
SEGMENT=PCT_CASE_FACT, SEGTYPE=U, PARENT=PCT_REQUEST_FACT, $
FIELDNAME=ID, ALIAS=ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=CASE_ID, ALIAS=CASE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=REQUEST_ID, ALIAS=REQUEST_ID, USAGE=A100, ACTUAL=A100, $
FIELDNAME=REQUEST_TYPE_ID, ALIAS=REQUEST_TYPE_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=ID_METHOD_TYPE_ID, ALIAS=ID_METHOD_TYPE_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=CASE_ORIGIN_ID, ALIAS=CASE_ORIGIN_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=ID_RECEIVED_DATE_ID, ALIAS=ID_RECEIVED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=ID_PROCESSED_DATE_ID, ALIAS=ID_PROCESSED_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=ID_COMPLETE_DATE_ID, ALIAS=ID_COMPLETE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_EXAMINE_DATE_ID, ALIAS=CASE_EXAMINE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_EXAMINE_COMPLETE_DATE_ID, ALIAS=CASE_EXAMINE_COMPLETE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_RESEARCH_DATE_ID, ALIAS=CASE_RESEARCH_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_RESEARCH_COMPLETE_DATE_ID, ALIAS=CASE_RESEARCH_COMPLETE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_FURTHER_REVIEW_DATE_ID, ALIAS=CASE_FURTHER_REVIEW_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE__FR_COMPLETE_DATE_ID, ALIAS=CASE__FR_COMPLETE_DATE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=ID_REQ_RECEIVED_TS, ALIAS=ID_REQ_RECEIVED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=ID_PROCESSED_TS, ALIAS=ID_PROCESSED_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=ID_COMPLETE_TS, ALIAS=ID_COMPLETE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE_EXAMINE_TS, ALIAS=CASE_EXAMINE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE_EXAMINE_COMPLETE_TS, ALIAS=CASE_EXAMINE_COMPLETE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE_RESEARCH_TS, ALIAS=CASE_RESEARCH_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE_RESEARCH_COMPLETE_TS, ALIAS=CASE_RESEARCH_COMPLETE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE_FURTHER_REVIEW_TS, ALIAS=CASE_FURTHER_REVIEW_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE__FR_COMPLETE_TS, ALIAS=CASE__FR_COMPLETE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE_EXAMINER_ID, ALIAS=CASE_EXAMINER_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_INVESTIGATOR_ID, ALIAS=CASE_INVESTIGATOR_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_SENIOR_INVESTIGATOR_ID, ALIAS=CASE_SENIOR_INVESTIGATOR_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=ID_RECEIVED_QUANTITY, ALIAS=ID_RECEIVED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=ID_PROCESSED_QUANTITY, ALIAS=ID_PROCESSED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=ID_COMPLETE_QUANTITY, ALIAS=ID_COMPLETE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_GENERATED_QUANTITY, ALIAS=CASE_GENERATED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_NOT_GEN_QUANTITY, ALIAS=CASE_NOT_GEN_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_EXAMINE_QUANTITY, ALIAS=CASE_EXAMINE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_EXAMINE_COMPLETE_QUANTITY, ALIAS=CASE_EXAMINE_COMPLETE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_RESEARCH_QUANTITY, ALIAS=CASE_RESEARCH_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_RESEARCH_COMPLETE_QUANTIT, ALIAS=CASE_RESEARCH_COMPLETE_QUANTIT, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_FURTHER_REVIEW_QUANTITY, ALIAS=CASE_FURTHER_REVIEW_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_FR_COMPLETE_QUANTITY, ALIAS=CASE_FR_COMPLETE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_EXAMINE_PASS_QUANTITY, ALIAS=CASE_EXAMINE_PASS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_EXAMINE_FAILED_QUANTITY, ALIAS=CASE_EXAMINE_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_RESEARCH_PASS_QUANTITY, ALIAS=CASE_RESEARCH_PASS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_RESEARCH_FAILED_QUANTITY, ALIAS=CASE_RESEARCH_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_POSSIBLE_CE_QUANTITY, ALIAS=CASE_POSSIBLE_CE_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_POSSIBLE_SP_QUANTITY, ALIAS=CASE_POSSIBLE_SP_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_REVIEW_PASS_QUANTITY, ALIAS=CASE_REVIEW_PASS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_REVIEW_FAILED_QUANTITY, ALIAS=CASE_REVIEW_FAILED_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_CLERICAL_ERROR_QUANTITY, ALIAS=CASE_CLERICAL_ERROR_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_CE_REASON_TYPE_ID, ALIAS=CASE_CE_REASON_TYPE_ID, USAGE=I11, ACTUAL=I4, $
FIELDNAME=CASE_FALSE_INFO_QUANTITY, ALIAS=CASE_FALSE_INFO_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_RR_REASON_TYPE_ID, ALIAS=CASE_RR_REASON_TYPE_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_REL_AND_REDIRECT_QUANTITY, ALIAS=CASE_REL_AND_REDIRECT_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=SAMPLE1_LAG, ALIAS=SAMPLE1_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=SAMPLE2_LAG, ALIAS=SAMPLE2_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=SAMPLE3_LAG, ALIAS=SAMPLE3_LAG, USAGE=A15, ACTUAL=A15,
MISSING=ON, $
FIELDNAME=CASE_CURRENT_STATUS_ID, ALIAS=CASE_CURRENT_STATUS_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_CURRENT_STATUS_TS, ALIAS=CASE_CURRENT_STATUS_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CASE_CURRENT_STATUS_QUANTITY, ALIAS=CASE_CURRENT_STATUS_QUANTITY, USAGE=P2, ACTUAL=P1, $
FIELDNAME=CASE_INVEST_STATUS_ID, ALIAS=CASE_INVEST_STATUS_ID, USAGE=I11, ACTUAL=I4,
MISSING=ON, $
FIELDNAME=CASE_INVEST_STATUS_TS, ALIAS=CASE_INVEST_STATUS_TS, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CANDIDATE_CNT, ALIAS=CANDIDATE_CNT, USAGE=P23, ACTUAL=P12,
MISSING=ON, $
FIELDNAME=CREATE_USER, ALIAS=CREATE_USER, USAGE=A30, ACTUAL=A30, $
FIELDNAME=CREATE_TS, ALIAS=CREATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $
FIELDNAME=UPDATE_USER, ALIAS=UPDATE_USER, USAGE=A30, ACTUAL=A30, $
FIELDNAME=UPDATE_TS, ALIAS=UPDATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $
SEGMENT=IDENTIFICATION_METHOD_TYPE_DIM, SEGTYPE=U, PARENT=PCT_CASE_FACT, $
FIELDNAME=ID, ALIAS=ID, USAGE=I11, ACTUAL=I4,
WITHIN='*Analysis Type',
PROPERTY=UID, $
FIELDNAME=ID_METHOD_CODE, ALIAS=ID_METHOD_CODE, USAGE=A30, ACTUAL=A30,
REFERENCE=IDENTIFICATION_METHOD_TYPE_DIM.ID, PROPERTY=CAPTION, $
FIELDNAME=ID_METHOD_NAME, ALIAS=ID_METHOD_NAME, USAGE=A100, ACTUAL=A100,
MISSING=ON,
REFERENCE=IDENTIFICATION_METHOD_TYPE_DIM.ID, PROPERTY=PARENT_OF, $
FIELDNAME=CREATE_USER, ALIAS=CREATE_USER, USAGE=A30, ACTUAL=A30,
MISSING=ON, $
FIELDNAME=CREATE_TS, ALIAS=CREATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $
FIELDNAME=UPDATE_USER, ALIAS=UPDATE_USER, USAGE=A30, ACTUAL=A30,
MISSING=ON, $
FIELDNAME=UPDATE_TS, ALIAS=UPDATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $
SEGMENT=PCT_ORIGIN_DIM, SEGTYPE=U, PARENT=PCT_CASE_FACT, $
FIELDNAME=ID, ALIAS=ID, USAGE=I11, ACTUAL=I4,
WITHIN='*Origin',
PROPERTY=UID, $
FIELDNAME=ORIGIN_CODE, ALIAS=ORIGIN_CODE, USAGE=A30, ACTUAL=A30,
REFERENCE=PCT_ORIGIN_DIM.ID, PROPERTY=CAPTION, $
FIELDNAME=ORIGIN_NAME, ALIAS=ORIGIN_NAME, USAGE=A100, ACTUAL=A100,
MISSING=ON,
REFERENCE=PCT_ORIGIN_DIM.ID, PROPERTY=PARENT_OF, $
FIELDNAME=CREATE_USER, ALIAS=CREATE_USER, USAGE=A30, ACTUAL=A30,
MISSING=ON, $
FIELDNAME=CREATE_TS, ALIAS=CREATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $
FIELDNAME=UPDATE_USER, ALIAS=UPDATE_USER, USAGE=A30, ACTUAL=A30,
MISSING=ON, $
FIELDNAME=UPDATE_TS, ALIAS=UPDATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $
SEGMENT=PCT_REQUEST_TYPE_DIM, SEGTYPE=U, PARENT=PCT_CASE_FACT, $
FIELDNAME=ID, ALIAS=ID, USAGE=I11, ACTUAL=I4,
WITHIN='*Request Type',
PROPERTY=UID, $
FIELDNAME=PCT_REQUEST_TYPE_CODE, ALIAS=PCT_REQUEST_TYPE_CODE, USAGE=A30, ACTUAL=A30,
REFERENCE=PCT_REQUEST_TYPE_DIM.ID, PROPERTY=CAPTION, $
FIELDNAME=PCT_REQUEST_TYPE_NAME, ALIAS=PCT_REQUEST_TYPE_NAME, USAGE=A100, ACTUAL=A100,
MISSING=ON,
REFERENCE=PCT_REQUEST_TYPE_DIM.ID, PROPERTY=PARENT_OF, $
FIELDNAME=CREATE_USER, ALIAS=CREATE_USER, USAGE=A30, ACTUAL=A30, $
FIELDNAME=CREATE_TS, ALIAS=CREATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $
FIELDNAME=UPDATE_USER, ALIAS=UPDATE_USER, USAGE=A30, ACTUAL=A30, $
FIELDNAME=UPDATE_TS, ALIAS=UPDATE_TS, USAGE=HYYMDS, ACTUAL=HYYMDS, $
SEGMENT=CALENDAR_DIM, SEGTYPE=U, PARENT=PCT_REQUEST_FACT, $
FIELDNAME=ID, ALIAS=ID, USAGE=I11, ACTUAL=I4,
WITHIN='*Year',
PROPERTY=UID, $
FIELDNAME=CALENDAR_DATE, ALIAS=CALENDAR_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS, $
FIELDNAME=FULL_DATE_DESC, ALIAS=FULL_DATE_DESC, USAGE=A30, ACTUAL=A30,
MISSING=ON, $
FIELDNAME=PERIOD_NAME, ALIAS=PERIOD_NAME, USAGE=A10, ACTUAL=A10,
MISSING=ON, $
FIELDNAME=DAY_OF_WEEK, ALIAS=DAY_OF_WEEK, USAGE=A10, ACTUAL=A10,
MISSING=ON, $
FIELDNAME=DAY_NUMBER_WEEK, ALIAS=DAY_NUMBER_WEEK, USAGE=P2, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=DAY_NUMBER_MONTH, ALIAS=DAY_NUMBER_MONTH, USAGE=P3, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=DAY_NUMBER_YEAR, ALIAS=DAY_NUMBER_YEAR, USAGE=P4, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=DAY_NUMBER_FISCAL_WEEK, ALIAS=DAY_NUMBER_FISCAL_WEEK, USAGE=P2, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=DAY_NUMBER_FISCAL_MONTH, ALIAS=DAY_NUMBER_FISCAL_MONTH, USAGE=P3, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=DAY_NUMBER_FISCAL_YEAR, ALIAS=DAY_NUMBER_FISCAL_YEAR, USAGE=P4, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=LAST_DAY_IN_WEEK_IND, ALIAS=LAST_DAY_IN_WEEK_IND, USAGE=A1, ACTUAL=A1,
MISSING=ON, $
FIELDNAME=LAST_DAY_IN_MONTH_IND, ALIAS=LAST_DAY_IN_MONTH_IND, USAGE=A1, ACTUAL=A1,
MISSING=ON, $
FIELDNAME=WEEK_ENDING_DATE, ALIAS=WEEK_ENDING_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=WEEK, ALIAS=WEEK, USAGE=P3, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=WEEK_NUMBER_YEAR, ALIAS=WEEK_NUMBER_YEAR, USAGE=P7, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=MONTH_NAME, ALIAS=MONTH_NAME, USAGE=A10, ACTUAL=A10,
MISSING=ON, $
FIELDNAME=DAYS_IN_MONTH, ALIAS=DAYS_IN_MONTH, USAGE=P3, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=BUSINESS_DAYS_IN_MONTH, ALIAS=BUSINESS_DAYS_IN_MONTH, USAGE=P3, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=MONTH_NUMBER_YEAR, ALIAS=MONTH_NUMBER_YEAR, USAGE=P7, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=YEAR_MONTH, ALIAS=YEAR_MONTH, USAGE=P7, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=QUARTER, ALIAS=QUARTER, USAGE=A2, ACTUAL=A2,
MISSING=ON, $
FIELDNAME=YEAR_QUARTER, ALIAS=YEAR_QUARTER, USAGE=A6, ACTUAL=A6,
MISSING=ON, $
FIELDNAME=HALF_YEAR, ALIAS=HALF_YEAR, USAGE=P2, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=YEAR, ALIAS=YEAR, USAGE=P5, ACTUAL=P8,
MISSING=ON,
REFERENCE=CALENDAR_DIM.ID, PROPERTY=CAPTION, $
FIELDNAME=FISCAL_WEEK, ALIAS=FISCAL_WEEK, USAGE=P3, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=FISCAL_WEEK_NUMBER_YEAR, ALIAS=FISCAL_WEEK_NUMBER_YEAR, USAGE=P7, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=FISCAL_MONTH, ALIAS=FISCAL_MONTH, USAGE=A10, ACTUAL=A10,
MISSING=ON, $
FIELDNAME=FISCAL_MONTH_NUMBER, ALIAS=FISCAL_MONTH_NUMBER, USAGE=P3, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=FISCAL_YEAR_MONTH, ALIAS=FISCAL_YEAR_MONTH, USAGE=P7, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=FISCAL_QUARTER, ALIAS=FISCAL_QUARTER, USAGE=A2, ACTUAL=A2,
MISSING=ON, $
FIELDNAME=FISCAL_HALF_YEAR, ALIAS=FISCAL_HALF_YEAR, USAGE=P2, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=FISCAL_YEAR, ALIAS=FISCAL_YEAR, USAGE=P5, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=DAYS_IN_FISCAL_PERIOD, ALIAS=DAYS_IN_FISCAL_PERIOD, USAGE=P4, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=BUSINESS_DAYS_IN_FISCAL_PERIOD, ALIAS=BUSINESS_DAYS_IN_FISCAL_PERIOD, USAGE=P4, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=HOLIDAY_IND, ALIAS=HOLIDAY_IND, USAGE=A1, ACTUAL=A1,
MISSING=ON, $
FIELDNAME=HOLIDAY_NAME, ALIAS=HOLIDAY_NAME, USAGE=A30, ACTUAL=A30,
MISSING=ON, $
FIELDNAME=WEEKDAY_IND, ALIAS=WEEKDAY_IND, USAGE=A1, ACTUAL=A1,
MISSING=ON, $
FIELDNAME=MAJOR_EVENT, ALIAS=MAJOR_EVENT, USAGE=A20, ACTUAL=A20,
MISSING=ON, $
FIELDNAME=CREATE_DATE, ALIAS=CREATE_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=CREATE_BY, ALIAS=CREATE_BY, USAGE=A100, ACTUAL=A100,
MISSING=ON, $
FIELDNAME=UPDATE_DATE, ALIAS=UPDATE_DATE, USAGE=HYYMDS, ACTUAL=HYYMDS,
MISSING=ON, $
FIELDNAME=UPDATE_BY, ALIAS=UPDATE_BY, USAGE=A100, ACTUAL=A100,
MISSING=ON, $
FIELDNAME=MONTH_NUMBER, ALIAS=MONTH_NUMBER, USAGE=P3, ACTUAL=P8,
MISSING=ON,
REFERENCE=CALENDAR_DIM.ID, PROPERTY=PARENT_OF, $
FIELDNAME=QUARTER_NUMBER, ALIAS=QUARTER_NUMBER, USAGE=P2, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=FISCAL_QUARTER_NUMBER, ALIAS=FISCAL_QUARTER_NUMBER, USAGE=P2, ACTUAL=P8,
MISSING=ON, $
FIELDNAME=WEEK_NUMBER_MONTH, ALIAS=WEEK_NUMBER_MONTH, USAGE=P2, ACTUAL=P8,
MISSING=ON, $
DIMENSION=Dimension4, CAPTION='Dimension4', $
HIERARCHY=Card Type, CAPTION='Card Type', HRY_DIMENSION=Dimension4, HRY_STRUCTURE=RECURSIVE, $
DIMENSION=Dimension6, CAPTION='Dimension6', $
HIERARCHY=Analysis Type, CAPTION='Analysis Type', HRY_DIMENSION=Dimension6, HRY_STRUCTURE=RECURSIVE, $
DIMENSION=Dimension7, CAPTION='Dimension7', $
HIERARCHY=Origin, CAPTION='Origin', HRY_DIMENSION=Dimension7, HRY_STRUCTURE=RECURSIVE, $
DIMENSION=Dimension8, CAPTION='Dimension8', $
HIERARCHY=Request Type, CAPTION='Request Type', HRY_DIMENSION=Dimension8, HRY_STRUCTURE=RECURSIVE, $
DIMENSION=Dimension9, CAPTION='Dimension9', $
HIERARCHY=Year, CAPTION='Year', HRY_DIMENSION=Dimension9, HRY_STRUCTURE=RECURSIVE, $


Olap code:

-OLAP ON
SET ASNAMES = ON
SET NODATA = ' '
TABLE FILE PCT_IMG_ANALYSIS
SUM
ID_RECEIVED_QUANTITY
HEADING
"image analysis"
FOOTING
"......................"
ON TABLE SET PAGE-NUM OFF
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET AUTODRILL ALL
ON TABLE SET OLAPPANE TOP
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
ENDSTYLE
END

Thanks in advance.

This message has been edited. Last edited by: Kerry,

I'm ok now. My problem is fixed. Once all the tables were under the same schema it worked fine.