User manual BUSINESS OBJECTS PLANT MAINTENANCE RAPID MART XI 3.2 FOR SAP SOLUTIONS BUSINESS GUIDE 12.2.0.0

[. . . ] SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2, version for SAP solutions - Business Guide Version 12. 2. 0. 0 October 2009 Copyright © Copyright 2009 SAP AG. No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. Trademarks All rights reserved. [. . . ] SAP solutions maintains notification catalogs that store information about damage, cause, and location (see "Malfunction Catalogs" on page 28). If data entry for these is timely and correct in SAP solutions, this information can be useful for failure analysis. However, missing information in these source tables can cause discrepancies in your analyses and reports. The notification section extracts data from the SAP solutions header and line item levels for each notification. The corresponding SAP solutions tables are: · · · QMIH - Quality Notification - maintenance header QMEL - Quality Notification - general header QMFE - Quality Notification - items The target table in the Rapid Mart schema is NOTIFICATION_FACT. SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2 for SAP solutions Business Guide 31 3 Subject Areas Service Notification Section The section also extracts data from SAP solutions to indicate status, such as in-progress, postponed, completed, or deleted. The notification section does not store the history of changes to the data and it does not extract information about activities and tasks. To support plant maintenance analysis, the section allows you to classify equipment and functional locations, and their hierarchies. Though notification items can be part of the classification system, the section does not extract class allocation data for notification items. Therefore, this version of the Rapid Mart does not allow you to classify notification items. However, the NOTIFICATION_FACT table does contain a field, OBJ_ID_CLASS, that captures the assignment of a notification item to classes and characteristics. You can use this as a link to classifications at the line item level when customizing the Rapid Mart. The section also contains a second fact table MTBR_MTTR_FACT that calculates: · · MTBR = Mean (or Average) Time Between Repairs (also called up time) MTTR = Mean (or Average) Time To Repair (also called down time) The NOTIFICATION_FACT table is extracted and populated from SAP solutions first. Then, NOTIFICATION_FACT serves as the source for MTBR_MTTR_FACT. The SAP solutions Plant Maintenance Information System (PMIS) only calculates MTBR and MTTR on a monthly basis. However, you can use data from the notification section to analyze MTBR and MTTR for any duration. Rapid Mart processing The section captures the following dimensional attributes and their associated dimension tables: Attribute Name Business Area Classification Hierarchy Dimension Tables BUSINESS_AREA CLASSIFICATION_HIER, CLASSIFICATION_HIER_HZ, CLASSIFICATION_HIER_VR COMPANY_CODE CONTROLLING_AREA Company Code Controlling Area 32 SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2 for SAP solutions Business Guide Subject Areas Service Notification Section 3 Attribute Name Cost Center & Hierarchy Dimension Tables COST_CENTER, COST_CENTER_HIER, COST_CENTER_HIER_HZ, COST_CENTER_HIER_VR, COST_CENTER_HIER_BAD EQUIPMENT, EQUIPMENT_HIER, EQUIPMENT_HIER_HZ, EQUIPMENT_HIER_VR FUNCTIONAL_LOCATION, FUNCTIONAL_LOCATION_HIER, FUNCTIONAL_LOCATION_HIER_HZ, FUNCTIONAL_LOCATION_HIER_VR INTERNAL_ORDER, INTERNAL_ORDER_HIER, INTERNAL_ORDER_HIER_HZ, INTERNAL_ORDER_HIER_VR, INTERNAL_ORDER_HIER_BAD MAINTENANCE_PRIORITY MALFUNCTION_CAUSE, MALFUNCTION_DAMAGE, MALFUNCTION_OBJ_PART MALFUNCTION_EFFECT MATERIAL, PRODUCT_HIERARCHY MATERIAL_BY_PLANT NOTIFICATION DOCUMENT_CATEGORY DOCUMENT_TYPE & DOCUMENT_CATEGORY PLANNING_GROUP PLANT PLANT_LOCATION SERVICE_PERSON TIME_DIM Equipment & Hierarchy Functional Location & Hierarchy Internal Order & Hierarchy Maintenance Priority Malfunction Catalogs Malfunction Effect Material & Product Hierarchy Material By Plant Notification Notification Category Notification Type Planning Group Plant Plant Location Service Person Time Dimension SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2 for SAP solutions Business Guide 33 3 Subject Areas Service Notification Section Attribute Name Unit Of Measure Work Center & Hierarchy Dimension Tables UNIT_OF_MEASURE WORK_CENTER, WORK_CENTER_HIER, WORK_CENTER_HIER_HZ, WORK_CENTER_HIER_VR, WORK_CENTER_HIER_BAD Fact Table Fields The section contains the following measures. Note: The focus is on reporting durations, therefore most measures are in time units rather than monetary currency or quantities: Fact Table Name MTBR_MTTR_FACT Column Name DAYS_DOWNTIME DAYS_UPTIME HOURS_DOWNTIME HOURS_UPTIME MINS_DOWNTIME MINS_UPTIME NOTIFICATION_FACT DAYS_COMPLT DAYS_DOWNTIME DAYS_REQ HOURS_COMPLT HOURS_DOWNTIME HOURS_REQ MINS_COMPLT MINS_DOWNTIME MINS_REQ QTY_DOWNTIME Description Calculated Days of downtime (as Malfunction end Malfunction start) Calculated Days of uptime: Prev Malfunction end date Malfunction start date Calculated hours of downtime (as Malfunction end Malfunction start) Calculated hours of uptime: Prev Malfunction end date Malfunction start date Calculated minutes of downtime (as Malfunction end Malfunction start) Calculated minutes of uptime: Prev Malfunction end date - Malfunction start date Number of Days to eliminate malfunction (calculated) Number of malfunction days (calculated) Number of Required days to fix malfunction (calculated) Number of Hours to eliminate malfunction (calculated) Number of malfunction Hours (calculated) Number of Required Hours to fix malfunction (calculated) Number of Hours to eliminate malfunction (calculated) Number of malfunction Minutes (calculated) Number of Required Minutes to fix malfunction (calculated) QMIH-AUSZT - Downtime 34 SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2 for SAP solutions Business Guide Subject Areas Service Notification Section 3 Additionally, several "flags" are employed to capture notification status on the NOTIFICATION_FACT table: Column Name BREAKDOWN_FLAG COMPLT_FLAG Description EQIH-MSAUS - Breakdown indicator. Set to 1 if there is a breakdown JEST-STAT (lookup) - NOCO notification completed status is active (1 is active, 0 is inactive) JEST-STAT (lookup) - NOPR notification is progress status is active (1 is active, 0 is inactive) JEST-STAT (lookup) - OSNO outstanding notification status is active (1 is active, 0 is inactive) JEST-STAT (lookup) - NOPO notification postponed status is active (1 is active, 0 is inactive) QMFE-KZLOESCH - Indicator: delete data record. Set to 1 if an item is deleted JEST-STAT (lookup) - DLFL notification completed status is active (1 is active, 0 is inactive) IN_PROGRESS_FLAG OUTSTANDNG_FLAG POSTPONE_FLAG ITEM_DELETE_FLAG NOTIFICTN_DELETE_FLAG SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2 for SAP solutions Business Guide 35 3 Subject Areas Service Notification Section Rapid Mart data The following diagrams shows the tables in the notification section organized as a Star Schema: Notification Fact (1 of 2): 36 SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2 for SAP solutions Business Guide Subject Areas Service Notification Section 3 MTTR / MTBR Fact (2 of 2): With the tables in this section, you can analyze maintenance notifications along several dimensions: · · · · · · · · Business Area Classification Hierarchy Company Code Controlling Area Cost Center & Hierarchy Document Category (Notification Category) Document Type (Notification Type) Equipment & Hierarchy SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2 for SAP solutions Business Guide 37 3 Subject Areas Service Notification Section · · · · · · · · · · · · · · · · · · · · · · · · · Functional Location & Hierarchy Internal Order & Hierarchy (Service Order & Hierarchy) Maintenance Priority Malfunction Catalogs (Cause, Damage, and Object Part) Malfunction Effect Material & Product Hierarchy Material By Plant Notification Planning Group Plant Plant Location Service Person Time Dim Unit Of Measure Work Center & Hierarchy What is the maintenance history of this piece of equipment?What is the mean time to repair (MTTR) and the mean time between repairs (MTBR) for this functional location for the last 5 years by quarter?How often was this equipment down during this year?What kind of damage does this equipment suffer from most often?How efficiently does the planner group work? [. . . ] previous period trend by equipment hierarchy. Calculations · · Section Hierarchy Lvl 1 = [Equipment Level 1 Full Name] Balance Variance vs. Previous Period (ex: Period 2) = [SVC CST SUM Hz Actual PTD Balance Per 02 TRX]-[SVC CST SUM Hz Actual PTD Balance Per 01 TRX] Note: All other Variance vs. Previous Period calculations are done the same way with the appropriate period values. Report SQL All report SQL is located in the Rapid Mart installation directory under "\Sample\DML". SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2 for SAP solutions Business Guide 125 4 Reports Service Order Cost Service Cost Balance Variance Trend View Actual, Planned (or Budget), Variance, and Variance % period service cost trends for a specific Company Code, Functional Location, and Fiscal Year. Calculations · · · · Actual = [SVC CST SUM Vr - Actual PTD Balance TRX] Budget = [SVC CST SUM Vr - Budget PTD Balance TRX] Variance = [SVC CST SUM Vr - Actual PTD Balance TRX]-[SVC CST SUM Vr - Budget PTD Balance TRX] Variance % = If([Actual] <> 0; [Variance]/[Actual]; If([Actual]<> 0 And [Variance]=0; 0;1)) Report SQL All report SQL is located in the Rapid Mart installation directory under "\Sample\DML". 126 SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2 for SAP solutions Business Guide Reports Service Order Cost 4 Service Cost YTD Trend Analysis View Actual YTD trends for a specific Company Code, Parent GL Account, Fiscal Year, and Ledger Version. Calculations · · · · Actual YTD Balance = [SVC CST SUM Vr - Actual PTD Balance TRX] Balance Variance = [SVC CST SUM Vr - Actual PTD Balance TRX]-[SVC CST SUM Vr - Budget PTD Balance TRX] Budget YTD Balance = [SVC CST SUM Vr - Budget PTD Balance TRX] Variance % = If([SVC CST SUM Vr - Actual PTD Balance TRX] <> 0; [Balance Variance]/[SVC CST SUM Vr - Actual PTD Balance TRX]; If([SVC CST SUM Vr - Actual PTD Balance TRX]=0 And [Balance Variance]<>0; 1; 0)) Report SQL All report SQL is located in the Rapid Mart installation directory under "\Sample\DML". Recommended Table Joins To analyze Service Order Cost data you will need to create joins between the fact and dimension tables as follows: SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2 for SAP solutions Business Guide 127 4 Reports Service Order Cost Note: Additional joins between dimension and hierarchy tables are shown in "Recommended table joins" on page 27 for master reports. Fact Table SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ Dimension Table BUSINESS_ACTIVITY BUSINESS_AREA Join Expression BUSINESS_ACTIVITY. BUS_ACTIVITY_ID=SERVICE _COST_SUMMARY_FACT_HZ. BUS_ACTIVITY_ID BUSINESS_AREA. BUS_AREA_ID=SERVICE_COST _SUMMARY_FACT_HZ. BUS_AREA_ID CLASSIFICATION_HIER_ SERVICE_COST_SUMMARY_FACT_HZ. EQUIPMNT HZ _ID = CLASSIFICATION_HIER_HZ. INTERNAL_CLASS_ID AND CLASSIFICATION_HIER_HZ. CLASS_TYPE_ID = '002' CLASSIFICATION_HIER_ SERVICE_COST_SUMMARY_FACT_HZ. FUNCTNL_ HZ LOCATN_ID =CLASSIFICATION_HIER_HZ. INTERNAL_CLASS_I D and CLASSIFICATION_HIER_HZ. CLASS_TYPE_ID = '003' CLASSIFICATION_HIER_ SERVICE_COST_SUMMARY_FACT_HZ. EQUIPMNT VR _ID = CLASSIFICATION_HIER_VR. CHILD_ID AND CLASSIFICATION_HIER_VR. CLASS_TYPE_ID = '002' CLASSIFICATION_HIER_ SERVICE_COST_SUMMARY_FACT_HZ. FUNCTNL_ VR LOCATN_ID =CLASSIFICATION_HIER_VR. CHILD_ID and CLASSIFICATION_HIER_VR. CLASS_TYPE_ID = '003' COMPANY_CODE CONTROLLING_AREA COST_CENTER COMPANY_CODE. CMPNY_CODE_ID=SERVICE_C OST_SUMMARY_FACT_HZ. CMPNY_CODE_ID CONTROLLING_AREA. CTRL_AREA_ID=SERVICE_ COST_SUMMARY_FACT_HZ. CTRL_AREA_ID SERVICE_COST_SUMMARY_FACT_HZ. COST_CN TR_ID=COST_CENTER. COST_CNTR_ID and SERVICE_COST_SUMMARY_FACT_HZ. CTRL_ARE A_ID=COST_CENTER. CTRL_AREA_ID SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ COST_CENTER_HIER_H SERVICE_COST_SUMMARY_FACT_HZ. CTRL_ARE Z A_ID=COST_CENTER_HIER_HZ. CTRL_AREA_ID and SERVICE_COST_SUMMARY_FACT_HZ. COST_CN TR_ID=COST_CENTER_HIER_HZ. COST_CNTR_ID COST_CENTER_HIER_V SERVICE_COST_SUMMARY_FACT_HZ. CTRL_ARE R A_ID=COST_CENTER_HIER_VR. CTRL_AREA_ID and SERVICE_COST_SUMMARY_FACT_HZ. COST_CN TR_ID=COST_CENTER_HIER_VR. CHILD_ID CURRENCY CURRENCY CURRENCY. CURR_ID=SERVICE_COST_SUMMAR Y_FACT_HZ. CURR_ID_CTRL_AREA CURRENCY. CURR_ID=SERVICE_COST_SUMMAR Y_FACT_HZ. CURR_ID_LOC SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ 128 SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2 for SAP solutions Business Guide Reports Service Order Cost 4 Fact Table SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ Dimension Table CURRENCY DOCUMENT_CATEGOR Y Join Expression CURRENCY. CURR_ID=SERVICE_COST_SUMMAR Y_FACT_HZ. CURR_ID_TRX DOCUMENT_CATEGORY. DOC_CATEG_ID = SERVICE_COST_SUMMARY_FACT_HZ. DOC_CAT EG_ID and DOCUMENT_CATEGORY. DIM_SRC_ID = 'INT_ORDER' DOCUMENT_TYPE. DOC_CATEG_ID=SERVICE_CO ST_SUMMARY_FACT_HZ. DOC_CATEG_ID AND DOCUMENT_TYPE. DOC_TYPE_ID=SERVICE_COS T_SUMMARY_FACT_HZ. DOC_TYPE_ID AND DOCUMENT_TYPE. DIM_SRC_ID = 'INT_ORDER' SERVICE_COST_SUMMARY_FACT_HZ. EQUIPMNT _ID=EQUIPMENT. EQUIPMNT_ID SERVICE_COST_SUMMARY_FACT_HZ. EQUIPMNT _ID=EQUIPMENT_HIER_HZ. EQUIPMNT_ID SERVICE_COST_SUMMARY_FACT_HZ. EQUIPMNT _ID=EQUIPMENT_HIER_VR. CHILD_ID SERVICE_COST_SUMMARY_FACT_HZ. RECORD_ CATEG_ID=FINANCIAL_RECORD_CATEGORY. RE CORD_CATEG_ID SERVICE_COST_SUMMARY_FACT_HZ. RECORD_ TYPE_ID=FINANCIAL_RECORD_TYPE. RECORD_T YPE_ID and FINANCIAL_RECORD_TYPE. RECORD_TYPE_ID = 'COST' SERVICE_COST_SUMMARY_FACT_HZ. FUNCTNL_ AREA_ID=FUNCTIONAL_AREA. FUNCTNL_AREA_I D SERVICE_COST_SUMMARY_FACT_HZ. FUNCTNL_ AREA_ID=FUNCTIONAL_AREA_HIER_HZ. FUNCTN L_AREA_ID SERVICE_COST_SUMMARY_FACT_HZ. FUNCTNL_ AREA_ID=FUNCTIONAL_AREA_HIER_VR. CHILD_I D SERVICE_COST_SUMMARY_FACT_HZ. FUNCTNL_ LOCATN_ID=FUNCTIONAL_LOCATION. FUNCTNL_ LOCATN_ID SERVICE_COST_SUMMARY_FACT_HZ. FUNCTNL_ LOCATN_ID=FUNCTIONAL_LOCATION_HIER_HZ. F UNCTNL_LOCATN_ID SERVICE_COST_SUMMARY_FACT_HZ. FUNCTNL_ LOCATN_ID=FUNCTIONAL_LOCATION_HIER_VR. CHILD_ID SERVICE_COST_SUMMARY_FACT_HZ. INTERNAL _ORDER_ID=INTERNAL_ORDER. INTERNAL_ORD ER_ID SERVICE_COST_SUMMARY_FACT_HZ. INTERNAL _ORDER_ID=INTERNAL_ORDER_HIER_HZ. INTER NAL_ORDER_ID SERVICE_COST_SUMM ARY_FACT_HZ DOCUMENT_TYPE SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ EQUIPMENT EQUIPMENT_HIER_HZ EQUIPMENT_HIER_VR FINANCIAL_RECORD_C ATEGORY FINANCIAL_RECORD_T YPE SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ FUNCTIONAL_AREA FUNCTIONAL_AREA_HI ER_HZ FUNCTIONAL_AREA_HI ER_VR FUNCTIONAL_LOCATIO N FUNCTIONAL_LOCATIO N_HIER_HZ FUNCTIONAL_LOCATIO N_HIER_VR INTERNAL_ORDER INTERNAL_ORDER_HIE R_HZ SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2 for SAP solutions Business Guide 129 4 Reports Service Order Cost Fact Table SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ Dimension Table INTERNAL_ORDER_HIE R_VR Join Expression SERVICE_COST_SUMMARY_FACT_HZ. INTERNAL _ORDER_ID=INTERNAL_ORDER_HIER_VR. CHILD _ID MAINTENANCE_ACTIVIT SERVICE_COST_SUMMARY_FACT_HZ. MAINT_AC Y_TYPE TIVITY_TYPE_ID=MAINTENANCE_ACTIVITY_TYPE . MAINT_ACTIVITY_TYPE_ID MAINTENANCE_PRIORI TY SERVICE_COST_SUMMARY_FACT_HZ. PRIORITY_ TYPE_ID=MAINTENANCE_PRIORITY. PRIORITY_T YPE_ID and SERVICE_COST_SUMMARY_FACT_HZ. PRIORITY_ ID=MAINTENANCE_PRIORITY. PRIORITY_ID SERVICE_COST_SUMMARY_FACT_HZ. MATERIAL _ID=MATERIAL. MATERIAL_ID SERVICE_COST_SUMMARY_FACT_HZ. MATERIAL _ID=MATERIAL_BY_PLANT. MATERIAL_ID and SERVICE_COST_SUMMARY_FACT_HZ. PLANT_ID =MATERIAL_BY_PLANT. PLANT_ID PLANT. PLANT_ID=SERVICE_COST_SUMMARY_FA CT_HZ. PLANT_ID PLANT_LOCATION. PLANT_ID=SERVICE_COST_S UMMARY_FACT_HZ. PLANT_ID and PLANT_LOCATION. LOCATN_ID=SERVICE_COST_ SUMMARY_FACT_HZ. LOCATN_ID SERVICE_COST_SUMMARY_FACT_HZ. PROD_HIE R_ID=PRODUCT_HIERARCHY. PROD_HIER_ID SERVICE_COST_SUMMARY_FACT_HZ. CTRL_ARE A_ID=PROFIT_CENTER. CTRL_AREA_ID and SERVICE_COST_SUMMARY_FACT_HZ. PROFIT_C NTR_ID=PROFIT_CENTER. PROFIT_CNTR_ID SERVICE_COST_SUMMARY_FACT_HZ. CTRL_ARE A_ID=PROFIT_CENTER_HIER_HZ. CTRL_AREA_ID and SERVICE_COST_SUMMARY_FACT_HZ. PROFIT_C NTR_ID=PROFIT_CENTER_HIER_HZ. PROFIT_CNT R_ID SERVICE_COST_SUMMARY_FACT_HZ. CTRL_ARE A_ID=PROFIT_CENTER_HIER_VR. CTRL_AREA_ID and SERVICE_COST_SUMMARY_FACT_HZ. PROFIT_C NTR_ID=PROFIT_CENTER_HIER_VR. CHILD_ID SERVICE_COST_SUMMARY_FACT_HZ. PROJ_ELE M_ID=PROJECT_ELEMENT. PROJ_ELEM_ID SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ MATERIAL MATERIAL_BY_PLANT SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ PLANT PLANT_LOCATION SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ PRODUCT_HIERARCHY PROFIT_CENTER SERVICE_COST_SUMM ARY_FACT_HZ PROFIT_CENTER_HIER _HZ SERVICE_COST_SUMM ARY_FACT_HZ PROFIT_CENTER_HIER _VR SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ PROJECT_ELEMENT PROJECT_ELEMENT_HI SERVICE_COST_SUMMARY_FACT_HZ. PROJ_ELE ER_HZ M_ID=PROJECT_ELEMENT_HIER_HZ. PROJ_ELE M_ID PROJECT_ELEMENT_HI SERVICE_COST_SUMMARY_FACT_HZ. PROJ_ELE ER_VR M_ID=PROJECT_ELEMENT_HIER_VR. CHILD_ID 130 SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2 for SAP solutions Business Guide Reports Service Order Cost 4 Fact Table SERVICE_COST_SUMM ARY_FACT_HZ Dimension Table SERVICE_COST_SUMM ARY_FACT_HZ Join Expression SERVICE_COST_SUMMARY_FACT_HZ. FISC_YEA R= SERVICE_COST_SUMMARY_FACT_HZ. PARTITION _YEAR SERVICE_COST_SUMMARY_FACT_HZ. SYSTEM_ CONDITN_ID=SYSTEM_CONDITION. SYSTEM_CO NDITN_ID VARIANCE_CATEGORY. VARIANCE_CATEG_ID=SE RVICE_COST_SUMMARY_FACT_HZ. VARIANCE_C ATEG_ID SERVICE_COST_SUMMARY_FACT_HZ. WORK_CN TR_ID=WORK_CENTER. WORK_CNTR_ID AND SERVICE_COST_SUMMARY_FACT_HZ. PLANT_ID = WORK_CENTER. PLANT_ID SERVICE_COST_SUMMARY_FACT_HZ. WORK_CN TR_ID=WORK_CENTER_HIER_HZ. WORK_CNTR_I D AND SERVICE_COST_SUMMARY_FACT_HZ. PLANT_ID =WORK_CENTER_HIER_HZ. PLANT_ID SERVICE_COST_SUMMARY_FACT_HZ. WORK_CN TR_ID=WORK_CENTER_HIER_VR. CHILD_ID AND SERVICE_COST_SUMMARY_FACT_HZ. PLANT_ID =WORK_CENTER_HIER_VR. PLANT_ID BUSINESS_ACTIVITY. BUS_ACTIVITY_ID=SERVICE _COST_SUMMARY_FACT_VR. BUS_ACTIVITY_ID BUSINESS_AREA. BUS_AREA_ID=SERVICE_COST _SUMMARY_FACT_VR. BUS_AREA_ID SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SERVICE_COST_SUMM ARY_FACT_HZ SYSTEM_CONDITION VARIANCE_CATEGORY WORK_CENTER SERVICE_COST_SUMM ARY_FACT_HZ WORK_CENTER_HIER_ HZ SERVICE_COST_SUMM ARY_FACT_HZ WORK_CENTER_HIER_ VR SERVICE_COST_SUMM ARY_FACT_VR SERVICE_COST_SUMM ARY_FACT_VR SERVICE_COST_SUMM ARY_FACT_VR BUSINESS_ACTIVITY BUSINESS_AREA CLASSIFICATION_HIER_ SERVICE_COST_SUMMARY_FACT_VR. EQUIPMN HZ T_ID = CLASSIFICATION_HIER_HZ. INTERNAL_CLASS_ID AND CLASSIFICATION_HIER_HZ. CLASS_TYPE_ID = '002' CLASSIFICATION_HIER_ SERVICE_COST_SUMMARY_FACT_VR. FUNCTNL_ HZ LOCATN_ID =CLASSIFICATION_HIER_HZ. INTERNAL_CLASS_I D and CLASSIFICATION_HIER_HZ. CLASS_TYPE_ID = '003' CLASSIFICATION_HIER_ SERVICE_COST_SUMMARY_FACT_VR. EQUIPMN VR T_ID = CLASSIFICATION_HIER_VR. CHILD_ID AND CLASSIFICATION_HIER_VR. CLASS_TYPE_ID = '002' CLASSIFICATION_HIER_ SERVICE_COST_SUMMARY_FACT_VR. FUNCTNL_ VR LOCATN_ID =CLASSIFICATION_HIER_VR. CHILD_ID and CLASSIFICATION_HIER_VR. CLASS_TYPE_ID = '003' COMPANY_CODE COMPANY_CODE. CMPNY_CODE_ID=SERVICE_C OST_SUMMARY_FACT_VR. CMPNY_CODE_ID SERVICE_COST_SUMM ARY_FACT_VR SERVICE_COST_SUMM ARY_FACT_VR SERVICE_COST_SUMM ARY_FACT_VR SERVICE_COST_SUMM ARY_FACT_VR SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2 for SAP solutions Business Guide 131 4 Reports Service Order Cost Fact Table SERVICE_COST_SUMM ARY_FACT_VR SERVICE_COST_SUMM ARY_FACT_VR Dimension Table CONTROLLING_AREA COST_CENTER Join Expression CONTROLLING_AREA. CTRL_AREA_ID=SERVICE_ COST_SUMMARY_FACT_VR. CTRL_AREA_ID SERVICE_COST_SUMMARY_FACT_VR. COST_CN TR_ID=COST_CENTER. COST_CNTR_ID and SERVICE_COST_SUMMARY_FACT_VR. CTRL_ARE A_ID=COST_CENTER. CTRL_AREA_ID SERVICE_COST_SUMM ARY_FACT_VR COST_CENTER_HIER_H SERVICE_COST_SUMMARY_FACT_VR. CTRL_ARE Z A_ID=COST_CENTER_HIER_HZ. CTRL_AREA_ID and SERVICE_COST_SUMMARY_FACT_VR. COST_CN TR_ID=COST_CENTER_HIER_HZ. COST_CNTR_ID COST_CENTER_HIER_V SERVICE_COST_SUMMARY_FACT_VR. CTRL_ARE R A_ID=COST_CENTER_HIER_VR. CTRL_AREA_ID and SERVICE_COST_SUMMARY_FACT_VR. COST_CN TR_ID=COST_CENTER_HIER_VR. CHILD_ID CURRENCY CURRENCY CURRENCY DOCUMENT_CATEGOR Y CURRENCY. CURR_ID=SERVICE_COST_SUMMAR Y_FACT_VR. CURR_ID_CTRL_AREA CURRENCY. CURR_ID=SERVICE_COST_SUMMAR Y_FACT_VR. CURR_ID_LOC CURRENCY. CURR_ID=SERVICE_COST_SUMMAR Y_FACT_VR. CURR_ID_TRX DOCUMENT_CATEGORY. DOC_CATEG_ID = SERVICE_COST_SUMMARY_FACT_VR. DOC_CAT EG_ID and DOCUMENT_CATEGORY. DIM_SRC_ID = 'INT_ORDER' DOCUMENT_TYPE. DOC_CATEG_ID=SERVICE_CO ST_SUMMARY_FACT_VR. DOC_CATEG_ID AND DOCUMENT_TYPE. DOC_TYPE_ID=SERVICE_COS T_SUMMARY_FACT_VR. DOC_TYPE_ID AND DOCUMENT_TYPE. DIM_SRC_ID = 'INT_ORDER' SERVICE_COST_SUMMARY_FACT_VR. EQUIPMN T_ID=EQUIPMENT. EQUIPMNT_ID SERVICE_COST_SUMMARY_FACT_VR. EQUIPMN T_ID=EQUIPMENT_HIER_HZ. EQUIPMNT_ID SERVICE_COST_SUMMARY_FACT_VR. EQUIPMN T_ID=EQUIPMENT_HIER_VR. CHILD_ID SERVICE_COST_SUMMARY_FACT_VR. RECORD_ CATEG_ID=FINANCIAL_RECORD_CATEGORY. RE CORD_CATEG_ID SERVICE_COST_SUMMARY_FACT_VR. RECORD_ TYPE_ID=FINANCIAL_RECORD_TYPE. RECORD_T YPE_ID and FINANCIAL_RECORD_TYPE. RECORD_TYPE_ID = 'COST' SERVICE_COST_SUMM ARY_FACT_VR SERVICE_COST_SUMM ARY_FACT_VR SERVICE_COST_SUMM ARY_FACT_VR SERVICE_COST_SUMM ARY_FACT_VR SERVICE_COST_SUMM ARY_FACT_VR SERVICE_COST_SUMM ARY_FACT_VR DOCUMENT_TYPE SERVICE_COST_SUMM ARY_FACT_VR SERVICE_COST_SUMM ARY_FACT_VR SERVICE_COST_SUMM ARY_FACT_VR SERVICE_COST_SUMM ARY_FACT_VR SERVICE_COST_SUMM ARY_FACT_VR EQUIPMENT EQUIPMENT_HIER_HZ EQUIPMENT_HIER_VR FINANCIAL_RECORD_C ATEGORY FINANCIAL_RECORD_T YPE 132 SAP BusinessObjects Plant Maintenance Rapid Mart XI 3. 2 for SAP solutions Business Guide Reports Service Order Cost 4 Fact Table SERVICE_COST_SUMM ARY_FACT_VR Dimension Table FISC_PERIOD Join Expression FISC_PERIOD. FISC_YEAR=SERVICE_COST_SUM MARY_FACT_VR. FISC_YEAR and FISC_PERIOD. FISC_PERIOD=SERVICE_COST_SU MMARY_FACT_VR. FISC_PERIOD and FISC_PERIOD. FISC_YR_VARIANT_ID=SERVICE_C OST_SUMMARY_FACT_VR. FISC_YR_VARIANT_ID SERVICE_COST_SUMMARY_FACT_VR. FUNCTNL_ AREA_ID=FUNCTIONAL_AREA. FUNCTNL_AREA_I D SERVICE_COST_SUMMARY_FACT_VR. FUNCTNL_ AREA_ID=FUNCTIONAL_AREA_HIER_HZ. FUNCTN L_AREA_ID SERVICE_COST_SUMMARY_FACT_VR. FUNCTNL_ AREA_ID=FUNCTIONAL_AREA_HIER_VR. CHILD_I D SERVICE_COST_SUMMARY_FACT_VR. FUNCTNL_ LOCATN_ID=FUNCTIONAL_LOCATION. FUNCTNL_ LOCATN_ID SERVICE_COST_SUMMARY_FACT_VR. FUNCTNL_ LOCATN_ID=FUNCTIONAL_LOCATION_HIER_HZ. F UNCTNL_LOCATN_ID SERVICE_COST_SUMMARY_FACT_VR. FUNCTNL_ LOCATN_ID=FUNCTIONAL_LOCATION_HIER_VR. [. . . ]