User manual BUSINESS OBJECTS ACCOUNTS RECEIVABLE RAPID MART 11.5.4.0

[. . . ] BusinessObjects Accounts Receivable Rapid Mart User's Guide Version 11. 5. 4. 0 Patents Business Objects owns the following U. S. patents, which may cover products that are offered and sold by Business Objects: 5, 555, 403, 6, 247, 008 B1, 6, 578, 027 B2, 6, 490, 593 and 6, 289, 352. Business Objects, the Business Objects logo, Crystal Reports, and Crystal Enterprise are trademarks or registered trademarks of Business Objects SA or its affiliated companies in the United States and other countries. All other names mentioned herein may be trademarks of their respective owners. [. . . ] The view was created so that we can obtain the open Accounts Receivable balance for a customer. The SQL to create this view is included with the target schema for the Rapid Mart in the SQL source file: AR_Create_Tables. sql For performance reasons, you may decide to create an aggregated fact table to replace the view. 100 BusinessObjects Accounts Receivable Rapid Mart User's Guide Universe Customizing the Universe 5 1. Create a fact table CUST_ITEMS_AR_BALANCE_FACT with the same columns included in the view. Make sure the columns have the same data types as their source columns in CUST_ITEMS_FACT table. In the Data Integrator job for the Rapid Mart, create a dataflow that runs immediately after the CUST_ITEMS_FACT table is populated. The new dataflow populates CUST_ITEMS_AR_BALANCE_FACT using the same logic used to create the view in SQL source file: AR_Create_Tables. sql In the Universe, replace CUST_ITEMS_AR_BALANCE_VIEW with CUST_ITEMS_AR_BALANCE_FACT, preserving the join to the CUST_PER_TTL_FACT_VR table. There are several objects in the Universe that need to be repointed from the view to the new fact table (highlighted below): 2. 3. 4. BusinessObjects Accounts Receivable Rapid Mart User's Guide 101 5 Universe Customizing the Universe 5. Save and export the universe. 102 BusinessObjects Accounts Receivable Rapid Mart User's Guide Universe Universe Validation 5 Universe Validation When validating the universe within the Universe Designer, some errors are expected and acceptable. They are detailed below. Unlinked Tables There are 6 tables that are not joined to other tables. However, the original table must remain as a placeholder for the original table name. They are shown below. Object Parsing There are 39 objects that will fail validation. They are all template objects that must be customized to your specific needs. BusinessObjects Accounts Receivable Rapid Mart User's Guide 103 5 Universe Universe Validation The remaining objects fail because they use the "@database" function, but will execute correctly in reports. Also, note that the error messages are specific to your database server. Thus Oracle, SQL-Server, and DB2 will have different messages for the same errors. The screen-shot below shows the object parsing failures in an Oracle environment. 104 BusinessObjects Accounts Receivable Rapid Mart User's Guide Universe Universe Validation 5 Cardinality There is one cardinality error in the join between CUST_PER_TTL_FACT_VR and CUST_ITEMS_AR_BALANCE_VIEW. The error is shown below: BusinessObjects Accounts Receivable Rapid Mart User's Guide 105 5 Universe Universe Validation 106 BusinessObjects Accounts Receivable Rapid Mart User's Guide BusinessObjects Accounts Receivable Rapid Mart User's Guide Installing the Rapid Mart chapter 6 Installing the Rapid Mart Overview Overview This chapter contains the information you need to install the BusinessObjects Accounts Receivable Rapid Mart. The information in this chapter is useful for system administrators or others who install the Rapid Mart. This chapter contains the following sections: · System prerequisites · Rapid Mart product components · Preparing your environment · Installation overview · Installation procedure · Completing the installation · Installing Rapid Mart Reporting Content System prerequisites To run the BusinessObjects Accounts Receivable Rapid Mart, your system requires: · Data Integrator version 11. 5. 2 or higher compatible version · An Oracle 9i database or Microsoft SQL Server or IBM DB2 UDB 8 database or compatible version. · SAP release 3. 1H or higher compatible version · BusinessObjects Enterprise XIR2 if you want to install Rapid Mart Reporting Content. If you have questions about system prerequisites, contact Business Objects Technical Support. Rapid Mart product components The Rapid Mart includes several major product components: · A SQL script for defining the Rapid Mart tables · A SQL script for dropping the Rapid Mart tables · An Data Integrator metadata repository that specifies the full load and incremental update jobs for the following: · Data extract from SAP · Data load into the Rapid Mart · SQL scripts to drop and re-create indexes after loading the Rapid Mart 108 BusinessObjects Accounts Receivable Rapid Mart User's Guide Installing the Rapid Mart Preparing your environment 6 · · · · SQL scripts to create database stored procedures. Dummy procedures are created during installation and procedure samples (for oracle only) are available in Sample\DDL directory. An ERWin diagram of the data schema Set of documents which includes business guide, user guide and release notes An option to install rapid mart reporting contents that includes BusinessObjects Enterprise XIR2 WebIntelligence reports and a universe. See "Installing Rapid Mart Reporting Content" on page 115 for details. Preparing your environment Follow these steps to prepare your environment for the Rapid Mart installation: 1. Refer to the Data Integrator Getting Started Guide for detailed installation instructions. [. . . ] Expand the Rapid Mart to be used with various integrated query, reporting, and data analysis applications. Transport Rapid Mart components and sections to different Rapid Marts using the Data Integrator export and import facilities. Change column names to be more meaningful in your business environment. Remove columns or tables you do not need in your business environment. [. . . ]