User manual BUSINESS OBJECTS ACCOUNTS RECEIVABLE RAPID MART 11.5.4.0
DON'T FORGET : ALWAYS READ THE USER GUIDE BEFORE BUYING !!!
If this document matches the user guide, instructions manual or user manual, feature sets, schematics you are looking for, download it now. Diplodocs provides you a fast and easy access to the user manual BUSINESS OBJECTS ACCOUNTS RECEIVABLE RAPID MART 11.5.4.0. We hope that this BUSINESS OBJECTS ACCOUNTS RECEIVABLE RAPID MART 11.5.4.0 user guide will be useful to you.
You may also download the following manuals related to this product:
BUSINESS OBJECTS ACCOUNTS RECEIVABLE RAPID MART 11.5.4.0 BUSINESS GUIDE (640 ko)
Manual abstract: user guide BUSINESS OBJECTS ACCOUNTS RECEIVABLE RAPID MART 11.5.4.0
Detailed instructions for use are in the User's Guide.
[. . . ] 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. [. . . ]
DISCLAIMER TO DOWNLOAD THE USER GUIDE BUSINESS OBJECTS ACCOUNTS RECEIVABLE RAPID MART 11.5.4.0
Click on "Download the user Manual" at the end of this Contract if you accept its terms, the downloading of the manual BUSINESS OBJECTS ACCOUNTS RECEIVABLE RAPID MART 11.5.4.0 will begin.