User manual BUSINESS OBJECTS PROJECT SYSTEMS RAPID MART XI 3.2 FOR SAP SOLUTIONS 12.2.0.0

[. . . ] SAP BusinessObjects Project Systems Rapid Mart XI 3. 2, version for SAP solutions - User 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. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. Trademarks All rights reserved. SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. [. . . ] Change all occurrences of data type VARGRAPHIC to VARCHAR before creating tables. 2. SAP BusinessObjects Project Systems Rapid Mart XI 3. 2 for SAP solutions User Guide 239 6 Installing the Rapid Mart Install the Rapid Mart Target Schema 3. If your target database is DB2 with Code Set UTF-8 (with multi-byte character support), you do not need to make changes to SAP_Create_Tables. sql script. If your target database is DB2, regardless of Code Set, you must have at least one tablespace with page size = 8 Kilobytes to accommodate column size (table width) on some tables. The tables affected by this are: 4. · · · · · COST_CENTER_HIER_HZ FUNCTIONAL_AREA_HIER_HZ GL_ACCOUNT_HIER_HZ PROFIT_CENTER_HIER_HZ PROJECT_ELEMENT_HIER_HZ Create Target Indexes Creating indexes is optional. We highly recommend that the DBAs first review the indexes and decide which indexes should be created to ensure proper performance for both ETL process and reporting query responses. In the appropriate target database directory locate the files: · · SAP_Create_Indexes_All. sql SAP_Create_Indexes_Performance. sql The first script includes all indexes for all tables in the data model. The second script is a subset of indexes (from SAP_Create_Indexes_All. sql) tuned for performance in our internal SAP BusinessObjects development environment. This includes optimization for both Data Services load performance and reporting performance. For a quick start, we suggest starting with the SAP_Create_Indexes_Performance. sql file, and then creating / dropping indexes as needed in your environment. Note: Use the results of Performance Tuning analysis to guide you in the process of: · · · selecting indexes to create allocating storage space allocating physical disk You may want to modify the index creation scripts to include these parameters before execution. 240 SAP BusinessObjects Project Systems Rapid Mart XI 3. 2 for SAP solutions User Guide Installing the Rapid Mart Install the Rapid Mart Target Schema 6 Create Dummy Procedures The Rapid Mart contains 2 templates or "dummy" database procedures. See Rapid Mart Deployment Guideline. pdf for more details on how to use these procedures. One procedure is called before each fact table load in the Rapid Mart, and the other after the fact table is loaded. The procedures need to be installed for the Data Services jobs to run. Locate the file: · Create_Dummy_Maintenance_SP. sql Execute this file in your target database environment to create the dummy procedures. For example, the first procedure could be modified to drop secondary (foreign key) indexes on the fact table before a load. The other, could be modified to re-create these indexes (for query performance) at the end of the load. The Rapid Mart contains an example (File Create_Sample_Maintenance_SP. sql in the Sample directory) of how to do this with an Oracle target database. Dropping Tables, Procedures and Indexes Use these scripts as needed to drop tables, procedures, views, and indexes. When starting with an empty target database / schema, they are not required for installation. They are provided to ensure a complete DDL (Data Definition Language) package for each target database. · Drop_Dummy_Maintenance_SP. sql Note: The Oracle version of Create_Dummy_Maintenance_SP. sql uses Oracle's "create or replace" syntax. Thus, no drop script is provided for Oracle. · · · SAP_Drop_Indexes_All. sql SAP_Drop_Indexes_Performance. sql SAP_Drop_Tables. sql SAP BusinessObjects Project Systems Rapid Mart XI 3. 2 for SAP solutions User Guide 241 6 Installing the Rapid Mart Install the Data Services Job(s) Install the Data Services Job(s) This section deals with the installation of the Rapid Mart jobs using Data Services Designer. Installation of reporting content is covered in "Installing Rapid Mart Reporting Content" on page 260. The ETL subdirectory for the Rapid Mart package contains the ATL file. ATL files are specific to each Rapid Mart and follow the naming convention · · (RM_ABBR)_Rapid_Mart. atl SAPPS_Rapid_Mart. atl Example: The Project Systems Rapid Mart ATL file is named: Renaming the Data Stores This step is optional. [. . . ] Calculated as difference between latest end date and earliest start date(UOM_ID = TAG in DECIMAL IDES) Min Number of Days for Network Relationship. Calculated as difference between earliest end DECIMAL date and latest start date(UOM_ID = TAG in IDES) AFFH. LOEKZ - Deletion indicator (1/0) Dimension Source. This is a combined dimension combining different varieties of "Reference Date Key" from different sources. This is a combined dimension combining different varieties of "object type" from different sources. [. . . ]