SAP BusinessObjects Cost Center Rapid 3.2 User Manual

Download

SAP BusinessObjects Cost Center Rapid Mart XI 3.2, version for SAP solutions User Guide

Version 12.2.2.0

October 2009

Trademarks

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.

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.

Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the United States and in other countries. Business Objects is an SAP company.

All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary.

These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

Chapter 1 Introduction 9

What is a Rapid Mart? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10

Rapid Marts packages accelerate Time to Value . . . . . . . . . . . . . . . . 11

SAP BusinessObjects Rapid Marts packages architecture . . . . . . . . . 12

About this document . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14

Chapter 2 Overview 15

What you can do with this Rapid Mart . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16

Supported analyses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19

Dimensions available to support these analyses . . . . . . . . . . . . . . . . . 21

Related Rapid Marts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23

Fitting into the accounting process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24

SAP BusinessObjects Cost Center Rapid Mart Schema . . . . . . . . . . . . . . 26

Chapter 3 Rapid Mart Subject Areas 29

Cost Analysis Basics . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30

Cost Objects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31

Financial Organization Structure . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34

Cost Elements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35

Profit Centers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35

Projects . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36

Vendors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36

Accounting Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37

Cost Transaction Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38

Rapid Mart Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38

Rapid Mart Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41

Cost Summary Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44

Rapid Mart Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44

Rapid Mart Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 3

Contents

Profit Center Detail Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .53

Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .53

Rapid Mart Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .54

Rapid Mart Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58

Profit Center Summary Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .59

Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .59

Rapid Mart Processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .60

Rapid Mart Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65

General Ledger Account Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . .66

Chapter 4 Reports 69

Cost Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .70

Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .70

Recommended Table Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74

Cost Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .77

Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .77

Recommended Table Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91

Profit Center Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .97

Profit Center Details - Horizontal . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .97

Profit Center Details - Vertical . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .100

Recommended Table Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103

Profit Center Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .110

Profit Center Summary - Horizontal . . . . . . . . . . . . . . . . . . . . . . . . . .111

Profit Center Summary - Vertical . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113

Recommended Table Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123

SAP Master Data Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 128

Data Discovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .128

Data Auditing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .141

Recommended table joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .142

Chapter 5 Universe 147

Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148

Universe Design Principles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .148

4 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Contents

Universe Terminology . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149

Universe Table Layout . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151

Join Strategy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151

Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153

Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153

Hierarchies Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153

Geographic Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155

Time Dimension and Fiscal Period Hierarchies . . . . . . . . . . . . . . . . . 155

Material Product Hierarchy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155

Horizontal & Vertical Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . 156

Hierarchy Filters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162

Cost Center Specific Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167

Cost Center Universe . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167

Universe Objects & Classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 168

Common Dimensions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170

Cost Details Subject Area . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 178

Cost Summary Subject Area . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 181

Invalid Cost Center Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 190

Filters & Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 190

Universe Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 191

SAP Profit Center Universe . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 192

Universe Objects & Classes - Profit Center . . . . . . . . . . . . . . . . . . . . 193

Common Dimensions - Profit Center . . . . . . . . . . . . . . . . . . . . . . . . . 195

Profit Center Detail Subject Area . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204

Profit Center Summary Subject Area . . . . . . . . . . . . . . . . . . . . . . . . . 208

Income Statement Setup Subject Area . . . . . . . . . . . . . . . . . . . . . . . 215

Universe Filters - Profit Center . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 217

Universe Validation - Profit Center . . . . . . . . . . . . . . . . . . . . . . . . . . . 218

Universe Objects & Classes - Master Data . . . . . . . . . . . . . . . . . . . . 220

Universe Validation - Master Data . . . . . . . . . . . . . . . . . . . . . . . . . . . 255

Chapter 6 Installing the Rapid Mart 259

Preparing Data Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 265

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 5

Contents

Preparing Target Database Environment . . . . . . . . . . . . . . . . . . . . . .265

Preparing Source Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .266

Preparing BusinessObjects Enterprise . . . . . . . . . . . . . . . . . . . . . . . . 266

Performance Tuning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .266

Create Target Schema . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .269

Renaming the Data Stores . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .272

Import ATL File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .274

Adjusting the Data Stores . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 276

Using Auxiliary Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .283

Using ABAP Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .284

Final Steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .288

Import Wizard for Reporting Content BIAR File . . . . . . . . . . . . . . . . .290

Creating Universe Connection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .306

Additional Post-Installation Steps . . . . . . . . . . . . . . . . . . . . . . . . . . . .308

Chapter 7 Using the Rapid Mart 311

Recovery framework . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 312

Data Services automatic recovery feature . . . . . . . . . . . . . . . . . . . . .312

Rapid Mart recovery framework . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 313

Execution status framework . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .314

The execution status table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .314

The execution status API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .315

Executing a job with the Reset option . . . . . . . . . . . . . . . . . . . . . . . . . 316

Extraction, transformation and loading process . . . . . . . . . . . . . . . . . . . .316

Global Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .318

Global Variable Cross-Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . 318

Used in All Rapid Marts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .322

Used in 2 to 10 Rapid Marts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .325

Used in Only 1 Rapid Mart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 331

Setting Global Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .345

Executing the job . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .349

Initial (First) Extraction and Load . . . . . . . . . . . . . . . . . . . . . . . . . . . . 349

Incremental (Delta) Extraction and Load . . . . . . . . . . . . . . . . . . . . . . .350

6 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Contents

Customizing the Rapid Mart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 351

Performance Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353

Customizations for the Rapid Mart . . . . . . . . . . . . . . . . . . . . . . . . . . . 354

Chapter 8 Technical Implementation 359

Cost Transactions Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 360

Dimension table load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 360

Initial or incremental load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 364

Cost Summary Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 365

Dimensional table load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 365

Initial or incremental load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 368

Profit Center Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 368

Dimension table load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 369

Fact table load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 373

Optimization Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 388

Table Partitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 388

Data Transfer Transform . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 390

Hierarchy Optimizations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 391

Dealing with NULL values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 394

Fact Table Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 395

Fiscal Periods & Time Dim Load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 396

Chapter 9 Documentation References 399

Data Services Documentation References . . . . . . . . . . . . . . . . . . . . . . . 400

BusinessObjects Enterprise Documentation References . . . . . . . . . . . . 400

Appendix A Rapid Mart Data Schema 403

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 7

Contents

8 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Introduction

chapter

Introduction

What is a Rapid Mart?

SAP BusinessObjects Rapid Marts packages are blueprints for building data marts with SAP BusinessObjects technology:

• Data Services

• Universe Designer

• Web Intelligence.

Rapid Marts packages deliver jump-start ETL (extract, transform & load) mappings, schema, and initial reporting content, accelerating the deployment of BI (business intelligence) for enterprise applications from SAP, PeopleSoft, Oracle, and Siebel.

Each Rapid Mart is designed to address the reporting needs of a specific business area (or department) like accounting, sales, or purchasing. A component-based framework allows conducting analysis across these selected business areas by combining different packages within the same source application suite.

Rapid Marts focus on basic standard configuration of the enterprise applications. They are country and industry neutral templates meant to be easily modified and extended to suit customer specific application implementation and reporting needs.

Rapid Marts incorporate best practices, and provide easily modifiable templates. With Rapid Marts total development time of a data mart solution is greatly reduced.

Each customer situation is different. You will probably encounter one or more of these:

• Customizations you have made to SAP solutions the Rapid Mart does not

cover.

• Standard SAP solutions data fields important for your specific business,

but not included in the Rapid Mart templates.

• Optimization and performance challenges unique to your environment.

• Reporting requirements not covered within the Rapid Mart template

reports.

Rapid Marts are flexible templates that you can adjust to account for these unique situations. It is expected that some customization and optimization will be needed to suit your individual environment. Rapid Marts are not an out-ofthe-box solution.

10 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

BI tools and analytic tools can access Rapid Mart data through SQL queries. Rapid Marts can be implemented individually, or in any combination, to form a single platform that delivers the infrastructure for your company’s internal and external information needs. They can also serve as a staging area for enterprise analytic applications.

Rapid Marts provide your business with an accelerated time to value through rapid BI deployments because you can implement them quickly and easily customize them to meet specific analytic requirements.

Rapid Marts packages accelerate Time to Value

Rapid Marts are packaged data solutions that you can quickly deploy to address specific areas of business analysis.

Available Rapid Marts packages for SAP solutions include:

Financial Suite:

• SAP BusinessObjects General Ledger Rapid Mart, version for SAP

solutions

• SAP BusinessObjects Accounts Payable Rapid Mart, version for SAP

solutions

• SAP BusinessObjects Accounts Receivable Rapid Mart, version for SAP

solutions

• SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions

Operational Suite:

• SAP BusinessObjects Inventory Rapid Mart, version for SAP solutions

• SAP BusinessObjects Purchasing Rapid Mart, version for SAP solutions

• SAP BusinessObjects Sales Rapid Mart, version for SAP solutions

Manufacturing Suite:

• SAP BusinessObjects Plant Maintenance Rapid Mart, version for SAP

solutions

• SAP BusinessObjects Production Planning Rapid Mart, version for SAP

solutions

• SAP BusinessObjects Project Systems Rapid Mart, version for SAP

solutions

Human Capital Management (HCM) Suite:

• SAP BusinessObjects Human Resources Rapid Mart, version for SAP

solutions

Introduction

What is a Rapid Mart?

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 11

Introduction

What is a Rapid Mart?

You can combine multiple Rapid Marts packages into a single environment to build the foundation for your data warehouse or use them as a staging area for business intelligence applications.

SAP BusinessObjects Rapid Marts packages architecture

Rapid Marts architecture is driven by SAP BusinessObjects technology. Rapid Mart Architecture:

Rapid Marts packages include the following components:

12 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Introduction

What is a Rapid Mart?

• Data Movement Jobs - packaged source-to-target mappings and data

transformations. Each job is designed to perform initial and incremental data movement;

• Data Model & Schema - set of dat a mart database objects designed with

dimensional data modeling approach. Rapid Marts packages for SAP solutions has a single integrated data model. The schema are available for Oracle, SQL Server IBM DB2, and Teradata;

• Semantic Layer (Universes) - SAP BusinessObjects metadata packages

for efficient query generation. There can be one or more universes per Rapid Mart. Each universe is developed using Rapid Marts design principles to ensure compatibility, code readability, and component reuse. In addition, there is one Master universe for development/ maintenance of multiple use objects (like Customer, Material, Currency, etc.);

• Reports (Samples) - set of 15-20 Web Intelligence reports per Rapid

Mart. They represent answers to mostly asked business questions (for example, in the SAP BusinessObjects Sales Rapid Mart, version for SAP solutions - 'What is the monthly Revenue trend by Division for this year?'). The reports are developed using Rapid Mart color/layout templates. Reports are examples of Web Intelligence best practice development (trends, listing, guided analysis, roll ups and downs, etc.).

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 13

Introduction

About this document

This document describes the SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions. This document contains information for a variety of users—information that helps you understand the use of the Rapid Mart, the data in the Rapid Mart, the reports you can create with the Rapid Mart, and how to use and update the Rapid Mart.

This document contains the following chapters:

• Chapter 2: Overview — Describes the business problems you can solve

and the types of analyses you can do with this Rapid Mart

• Chapter 3: Rapid Mart Subject Areas — Contains detailed information

about each componentized section in the Rapid Mart, including the processes each section captures

• Chapter 4: Reports — Provides examples of reports you can produce

• Chapter 5: Universe — Describes SAP BusinessObjects Universe upon

which the reports are based

• Chapter 6: Installing the Rapid Mart — Contains the information you need

to install the Rapid Mart

• Chapter 7: Using the Rapid Mart — Describes how to execute the Rapid

Mart, including information about setting parameters and considerations you need to make when customizing the Rapid Mart

• Chapter 8: Technical Implementation — Describes each componentized

section and the work flows that run to load that section

• Chapter 9: Documentation References — Information about where to find

related to the Rapid Mart technical documentation on Data Services and BusinessObjects Enterprise

• Appendix A: Rapid Mart Data Schema — Contains a detailed list of the

tables and views in the Rapid Mart

14 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Overview

chapter

Overview

This chapter describes the business problems you can solve with the SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions and the types of analyses you can do with this Rapid Mart. The information in this chapter is useful for those who want a business-level overview of the Rapid Mart and its benefits.

This chapter includes the following topics:

• What you can do with this Rapid Mart

• Supported analyses

• Related Rapid Marts

• Fitting into the accounting process

• SAP BusinessObjects Cost Center Rapid Mart Schema

What you can do with this Rapid Mart

The SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions is designed to handle data from the controlling (CO) module of SAP solutions. The Rapid Mart enables businesses to manage and monitor expenses and meet internal accounting needs for users within management, marketing, finance, accounting, sales, and manufacturing.

The SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions addresses these sub-modules of CO:

• Cost element accounting (CO-CEL)

• Cost center accounting (CO-OM-CCA)

• Overhead (or internal) order accounting (CO-OM-OOA)

• Profit Center Accounting from the Enterprise Controlling (EC) module.

The Rapid Mart simplifies the data organization in these areas, making it easier to investigate, analyze, and report on accounting transactions and balances. Specifically, the Rapid Mart accesses the SAP solutions master data tables and transaction tables to create fact and dimension tables.

Like other Rapid Marts, the SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions is made up of several componentized sections. Each section supports a subject related to analysis of business expenses:

• Cost Transaction Section — Tracks actual primary and secondary cost

transactions for both internal and external costs at the line item level or rolled up to any dimension.

16 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Overview

What you can do with this Rapid Mart

• Cost Summary Section — Tracks planned (budgeted) and actual cost

period balances (both vertically and horizontally) by organization structure, cost object, fiscal period, and other dimensions.

In vertical format, the data is presented with one row per fiscal period. In horizontal format, the data is presented with one row per fiscal year with upto 16 fiscal periods represented on each row of data.

SAP solutions only presents the horizontal format. The vertical format is achieved in the Rapid Mart ETL process with Data Services with Hierarchy Flattening Transforms, and Pivot Transforms.

• Profit Center Accounting (EC-PCA) — Tracks planned and actual costs

and revenue by profit center, fiscal period, and other dimensions. This section sources data from the EC-PCA Standard Ledger.

Profit Center Detail transactions are categorized as either “Actuals” or “Planned” (Budget) transactions. SAP solutions segregates the data in this manner by storing the “Actuals” and “Planned” transactions in separate database tables. These tables are combined into a single fact table within the Rapid Mart to facilitate budget variance reporting

Summarized Profit Center reporting is also possible. Again, the ETL process ensures both Horizontal and Vertical representations of the data are available, with up to 16 fiscal periods represented. In addition, precalculated rolling 16 period activity summary allows analysis of various financial ratios.

Analysis across several dimensions and hierarchies is possible, including organization structure, monetary currency, fiscal period, customer, vendor, etc. The dimensions available with hierarchies available are: Material (with Product Hierarchy), Cost Element, Activity, Profit Center, Cost Center, Internal Order, Functional area, and GL Account.

Note: Profit Center Accounting, as implemented in the SAP

BusinessObjects Cost Center Rapid Mart, version for SAP solutions, is for customers using SAP solutions “Classic” GL only.

You can use Profit Center Accounting as implemented in the SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions if

• you are running SAP solutions release older than ECC 5.0. or

• you have not implemented the “New” GL module introduced in

ECC 5.0

If you are using “New” GL, use the SAP BusinessObjects General Ledger Rapid Mart, version for SAP solutions for Profit Center Accounting which covers both the “Classic” and “New” versions. The

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 17

Overview

What you can do with this Rapid Mart

Additionally , the Rapid Mart provides a series of hierarchies that are available to all sections. Hierarchies are a group of dimensions with flexible vertically and horizontally flattened accounting structures (or sets) for:

• Activities

• Cost Center

• Cost Element

• Functional Area

• GL Accounts

• Internal Orders

• Project Elements

Each of these hierarchies is in turn linked to data from the sections (Cost Summary, Cost Transaction, Profit Center Accounting).

Each of the cost hierarchies may contain records that are valid in SAP solutions but invalid for the Rapid Mart. This occurs when a node in the hierarchy is defined as both parent and child of itself. This result s in a circular dependency that cannot be resolved by the Rapid Mart.

The SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions identifies these records and loads them into separate validation tables. This allows you to correct the data in SAP solutions and then re-load the Rapid Mart.

Chapter 3: Rapid Mart Subject Areas discusses each of these sections in

more detail and describes how to link them together to form a complete cost analysis solution.

Profit Center Accounting module in the Cost Center Rapid Mart is the “Classic” version shared with the SAP BusinessObjects General Ledger Rapid Mart, version for SAP solutions.

18 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Overview

Supported analyses

The SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions supports several types of analyses.

Business function Type of analysis Measures available in the Rapid Mart

Cost Center Accounting Costs and allocations

Plan/Actual/Variance

Cost Element Accounting

Costs incurred by type

Plan/Actual/Variance

• Drill down or roll up using cost center

hierarchies

• Transaction and summary information

(fixed and variable quantities, units of measure, and values, in transaction, cost center, and controlling area currencies) for all cost centers within a reporting period

• Cost allocation trends by period by

year

• Overview of costs incurred on a cost

center or cost center hierarchy, by planned and actual values for a reporting period

• Overview of costs incurred on a cost

center or cost center hierarchy, by planned and actual values during a fiscal year or other time horizon

• Analysis of cost planning efficiency

• Drill down or roll up using cost element

hierarchies

• Overview of costs for cost centers,

internal orders and activities, by fixed and variable quantities, units of measure, and amounts in various currencies for a reporting period

• Analysis of costs incurred by planned

and actual values for a reporting period

• Analysis of cost elements rolled up by

cost center or internal order, by planned and actual values during a fiscal year or other time horizon

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 19

Overview

Supported analyses

Business function Type of analysis Measures available in the Rapid Mart

Project Element (WBS) accounting

Costs incurred by type

• Drill down or roll up using Project

Element hierarchies.

• Overview of costs by project element,

by cost element, by fixed and variable quantities, units of measure, and amounts in various currencies for a reporting period

Plan/Actual/Variance

• Analysis of costs incurred by planned

and actual values for a reporting period

• Analysis of project elements rolled up

by cost element, by planned and actual values during a fiscal year or other time horizon

Internal (Overhead) Orders

Costs and Allocations

• Drill down or roll up using internal

order hierarchies

• Transaction and summary information

(fixed and variable quantities, units of measure, and values, in transaction, cost object, and controlling area currencies) for all cost centers within a reporting period

Plan/Actual/Variance

• Overview of costs incurred on an order

or order hierarchy, by planned and actual values for a reporting period

• Overview of costs incurred on an order

or order hierarchy, by planned and actual values during a fiscal year or other time horizon

20 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Overview

Supported analyses

Business function Type of analysis Measures available in the Rapid Mart

Account Based Profitability

• Plan/Actual/Variance using cost and

revenue elements.

• Return on investment analysis

• Comparison of revenues and imputed

costs by cost and revenue elements.

Profitability Analysis Cost Based

Profitability

• Plan/Actual/Variance for revenues by

profit center based on cost of sales valuation approach.

• Drill up and down using profit center

hierarchies.

• Overhead cost trends analysis by

profit center.

Dimensions available to support these analyses

The SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions contains a number of dimension tables that use business intelligence tools to facilitate analysis. The Rapid Mart extracts these tables from SAP solutions master data and customizable tables. The tables include enterprise entities (such as controlling area, business area, company code, vendor and material data) and CO module data (such as activity, value type, controlling object and internal order information). A complete list of dimensions is presented below:

Dimension Comment

Activity & Hierarchy Horizontal and Vertical hierarchies Business Area Chart of Accounts Company Code Controlling Area Controlling Transaction Cost Center & Hierarchy Horizontal and Vertical hierarchies Cost Element & Hierarchy Horizontal and Vertical hierarchies Currency Monetary Currency Debit Credit Indicator Financial Record Type Financial Version

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 21

Overview

Supported analyses

Dimension Comment

Fiscal Period FISL Ledger Special Ledger Master Data (for

Profit Center Accounting) Functional Area & Hierarchy Horizontal and Vertical hierarchies GL Account By Company GL Account Master & Hierarchy Internal Order & Hierarchy Horizontal and Vertical hierarchies Material & Product Hierarchy Material By Plant Object Class Object Type Plant Project Project Element & Hierarchy Horizontal and Vertical hierarchies Segment Time Dimension Transaction Type Unit Of Measure Vendor

22 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Related Rapid Marts

Components of the SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions are related to other SAP BusinessObjects Rapid Mart components. For example,

• Vendor and material components are included in the Purchasing SAP

BusinessObjects Purchasing Rapid Mart, version for SAP solutions and the SAP BusinessObjects Inventory Rapid Mart, version for SAP solutions.

• The internal orders in this Rapid Mart include the production planning

orders found in the SAP BusinessObjects Production Planning Rapid Mart, version for SAP solutions.

• Profitability analysis from the revenue reported in the SAP

BusinessObjects Sales Rapid Mart, version for SAP solutions.

• Cost Based Profitability Analysis is a shared component with the SAP

BusinessObjects General Ledger Rapid Mart, version for SAP solutions. The Cost Center Rapid Mart supports SAP solutions before release ECC

5.0 (for legacy purposes). However, the SAP BusinessObjects General Ledger Rapid Mart, version for SAP solutions supports Profitability Analysis from all SAP solutions releases starting with R/3 4.6.

Each of the sections listed in “What you can do with this Rapid Mart” on

page 16 is a component. Y ou can identify a component within a Dat a Services

job by a “C_” prefix before its name. For example, the component that contains cost transactions and the associated reporting dimensions is named C_CostTransaction_Section_SAP.

Overview

Related Rapid Marts

The same components can be used in multiple Rapid Marts. For example, a component that extracts information about materials bought, produced, and

sold is needed for a Rapid Mart that supports sales analysis and also for a Rapid Mart that supports inventory analysis. Work flows that extract star schema “dimensions” are components. You can add a component to any Rapid Mart using a simple import procedure.

A Data Services job can include multiple instances of a component. For example, each section includes all the required dimension components. Therefore, a job with several sections may include several instances of a particular dimension component. Components are set to execute only once within a job. This “execute once” feature ensures that shared components do not cause duplicate data extraction from SAP solutions. For more information about the “execute once” feature, see the Data Integrator/Data Services Designer Guide.

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 23

Overview

Fitting into the accounting process

The SAP solutions Cost Accounting process consists of the following elements:

• Personnel costs

• G/L expenses

• Asset depreciation

• Billing documents

• Sales orders

• Goods issues

• Purchase orders

You can combine the sections contained in the SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions with the purchasing sections from the Purchasing Rapid Mart, the sales order section from the Sales Rapid Mart, the employee payroll section from the HR Rapid Mart, and the general

24 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Overview

Goods Issues

Sales

Orders

Cost

Summary

Personnel

Costs

G/L Expenses

Asset

Depreciation

Billing

Documents

Purchasing

Cost

Center

Purchase

Orders

Sales

Accounts

Payable

Accounts

Receivable

Cost

Transactions

Profit Center

Detail

Profit Center

Summary

Fitting into the accounting process

ledger information from the Accounts Payable and the Accounts Receivable Rapid Marts to create a comprehensive view of costs incurred by your enterprise.

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 25

Overview

SAP BusinessObjects Cost Center Rapid Mart Schema

The following diagram shows an overview of the SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions components and their relationships. The central boxes contain the fact tables corresponding to componentized sections; the smaller boxes indicate dimensional components that may apply to multiple sections.

26 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Overview

SAP BusinessObjects Cost Center Rapid Mart Schema

Additionally, the Cost Center Rapid MartContains these Hierarchies, Stage, and Auxiliary tables.

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 27

Overview

SAP BusinessObjects Cost Center Rapid Mart Schema

28 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Rapid Mart Subject Areas

chapter

Rapid Mart Subject Areas

Overview

Each section in the SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions pertains to a particular subject area. This chapter describes each section and the processes each section captures.

The information in this chapter is useful for readers who use the Rapid Mart to develop reporting solutions for SAP solutions Controlling module and need to understand the data in the Rapid Mart and how it relates to SAP solutions.

This chapter discusses:

• Cost Analysis Basics

• Cost Transaction Section

• Cost Summary Section

• Profit Center Detail Section

• Profit Center Summary Section

• General Ledger Account Hierarchies

Cost Analysis Basics

The Cost Center Rapid Mart details and processes transactional, summary, and master data obtained from cost accounting transactions, cost objects, and other areas. These include:

• Cost Objects

• Cost Centers

• Internal Orders

• Project Elements

• Activities

• Financial Organization Structure

• Cost Elements

• Profit Centers

• Projects

• Vendors

• Accounting Hierarchies

Each of these areas is detailed on the following pages.

30 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Cost Objects

Cost Centers

Rapid Mart Subject Areas

Cost Analysis Basics

WIth Cost Objects, costs are identified according to how they are incurred. They are not an accounting system as such, but rather a detailed recording of data that forms the basis for cost accounting. They are used to post accounting transactions that describe such configured entities as Activities, Internal Orders, Cost Centers, an Project Elements.

Cost Objects are mutually exclusive. That is, each Controlling transaction can refer to only one type of Cost Object. Thus, a transaction for an Internal Order, cannot also refer to a Project Element.

SAP solutions ties the various Cost Objects together with Cost Elements (a type of GL Account). Different types of Cost Objects will post to the same Cost Element. Thus, the Cost Element is used to consolidate these transactions. For more details see “Cost Elements” on page 35.

SAP solutions’s cost center accounting sub-module tracks where costs occur in your company.

Cost centers can be defined in several ways. For example, you can define each low-level organizational unit that has responsibility for managing costs as a cost center. As these organizational units incur costs, such as payroll, rent, and utilities, SAP solutions posts the costs to the unit’s cost center.

Cost centers can also be defined by functional requirement, allocation criteria, activities or services provided, geographic location, or by area of responsibility.

Initially, cost center transactions are posted by other parts of SAP solutions, such as financial accounting (FI) or materials management (MM). An assignment field in the transaction directs the costs to a cost center.

Depending on the type of cost center, some or all of a transaction’ s costs may be assigned to other cost centers or controlling objects. For example, a cafeteria provides internal services to other cost centers and might allocate its operating costs to those cost centers.

SAP solutions can allocate costs when work is completed, when other business events take place, or at the end of each accounting period. SAP solutions can allocate costs based on specific measurements, such as number of employees in a cost center or on the actual cost incurred.

In the Rapid Mart, cost elements are derived from the object number (Field COEP.OBJNR) assignment on Cost Transactions.

When object number starts with “KS” or “KL”, positions 7 - 16 of the object number are the cost element.

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 31

Rapid Mart Subject Areas

Cost Analysis Basics

Internal Orders

SAP solutions allows companies to track an internal order throughout its life cycle, from creation through the planning and posting of actual costs, up to final settlement.

SAP solutions uses internal orders to receive cost postings that track the costs associated with a particular accounting entity—be it an event, a transitional activity, or type of activity. By using internal orders, SAP solutions enables and preserves detailed information regarding the types and amount of costs that these accounting entities incur. At the end of each accounting period, SAP solutions can use the settlement function to allocate the order costs to the responsible cost center.

Internal orders can receive cost postings through various types of transactions, and can also pass costs along to other objects in CO. When an internal order receives a cost posting that adds to the cost balance it carries (such as FI postings or goods issues from MM), SAP solutions considers the transaction to be a debit posting to the order. When a transaction reduces the costs on an order (such as settlement to receivers either internal or external to CO), SAP solutions considers the transaction to be a credit posting to the order.

In the Rapid Mart, Internal Orders are derived from the object number (Field COEP.OBJNR) assignment on Cost Transactions.

When object number starts with “OR”, positions 3 - 14 of the object number are the Internal Order Number.

Project Elements

You structure your project using Project Elements. They are also called

WBS (Work Breakdown Structure). They are a hierarchical outline of an undertaking described in the project definition.

Project Elements form the basis for the organization and coordination of a project. They organize project tasks into a hierarchy.

The Project Elements describe specific tasks or actions in the project to be carried out within a specific time period.

They are the functional basis for planning steps in a project, including: process planning, cost planning, scheduling, capacity planning or costing, as well as project control.

They give you a clear picture of the project and facilitate the coordination and implementation of the project. They allow you to effectively manage a project.

In SAP solutions, individual Project Elements are assigned to the Cost Transactions. Actual Projects are not.

32 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Activities

Rapid Mart Subject Areas

Cost Analysis Basics

In the Rapid Mart, Project elements are derived from the object number (Field COEP.OBJNR) assignment on Cost Transactions.

When object number starts with “PR”, positions 3 - 10 of the object number are the project element. When object number starts with “OR” and partner object (Field COEP.PAROB1) starts with “PR”, positions 3 - 10 of the partner object are the project element.

You can use the Activities to provide a business process oriented, crossfunctional view of overhead costs in addition to the traditional, locationoriented view provided by Cost Center Accounting. Activities thus enhance the Cost Center Accounting.

An Activity allocates process quantities based on resource and process drivers, allowing you to define cost allocation more exactly along the Value Added Chain that is possible with overhead rates.

Likewise, an Activity enhances product costing by assigning the sources of costs to their originating business processes. Cost center resources can allocate to business processes based on their true utilization of activities.

In contrast to traditional overhead cost accounting, Activities give a fairer assignment of the overhead costs to products, customers, distribution channels, and other objects.

In the Rapid Mart, Activities are derived from the object number (Field COEP.OBJNR) assignment on Cost Transactions.

When object number starts with “KL”, positions 17 - 22 of the object number are the Activity ID. When object number starts with “KS” and partner object (Field COEP.PAROB1) starts with “KL”, positions 17 - 22 of the partner object are the Activity ID.

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 33

Rapid Mart Subject Areas

Compa ny

Code

Controlling

Are a

Profit

Center

Cost

Center

Business

Are a

Key: Arrows indicate a “one to

many” relationship:

on e many

Example: O ne C ont rolling Ar ea ca n

h av e m any Co mpany Co des

Chart

of A ccts

G en. Ldgr.

Accts

Fin

Fin. Mgmt

Area

Cost Analysis Basics

Financial Organization Structure

The Financial Organization Structure from SAP solutions that is covered by the Rapid Mart is shown in the diagram below

:Functional Areas are another optional organization related classification of cost accounting transactions. You can freely define these to categorize the accounting transactions in addition to other organizational elements.

Some examples of Functional Areas are:

• Sales & Marketing

• Administration

• Manufacturing

• Direct Production Costs

• Research & Development

Functional Areas can be associated with:

• G/L accounts

• Cost Elements

• Cost Centers

34 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

• Activities

Cost Elements

SAP solutions’s cost element module classifies a transaction according to the nature of the cost being posted to a given cost object (such as cost center or internal order). Each cost element maps back to a general ledger account specified in SAP solutions’s financial accounting (FI) module.

There are two types of cost elements:

• Primary — Directly incurred costs. Primary cost elements are those

• Secondary — Costs previously incurred and posted that are being

When SAP solutions posts an FI transaction that uses an expense account with a primary cost element, it checks that there is a valid CO object assignment—such as to a cost center or an internal order—for that line item. SAP solutions does not post an expense in FI unless the expense is passed as a cost to CO at the same time.

Because Cost Elements are a subset of GL Accounts, the Rapid Mart stores the Cost Element ID’s as both GL Account ID’s and Cost Element ID’s. The values are identical in both fields for any given row of data.

Both fields serve as foreign keys to two different dimensions: Cost Center and GL Account. The Cost Center dimension contains SAP solutions Controlling module data. The GL Account dimension contains SAP solutions General Ledger module data.

Rapid Mart Subject Areas

Cost Analysis Basics

relevant to cost accounting in the SAP solutions CO. A general ledger expense account in the FI module must contain the cost element before it can be created in the CO.

reassigned to another cost object. Secondary cost elements are used exclusively for certain types of internal CO transactions. These transactions have no corresponding general ledger accounts or other definition in FI.

Profit Centers

Profit Centers are organizational units in Accounting that reflect a management-oriented structure of the organization for the purpose of internal control. Operating results for profit centers can be analyzed using either the cost-of-sales approach or the period accounting approach.

A profit center represents an organizational subunit that operates independently on the market and bears responsibility for its own costs and revenues. You organize your organization into profit centers by assigning the master data of each profit-relevant objects (materials, cost centers, orders, projects, sales orders, assets, cost objects, and profitability segments) to a profit center

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 35

Rapid Mart Subject Areas

Cost Analysis Basics

Projects

By analyzing the fixed capital as well, you can expand your profit centers for use as investment centers.

In the Rapid Mart, Profit Centers are only associated with the Profit Center Subject areas.

In SAP solutions cost transactions can optionally be assigned to a project. A

project is a complex structure of tasks within a controlling area. It is used to control and monitor the schedule, resources, capacities, cost, revenues, and funds availability .

Projects are generally part of the internal processes of a company. To be able to control all tasks in project execution, you need an organizational form that is specific to the project and which is shared by all departments involved. Before you can carry out a project in its entirety, the project goals must be precisely described and the project activities to be carried out must be structured. A clear, unambiguous project structure is the basis for successful project planning, monitoring, and control.

A project is not directly assigned to a cost transaction in SAP solutions. Only a Project Element is assigned directly. The Rapid Mart uses the Project Element to look up the Project ID as a Project Element can be associated with only one Project.

Vendors

Business partner to whom amounts are payable for goods delivered/ services performed. Examples of such services/goods include:

• Goods acquired

• Business services received

• The transfer of a right

In the Rapid Mart, Vendors are derived on Cost T ransactions associated with Purchase Orders.

When the reference order type on the cost transaction (field COEP.RBEST) is “20” then the cost transaction is associated to a purchase order, and the purchase order number is stored in the cost transaction (field COEP.EBELN). We use this purchase order number to lookup the Vendor ID on table LIFNR in SAP solutions.

36 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Additionally, if the Value Type is “04” (Actuals) on a cost transaction (field COEP.WRTTP = '04'), and the Controlling transaction is a through-posting from FI (field COBK.VRGNG = 'COIN'), we get the Vendor ID from the associated Accounting Document (table BSEG).

Accounting Hierarchies

The Cost Center Rapid Mart has 6 hierarchy dimensions that report cost and profit breakdowns in the same manner as SAP solutions. These hierarchies are organized in both horizontal and vertical format. They are:

• Activity

• Cost Center

• Cost Element

• Functional Area

• Project Element

• Internal Orders

• General Ledger Accounts. (For more detail on the General Ledger

Account Hierarchies, see the section General Ledger Account

Hierarchies in this chapter)

• Profit Center

A hierarchy is an ordered series of related objects. An example of a hierarchy is time, or “date”, which may group objects as Year, Quarter, and Month. You can use drill up or down to perform multi dimensional analysis with a hierarchy.

Horizontal hierarchies are organized so that all levels (or nodes) appear as columns on a single row of data. Vertical hierarchies represent each level or node with an individual row of data. For more details refer to chapter 5 (Universe) section on “Filters & Techniques” on page 190.

Rapid Mart Subject Areas

Cost Analysis Basics

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 37

Rapid Mart Subject Areas

Cost Transaction Section

The Cost Transaction Section (also called Cost Detail) extracts SAP solutions data that allows cost transactions to be monitored and classified.

Cost transaction data can be used to track costs that have been incurred (such as labor, postage or telephone costs), and to pinpoint where costs occur within a company . Cost transaction data can also be used to track costs associated with a particular accounting entity, such as a building project or a marketing event. Cost transaction data allows viewing details of individual accounting transactions such as transaction number, posting date, material, vendor, transaction amount and quantity.

Rapid Mart Processing

Extracted cost transaction data is stored in the COST_TRANSACTION_FACT table. The cost transaction section also captures the following dimensional attributes, and their associated dimension tables:

Attribute Name Dimension Table(s)

Activity & Hierarchy ACTIVITY, ACTIVITY_HIER,

Business Area BUSINESS_AREA Chart of Accts CHART_OF_ACCOUNTS Company Code COMPANY_CODE Controlling Area CONTROLLING_AREA Controlling Transaction CONTROLLING_TRANSACTION Cost Center & Hierarchy COST_CENTER,

Cost Element & Hierarchy COST_ELEMENT,

Monetary Currency CURRENCY

ACTIVITY_HIER_BAD, ACTIVITY_HIER_HZ, ACTIVITY_HIER_VR

COST_CENTER_HIER, COST_CENTER_HIER_BAD, COST_CENTER_HIER_HZ, COST_CENTER_HIER_VR

COST_ELEMENT_HIER, COST_ELEMENT_HIER_BAD, COST_ELEMENT_HIER_HZ, COST_ELEMENT_HIER_VR

38 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Rapid Mart Subject Areas

Cost Transaction Section

Attribute Name Dimension Table(s)

Debit Credit Indicator DEBIT_CREDIT_INDICATOR Financial Record Type FINANCIAL_RECORD_TYPE Financial Version FINANCIAL_VERSION Fiscal Period FISC_PERIOD,

FISC_PERIOD_STAGE

Functional Area & Hierarchy FUNCTIONAL_AREA,

FUNCTIONAL_AREA_HIER, FUNCTIONAL_AREA_HIER_BAD, FUNCTIONAL_AREA_HIER_HZ,

FUNCTIONAL_AREA_HIER_VR GL Account By Company GL_ACCOUNT_BY_COMPANY Internal Order & Hierarchy INTERNAL_ORDER,

INTERNAL_ORDER_HIER,

INTERNAL_ORDER_HIER_BAD,

INTERNAL_ORDER_HIER_HZ,

INTERNAL_ORDER_HIER_VR Material & Product Hierarchy MATERIAL,

PRODUCT_HIERARCHY Material By Plant MATERIAL_BY_PLANT Object Class OBJECT_CLASS Object Type OBJECT_TYPE Plant PLANT Project PROJECT Project Element & Hierarchy PROJECT_ELEMENT,

PROJECT_ELEMENT_HIER,

PROJECT_ELEMENT_HIER_BAD,

PROJECT_ELEMENT_HIER_HZ,

PROJECT_ELEMENT_HIER_VR Time Dim TIME_DIM Unit Of Measure UNIT_OF_MEASURE Vendor VENDOR

The Cost Transaction section extracts cost-related data from the SAP solutions header and line item tables (tables COBK and COEP in SAP solutions respectively).

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 39

Rapid Mart Subject Areas

Cost Transaction Section

Fact Table Fields

The Cost Transaction Detail table (COST_TRANSACTION_FACT) contains the following measures:

Col. Name Description

AMT_CTRL_AREA COEP-WKGBTR - Total Value in Controlling Area

Currency

AMT_FIXED_CTRL_AREA COEP-WKFBTR - Fixed Value in Controlling Area

Currency

AMT_FIXED_VAR_CTRL_AREA COEP-PAFBTR - Fixed Price Variance in Ctrl Area

Currency AMT_OBJ COEP-WOGBTR - Total Value in Object Currency AMT_TRX COEP-WTGBTR -Total Value in Transaction Currency AMT_VAR_CTRL_AREA COEP-PAGBTR - Total Price Variance in Ctrl Area

Currency QTY COEP-MEGBTR - Total Quantity QTY_ENTERED COEP-MBGBTR - Total quantity entered QTY_FIXED COEP-MEFBTR - Fixed Quantity QTY_FIXED_ENTERED COEP-MBFBTR - Fixed quantity entered

40 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Rapid Mart Data

The cost transaction section includes cost information at the transaction level. The COST_TRANSACTION_FACT table stores these details. The COST_TRANSACTION_FACT table and associated dimension tables are organized as a star schema as shown below.

Rapid Mart Subject Areas

Cost Transaction Section

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 41

Rapid Mart Subject Areas

Cost Transaction Section

Additionally, the Cost Transaction section includes the following hierarchies that are associated with the dimensions of the same name:

You can analyze transaction costs along several dimensions:

• By Activity and Activity Hierarchies

• By Cost Center and Cost Center Hierarchies

• By Cost Element (GL Account) and Cost Element Hierarchies

• By Fiscal Periods (Fiscal Year, Quarter, Month)

• By Internal Orders and Internal Order Hierarchies

• By Material and Product Hierarchies

• By Monetary Currencies

• By Object Type

• By Object Class

• By Financial Organization:

• Business Area

• Company Code

• Controlling Area

• Functional Area

• By Project Element and Project Element Hierarchies

42 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Rapid Mart Subject Areas

Cost Transaction Section

• By Project

• By Time Dimension (posting and creation dates)

• By Business Transaction Type

• By Controlling Version

• By Value Type

• By Unit of Measure

• By Vendor

Using the cost transaction section, you can answer questions like:

• How much was spent on labor (or telephone, or insurance) last year, by

cost center?

• What were the company’s total costs for trade shows this year?

• Who are out top 10 vendors (amount spent) this year?

• What is the cost breakdown by Product Hierarchy for this month?

• Which Projects and Project Elements are costliest?

• Which projects are over budget?

• What is the breakdown of project over-runs by project element?

• Which Activities have the highest expenses?

• Are production orders (a type of internal orders) completed within

budgeted costs?

• Which vendors can supply this material at the lowest cost?

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 43

Rapid Mart Subject Areas

Cost Summary Section

The cost summary section stores cost period totals (balances) by fiscal period and year.

This is the main data source for financial reporting to view the company cost trends and to perform multi-dimensional analysis. It is also used for various financial ratios calculation when average or total of 12 rolling periods is involved.

Cost summary data is organized both horizontally and vertically. Table COST_SUMMARY_FACT_HZ stores the horizontal representation. Table COST_SUMMARY_FACT_VR stores the vertical representation.

Rapid Mart Processing

The cost summary section captures the following dimensional attributes, and their associated dimension tables:

Attribute Name Table Name(s)

Activity & Hierarchy ACTIVITY, ACTIVITY_HIER,

Business Area BUSINESS_AREA Chart of Accounts CHART_OF_ACCOUNTS Company Code COMPANY_CODE Controlling Area CONTROLLING_AREA Controlling Transaction CONTROLLING_TRANSACTION Cost Center & Hierarchy COST_CENTER,

Cost Element & Hierarchy COST_ELEMENT,

Financial Record Type FINANCIAL_RECORD_TYPE Financial Version FINANCIAL_VERSION

ACTIVITY_HIER_BAD, ACTIVITY_HIER_HZ, ACTIVITY_HIER_VR

COST_CENTER_HIER, COST_CENTER_HIER_BAD, COST_CENTER_HIER_HZ, COST_CENTER_HIER_VR

COST_ELEMENT_HIER, COST_ELEMENT_HIER_BAD, COST_ELEMENT_HIER_HZ, COST_ELEMENT_HIER_VR

44 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Rapid Mart Subject Areas

Cost Summary Section

Attribute Name Ta ble Name(s)

Fiscal Period FISC_PERIOD,

FISC_PERIOD_STAGE GL Account By Company GL_ACCOUNT_BY_COMPANY Internal Order & Hierarchy INTERNAL_ORDER,

INTERNAL_ORDER_HIER,

INTERNAL_ORDER_HIER_BAD,

INTERNAL_ORDER_HIER_HZ,

INTERNAL_ORDER_HIER_VR Monetary Currency CURRENCY Object Class OBJECT_CLASS Object Type OBJECT_TYPE Project PROJECT Project Element & Hierarchy PROJECT_ELEMENT,

PROJECT_ELEMENT_HIER,

PROJECT_ELEMENT_HIER_BAD,

PROJECT_ELEMENT_HIER_HZ,

PROJECT_ELEMENT_HIER_VR Unit of Measure UNIT_OF_MEASURE

The cost summary section extracts cost-related data from the SAP solutions summary tables for internal and external costs: table COSS for internal costs, and table COSP for external costs.

Fact Table Fields

The Cost Summary tables (COST_SUMMARY_FACT_HZ & COST_SUMMARY_FACT_VR) contain the following measures:

COST_SUMMARY_FACT_VR (Vertical Organization):

Measures Definition

AMT_CR_CTRL_AREA Cost Summary Value in Controlling Area

Currency - Credit Value

AMT_CR_FIXED_CTRL_AREA Cost Summary Fixed Value in Controlling

Area Currency - Credit Value

AMT_CR_FIXED_YTD_CTRL_AREA Cost Summary Fixed Value Year-To-Date in

Controlling Area Currency - Credit Value

AMT_CR_FIXVAR_CTRL_AREA Cost Summary Fixed Variance in Controlling

Area Currency - Credit Value

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 45

Rapid Mart Subject Areas

Cost Summary Section

Measures Definition

AMT_CR_FIXVAR_YTD_CTRL_AREA Cost Summary Fixed Variance Year-To-Date

in Controlling Area Currency - Credit Value

AMT_CR_OBJ Cost Summary Value in Cost Center (Object)

Currency - Credit Value

AMT_CR_TRX Cost Summary Value in Transaction Currency

- Credit Value

AMT_CR_VAR_CTRL_AREA Cost Summary Price Variance in Controlling

Area Currency - Credit Value

AMT_CR_VAR_YTD_CTRL_AREA Cost Summary Price Variance Year-To-Date

in Controlling Area Currency - Credit Value

AMT_CR_YTD_CTRL_AREA Cost Summary Value Year-To-Date in

Controlling Area Currency - Credit Value

AMT_CR_YTD_OBJ Cost Summary Value Year-To-Date in Cost

Center (Object) Currency - Credit Value

AMT_CR_YTD_TRX Cost Summary Value Year-To-Date in

Transaction Currency - Credit Value

AMT_DR_CTRL_AREA Cost Summary Value in Controlling Area

Currency - Debit Value

AMT_DR_FIXED_CTRL_AREA Cost Summary Fixed Value in Controlling

Area Currency - Debit Value

AMT_DR_FIXED_YTD_CTRL_AREA Cost Summary Fixed Value Year-To-Date in

Controlling Area Currency - Debit Value

AMT_DR_FIXVAR_CTRL_AREA Cost Summary Fixed Variance in Controlling

Area Currency - Debit Value

AMT_DR_FIXVAR_YTD_CTRL_AREA Cost Summary Fixed Variance Year-To-Date

in Controlling Area Currency - Debit Value

AMT_DR_OBJ Cost Summary Value in Cost Center (Object)

Currency - Debit Value

AMT_DR_TRX Cost Summary Value in Transaction Currency

- Debit Value

AMT_DR_VAR_CTRL_AREA Cost Summary Price Variance in Controlling

Area Currency - Debit Value

AMT_DR_VAR_YTD_CTRL_AREA Cost Summary Price Variance Year-To-Date

in Controlling Area Currency - Debit Value

AMT_DR_YTD_CTRL_AREA Cost Summary Value Year-To-Date in

Controlling Area Currency - Debit Value

46 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Rapid Mart Subject Areas

Cost Summary Section

Measures Definition

AMT_DR_YTD_OBJ Cost Summary Value Year-To-Date in Cost

Center (Object) Currency - Debit Value

AMT_DR_YTD_TRX Cost Summary Value Year-To-Date in

Transaction Currency - Debit Value

AMT_FIXED_PER_ROLLNG_CTRL_AREA Cost Summary Fixed Rolling 16 Periods Tot al

in Controlling Area Currency

AMT_FIXVAR_PER_ROLLNG_CTRL_AREA Cost Summary Fixed Variance Rolling 16

Periods Total in Controlling Area Currency

AMT_PER_ROLLNG_CTRL_AREA Cost Summary Rolling 16 Periods Total in

Controlling Area Currency

AMT_PER_ROLLNG_OBJ Cost Summary Rolling 16 Periods Total in

Cost Center (Object) Currency

AMT_PER_ROLLNG_TRX Cost Summary Rolling 16 Periods Total in

Transaction Area Currency

AMT_VAR_PER_ROLLNG_CTRL_AREA Cost Summary Price Variance Rolling 16

Periods Total in Controlling Area Currency QTY_CR Cost Summary Quantity - Credit Value QTY_CR_FIXED Cost Summary Fixed Quantity - Credit Value QTY_CR_FIXED_YTD Cost Summary Fixed Quantity Year-To-Date -

Credit Value QTY_CR_YTD Cost Summary Quantity Y ear-To-Date - Credit

Value QTY_DR Cost Summary Quantity - Debit Value QTY_DR_FIXED Cost Summary Fixed Quantity - Debit Value QTY_DR_FIXED_YTD Cost Summary Fixed Quantity Year-To-Date -

Debit Value QTY_DR_YTD Cost Summary Quantity Year-To-Date - Debit

Value QTY_FIXED_PER_ROLLNG Cost Summary Fixed Rolling 16 Periods

Quantity QTY_PER_ROLLNG Cost Summary Rolling 16 Periods Quantity

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 47

Rapid Mart Subject Areas

Cost Summary Section

COST_SUMMARY_FACT_HZ (Horizontal Organization):

Measures Definition

AMT_CR_FIXED_PER01_CTRL_AREA AMT_CR_FIXED_PER16_CTRL_AREA

AMT_CR_FIXVAR_PER01_CTRL_AREA AMT_CR_FIXVAR_PER16_CTRL_AREA

AMT_CR_PER01_CTRL_AREA AMT_CR_PER16_CTRL_AREA

AMT_CR_PER01_OBJ AMT_CR_PER16_OBJ

AMT_CR_PER01_TRX AMT_CR_PER16_TRX

AMT_CR_VAR_PER01_CTRL_AREA AMT_CR_VAR_PER16_CTRL_AREA

AMT_DR_FIXED_PER01_CTRL_AREA AMT_DR_FIXED_PER16_CTRL_AREA

AMT_DR_FIXVAR_PER01_CTRL_AREA AMT_DR_FIXVAR_PER16_CTRL_AREA

AMT_DR_PER01_CTRL_AREA AMT_DR_PER16_CTRL_AREA

AMT_DR_PER01_OBJ AMT_DR_PER16_OBJ

AMT_DR_PER01_TRX AMT_DR_PER16_TRX

AMT_DR_VAR_PER01_CTRL_AREA AMT_DR_VAR_PER16_CTRL_AREA

QTY_CR_FIXED_PER01 QTY_CR_FIXED_PER16

QTY_CR_PER01 - QTY_CR_PER16 Cost Summary Quantity (periods 1 - 16) -

QTY_DR_FIXED_PER01 QTY_DR_FIXED_PER16

QTY_DR_PER01 - QTY_DR_PER16 Cost Summary Quantity (periods 1 - 16) -

Cost Summary Fixed Value in Controlling Area Currency (periods 1 - 16) - Credit Values

Cost Summary Fixed Variance in Controlling Area Currency (periods 1 - 16) - Credit Values

Cost Summary Value in Controlling Area Currency (periods 1 - 16) - Credit Values

Cost Summary Value in Cost Center (Object) Currency (periods 1 - 16) - Credit Values

Cost Summary V alue in T ransaction Currency (periods 1 - 16) - Credit Values

Cost Summary Price Variance in Controlling Area Currency (periods 1 - 16) - Credit Values

Cost Summary Fixed Value in Controlling Area Currency (periods 1 - 16) - Debit Values

Cost Summary Fixed Variance in Controlling Area Currency (periods 1 - 16) - Debit Values

Cost Summary Value in Controlling Area Currency (periods 1 - 16) - Debit Values

Cost Summary Value in Cost Center (Object) Currency (periods 1 - 16) - Debit Values

Cost Summary V alue in T ransaction Currency (periods 1 - 16) - Debit Values

Cost Summary Price Variance in Controlling Area Currency (periods 1 - 16) - Debit Values

Cost Summary Fixed Quantity (periods 1 - 16)

- Credit Values

Credit Values Cost Summary Fixed Quantity (periods 1 - 16)

- Debit Values

Debit Values

48 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Rapid Mart Data

The COST_SUMMARY_FACT_HZ table has one row summarizing cost information for each cost object for each fiscal year, with columns for quantity and value totals for all fiscal periods in each row. There can be upto 16 fiscal periods in the SAP solutions system: 12 regular periods and 4 special posting periods used for adjustments.

COS_SUMMARY_F ACT_VR, has the same info rmation, bu t with one row for each fiscal period, resulting in upto 16 times as many rows in the table.

The organization of the SAP solutions source tables (COSS and COSP) follows the horizontal format. Therefore, COST_SUMMARY_FACT_HZ is analogous to SAP solutions. Data Services uses the Pivot transform to create the vertical format for COST_SUMMARY_FACT_VR.

Both the COST_SUMMARY_FACT_VR and COST_SUMMARY_FACT_HZ tables contain a Transaction Type Flag (column name TRX_TYPE_ID). The flag is set to “I” for Internal or “E” External. Data from SAP solutions table COSS is flagged with “I” for Internal. Data from SAP solutions table COSP is flagged with “E” for External.

Rapid Mart Subject Areas

Cost Summary Section

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 49

Rapid Mart Subject Areas

Cost Summary Section

The following diagram shows the tables in the cost summary section in Star Schema Layout.

50 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Rapid Mart Subject Areas

Cost Summary Section

Additionally, the Cost Summary Section includes the following hierarchies which are associated to the dimension of the same name.

You can analyze summary costs along several dimensions:

• By Activity and Activity Hierarchies

• By Cost Center and Cost Center Hierarchies

• By Cost Element (GL Account) and Cost Element Hierarchies

• By Fiscal Periods (Fiscal Year, Quarter, Month)

• By Internal Orders and Internal Order Hierarchies

• By Monetary Currencies

• By Object Type

• By Object Class

• By Financial Organization:

• Business Area

• Company Code

• Controlling Area

• By Project Element and Project Element Hierarchies

• By Project

• By Business Transaction Type

• By Controlling Version

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 51

Rapid Mart Subject Areas

Cost Summary Section

• By Value Type

• By Unit of Measure

Using the cost summary section, you can answer questions like:

• “For which cost items is the company overall in variance?”

• “How much was spent on labor (or telephone, or insurance) last year,

versus how much was planned?”

• “Which cost centers are in variance for specific cost elements and which

activity types were involved?”

• “What are the planned versus actual costs for a specific cost center or

group of cost centers?”

• “What was the variance in planned versus actual costs for trade shows by

cost element?”

• “Which activities were responsible for the variance?”

• What is the variance between actual and planned (budget) amounts by

cost center hierarchy for this year?

• Have I been able to reduce costs (by cost element hierarchy) this year

compared to last?

• What are my cost trends for any rolling 12 month period?

52 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Profit Center Detail Section

Overview

The Profit Center Detail section obtains information from the EC-PCA Profit Center Accounting Standard Ledger in SAP solutions. Profit Ce nter Summary

Section (discussed later in this chapter) is a part of the same Standard

Ledger. SAP solutions divides the Profit Center Detail data into Actuals and Planned

(Budgeted) values. In Classic GL, these are stored in separate tables (GLPCA and GLPCP respectively). The Rapid Mart assigns combines data from both tables and assigns an Actual or Budget Flag to each row of profit center data. Values are “A” for Actuals data, and “P” for Budget (or Planned) data.

This section allows you to report profits and losses by profit center using either period accounting or the cost-of-sales approach. It also lets you analyze fixed capital and so-called “statistical key figures” (number of employees, square meters, and so on) by profit center. Consequently, you can calculate all the key figures commonly used in cost accounting (return on investment, cash flow, sales per employee, and so on).

What is a Profit Center? A profit center is a management-oriented organizational unit used for internal controlling purposes. Dividing your company up into profit centers allows you to analyze areas of responsibility and to delegate responsibility to decentralized units, thus treating them as “companies within the company”.

Every profit center is assigned to the organizational unit Controlling area. This assignment is necessary because Profit Center Accounting displays values in G/L accounts. The profit centers in a controlling area are all contained in a standard hierarchy for that controlling area.

The essential difference between a profit center and a business area is that profit centers are used for internal control, while business areas are more geared toward an external viewpoint.

The profit center differs from a cost center in that cost centers merely represent the units in which capacity costs arise, whereas the person in charge of the profit center is responsible for its balance of costs and revenues.

Rapid Mart Subject Areas

Profit Center Detail Section

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 53

Rapid Mart Subject Areas

Profit Center Detail Section

Profit Center Detail data is organized horizontally and vertically. In horizontal organization, a single row in the table represents an entire fiscal year’s worth of data, with separate fields for monetary amounts in each fiscal period. In vertical organization, a single row represents a single fiscal period. There is a separate row for each fiscal period / fiscal year combination.

Profit Center Detail carries amounts in Transaction (Document) Currency, Object (Profit Center) Currency, and Local (Company Code) Currency. It also carries quantities in Base Unit of Measure.

Table PROFIT_CENTER_FACT_HZ stores the horizontal representation. Table PROFIT_CENTER_FACT_VR stores the vertical representation.

Profit Center Detail allows to produce year trend reports with finer granularity than the Profit Center Summary section.

Rapid Mart Processing

Extracted Profit Center Detail data are stored in the PROFIT_CENTER_FACT_HZ and PROFIT_CENTER_FACT_VR tables and their associated dimension tables.

Dimensions

This section includes the following dimensional attributes, and their associated dimension tables:

Attribute Dimension Table Name(s)

Activity & Hierarchy ACTIVITY, ACTIVITY_HIER,

ACTIVITY_HIER_BAD, ACTIVITY_HIER_HZ,

ACTIVITY_HIER_VR Business Area BUSINESS_AREA Chart of Accounts CHART_OF_ACCOUNTS Company Code COMPANY_CODE Controlling Area CONTROLLING_AREA Controlling Version FINANCIAL_VERSION Cost Center & Hierarchy COST_CENTER,

COST_CENTER_HIER,

COST_CENTER_HIER_BAD,

COST_CENTER_HIER_HZ,

COST_CENTER_HIER_VR

54 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Rapid Mart Subject Areas

Profit Center Detail Section

Attribute Dimension Table Name(s)

Cost Element & Hierarchy COST_ELEMENT,

COST_ELEMENT_HIER, COST_ELEMENT_HIER_HZ, COST_ELEMENT_HIER_VR,

COST_ELEMENT_HIER_BAD Customer CUSTOMER Debit / Credit Indicator DEBIT_CREDIT_INDICATOR Document Category DOCUMENT_CATEGORY Financial Document Type DOCUMENT_CATEGORY &

DOCUMENT_TYPE* Fiscal Period (Vertical Table only) FISC_PERIOD Functional Area & Hierarchy FUNCTIONAL_AREA,

FUNCTIONAL_AREA_HIER,

FUNCTIONAL_AREA_HIER_HZ,

FUNCTIONAL_AREA_HIER_VR,

FUNCTIONAL_AREA_HIER_BAD GL Account & Hierarchy GL_ACCOUNT_HIER,

GL_ACCOUNT_HIER_BAD,

GL_ACCOUNT_HIER_HZ,

GL_ACCOUNT_HIER_STAGE,

GL_ACCOUNT_HIER_VR,

GL_ACCOUNT_MASTER Internal Order & Hierarchy INTERNAL_ORDER,

INTERNAL_ORDER_HIER,

INTERNAL_ORDER_HIER_BAD,

INTERNAL_ORDER_HIER_HZ,

INTERNAL_ORDER_HIER_VR Material and Product Hierarchy MATERIAL, PRODUCT_HIERARCHY Monetary Currency CURRENCY Plant (or Factory) PLANT Profit Center & Hierarchy PROFIT_CENTER,

PROFIT_CENTER_HIER,

PROFIT_CENTER_HIER_BAD,

PROFIT_CENTER_HIER_HZ,

PROFIT_CENTER_HIER_VR Record Type FINANCIAL_RECORD_TYPE Segment (New GL only) SEGMENT Special Ledger (Master Data) FISL_LEDGER

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 55

Rapid Mart Subject Areas

Profit Center Detail Section

Fact Table Fields

Attribute Dimension Table Name(s)

Special Ledger Document Type DOCUMENT_CATEGORY &

DOCUMENT_TYPE* Special Ledger Group (New GL only) LEDGER_GROUP Time Dimension TIME_DIM Transaction Type TRANSACTION_TYPE Unit of Measure UNIT_OF_MEASURE Valuation Area VALUATION_AREA Vendor VENDOR

* DOCUMENT_TYPE is the dimension table for both Special Ledger Document Type and Financial Document Type.

Profit Center Details section extracts data from the transaction t ables for SAP module Profit Center Accounting (EC-PCA). Table GLPCA is the Actuals transactions. Table GLPCP is the Planned (or Budget) transactions.

The Profit Center Transaction tables (PROFIT_CENTER_FACT_HZ and PROFIT_CENTER_FACT_VR) contain the following measures:

PROFIT_CENTER_FACT_HZ:

PROFIT_CENTER_FACT_HZ Measure Column Name

AMT_PER_BEGIN_LOC Period Beginning Balance - Local

AMT_PER_BEGIN_PCNTR Period Beginning Balance - Profit

AMT_PER_BEGIN_TRX Period Beginning Balance - Transac-

AMT_PER01_LOC AMT_PER16_LOC

AMT_PER01_PCNTR AMT_PER16_PCNTR

AMT_PER01_TRX AMT_PER16_TRX

56 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Description

Currency

Center (Object) Currency

tion Currency Amount For Fiscal Periods 1 - 16 -

Local Currency Amount For Fiscal Periods 1 - 16 -

Profit Center (Object) Currency Amount For Fiscal Periods 1 - 16 -

Transaction Currency

Rapid Mart Subject Areas

Profit Center Detail Section

PROFIT_CENTER_FACT_HZ Measure Column Name

QTY_PER_BEGIN Quantity in Base Unit of Measure

QTY_PER01 - QTY_PER16 Quantity in Base Unit of Measure For

PROFIT_CENTER_FACT_VR:

PROFIT_CENTER_FACT_VR Measure Column Name

AMT_TRX Value in Transaction (Document)

AMT_LOC Value in Local (Company Code) Cur-

AMT_PCNTR Value in Profit Center Currency QTY Quantity in Base Unit of Measure

Description

Period Beginning Balance

Fiscal Periods 1 - 16

Description

Currency

rency

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 57

Rapid Mart Subject Areas

Profit Center Detail Section

Rapid Mart Data

The PROFIT_CENTER_FACT_HZ and PROFIT_CENTER_FACT_VR tables are represented in the Star Schema below, along with their associated hierarchy tables:

58 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Rapid Mart Subject Areas

Profit Center Summary Section

You can analyze profit center transactions along several dimensions:

• By Cost Element (GL Account) and Cost Element Hierarchies

• By Fiscal Periods (Fiscal Year, Quarter, Month)

• By Internal Orders and Internal Order Hierarchies

• By Material and Product Hierarchies

• By Monetary Currencies

• By Financial Organization:

• Business Area

• Company Code

• Controlling Area

• Functional Area

• By Profit Center and Profit Center Hierarchies

• By General Ledger Account and Associated Hierarchies

• By Time Dimension (posting and creation dates)

• By Controlling Version

• By Unit of Measure

• By Vendor

• By Valuation Area

Using the profit center transactions section, you can answer questions like:

• Which Profit Centers bring in the most revenue this quarter?

• What are my weekly Actual vs. Planned costs (Variance) by Profit Center

hierarchy?

• Which are my top 10 transactions by fiscal year?

• Which materials are most profitable by profit center during the last

month?

• What are my profit center transactions by internal order hierarchy?

Profit Center Summary Section

Overview

The Profit Center Summary section obtains information from the EC-PCA Profit Center Accounting Standard Ledger in SAP solutions. Profit Center

Detail Section (discussed earlier in this chapter) is a part of the same

Standard Ledger.

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 59

Rapid Mart Subject Areas

Profit Center Summary Section

Profit Center Summary data is stored in the GLPCT table. These are summarized transaction for the EC-PCA Profit Center Accounting Standard Ledger.

Profit Center Summary data is organized horizontally and vertically. In horizontal organization, a single row in the table represents an entire fiscal year’s worth of data, with separate fields for monetary amounts in each fiscal period. In vertical organization, a single row represents a single fiscal period. There is a separate row for each fiscal period / fiscal year combination.

Profit Center Summary carries amounts in Transaction (Document) Currency, Object (Profit Center) Currency, and Local (Company Code) Currency. It also carries quantities in Base Unit of Measure.

Table PROFIT_CENTER_SUMMARY_FACT_HZ stores this horizontal representation. Table PROFIT_CENTER_SUMMARY_FACT_VR stores the vertical representation.

Rapid Mart Processing

Extracted Profit Center Summary data are stored in the PROFIT_CENTER_SUMMARY_FACT_HZ and PROFIT_CENTER_SUMMARY_FACT_VR tables and their associated dimension tables.

Dimensions

This section includes the following dimensional attributes, and their associated dimension tables:

Attribute Dimension Table Name(s)

Chart of Accounts CHART_OF_ACCOUNTS Company Code COMPANY_CODE Controlling Area CONTROLLING_AREA Controlling Version FINANCIAL_VERSION Fiscal Period (Vertical Table

only)

60 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

FISC_PERIOD

Rapid Mart Subject Areas

Profit Center Summary Section

Attribute Dimension Table Name(s)

Functional Area & Hierarchy FUNCTIONAL_AREA,

FUNCTIONAL_AREA_HIER, FUNCTIONAL_AREA_HIER_HZ, FUNCTIONAL_AREA_HIER_VR, FUNCTIONAL_AREA_HIER_BAD

GL Account & Hierarchy GL_ACCOUNT_HIER,

GL_ACCOUNT_HIER_BAD, GL_ACCOUNT_HIER_HZ, GL_ACCOUNT_HIER_STAGE, GL_ACCOUNT_HIER_VR,

GL_ACCOUNT_MASTER Monetary Currency CURRENCY Plant (or Factory) PLANT Profit Center & Hierarchy PROFIT_CENTER,

PROFIT_CENTER_HIER,

PROFIT_CENTER_HIER_BAD,

PROFIT_CENTER_HIER_HZ,

PROFIT_CENTER_HIER_VR Record Type FINANCIAL_RECORD_TYPE Segment (New GL only) SEGMENT Special Ledger (Master Data) FISL_LEDGER Special Ledger Group (New

GL only) Transaction Type TRANSACTION_TYPE Unit of Measure UNIT_OF_MEASURE

LEDGER_GROUP

Fact Table Fields

The Profit Center Summary Fact tables (PROFIT_CENTER_SUMMARY_FACT_HZ and PROFIT_CENTER_SUMMARY_FACT_VR) contain the following measures:

PROFIT_CENTER_SUMMARY_FACT_HZ:

PROFIT_CENTER_SUMMARY_ FACT_HZ Measure Column Name

AMT_CR_PER_BEGIN_LOC Credit Amount Period Beginning Bal-

AMT_CR_PER_BEGIN_PCNTR Credit Amount Period Beginning Bal-

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 61

Description

ance Local Currency

ance Profit Center Currency

Rapid Mart Subject Areas

Profit Center Summary Section

PROFIT_CENTER_SUMMARY_ FACT_HZ Measure Column Name

AMT_CR_PER_BEGIN_TRX Credit Amount Period Beginning Bal-

AMT_CR_PER01_LOC AMT_CR_PER16_LOC

AMT_CR_PER01_PCNTR AMT_CR_PER16_PCNTR

AMT_CR_PER01_TRX AMT_CR_PER16_TRX

AMT_CR_QTR01_LOC AMT_CR_QTR04_LOC

AMT_CR_QTR01_PCNTR AMT_CR_QTR04_PCNTR

AMT_CR_QTR01_TRX AMT_CR_QTR04_TRX

AMT_CR_YTD_LOC Credit Amount Year-to-Date Local

AMT_CR_YTD_PCNTR Credit Amount Year-to-Date Profit

AMT_CR_YTD_TRX Credit Amount Year-to-Date Trans-

AMT_DR_PER_BEGIN_LOC Debit Amount Period Beginning Bal-

AMT_DR_PER_BEGIN_PCNTR Debit Amount Period Beginning Bal-

AMT_DR_PER_BEGIN_TRX Debit Amount Period Beginning Bal-

AMT_DR_PER01_LOC AMT_DR_PER16_LOC

AMT_DR_PER01_PCNTR AMT_DR_PER16_PCNTR

AMT_DR_PER01_TRX AMT_DR_PER16_TRX

AMT_DR_QTR01_LOC AMT_DR_QTR04_LOC

AMT_DR_QTR01_PCNTR AMT_DR_QTR04_PCNTR

Description

ance Transaction Currency Credit Amount Period 1 - 16 Local

Currency Credit Amount Period 1 - 16 Profit

Center Currency Credit Amount Period 1 - 16 Trans-

action Currency Credit Amount Quarter 1 - 4 Local

Currency Credit Amount Quarter 1 - 4 Profit

Center Currency Credit Amount Quarter 1 - 4 Trans-

action Currency

Currency

Center Currency

action Currency

ance Local Currency

ance Profit Center Currency

ance Transaction Currency Debit Amount Period 1 - 16 Local

Currency Debit Amount Period 1 - 16 Profit

Center Currency Debit Amount Period 1 - 16 Transac-

tion Currency Debit Amount Quarter 1 - 4 Local

Currency Debit Amount Quarter 1 - 4 Profit

Center Currency

62 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Rapid Mart Subject Areas

Profit Center Summary Section

PROFIT_CENTER_SUMMARY_ FACT_HZ Measure Column Name

AMT_DR_QTR01_TRX AMT_DR_QTR04_TRX

AMT_DR_YTD_LOC Debit Amount Year-to-Date Local

AMT_DR_YTD_PCNTR Debit Amount Year-to-Date Profit

AMT_DR_YTD_TRX Debit Amount Year-to-Date Transac-

QTY_CR_PER_BEGIN Credit Quantity Period Beginning

QTY_CR_PER01 QTY_CR_PER16

QTY_CR_QTR01 QTY_CR_QTR04

QTY_CR_YTD Credit Quantity Year-to-Date QTY_DR_PER_BEGIN Debit Quantity Period Beginning Bal-

QTY_DR_PER01 QTY_DR_PER16

QTY_DR_QTR01 QTY_DR_QTR04

QTY_DR_YTD Debit Quantity Year-to-Date

Description

Debit Amount Quarter 1 - 4 Transaction Currency

Currency

Center Currency

tion Currency

Balance Credit Quantity Period 1 - 16

Credit Quantity Quarter 1 - 4

ance Debit Quantity Period 1 - 16

Debit Quantity Quarter 1 - 4

PROFIT_CENTER_SUMMARY_FACT_VR:

PROFIT_CENTER_SUMMARY_ FACT_VR Measure Column Name

AMT_CR_LOC Credit Amount this Fiscal Period

AMT_CR_PCNTR Credit Amount this Fiscal Period

AMT_CR_TRX Credit Amount this Fiscal Period

AMT_CR_YTD_LOC Credit Amount Year-to-Date Local

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 63

Description

Local Currency

Profit Center Currency

Transaction Currency

Currency

Rapid Mart Subject Areas

Profit Center Summary Section

PROFIT_CENTER_SUMMARY_ FACT_VR Measure Column Name

AMT_CR_YTD_PCNTR Credit Amount Year-to-Date Profit

AMT_CR_YTD_TRX Credit Amount Year-to-Date Transac-

AMT_DR_LOC Debit Amount this Fiscal Period Local

AMT_DR_PCNTR Debit Amount this Fiscal Period Profit

AMT_DR_TRX Debit Amount this Fiscal Period

AMT_DR_YTD_LOC Debit Amount Year-to-Date Local

AMT_DR_YTD_PCNTR Debit Amount Year-to-Date Profit

AMT_DR_YTD_TRX Debit Amount Year-to-Date Transac-

AMT_PER_BEGIN_LOC Period Beginning Balance Local Cur-

AMT_PER_BEGIN_PCNTR Period Beginning Balance Profit Cen-

AMT_PER_BEGIN_TRX Period Beginning Balance Transac-

AMT_PER_ROLLING_LOC Rolling 16 Periods Balance Local

AMT_PER_ROLLING_PCNTR Rolling 16 Periods Balance Profit

AMT_PER_ROLLING_TRX Rolling 16 Periods Balance Transac-

AMT_PTD_LOC Period-to-Date Amount Local Cur-

AMT_PTD_PCNTR Period-to-Date Amount Profit Center

AMT_PTD_TRX Period-to-Date Amount Profit Center

QTY_CR Credit Quantity this Fiscal Period QTY_CR_YTD Credit Quantity Year-to-Date

Description

Center Currency

tion Currency

Currency

Center Currency

Transaction Currency

Currency

Center Currency

tion Currency

rency

ter Currency

tion Currency

Currency

Center Currency

tion Currency

rency

Currency

64 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Rapid Mart Subject Areas

Profit Center Summary Section

PROFIT_CENTER_SUMMARY_ FACT_VR Measure Column Name

QTY_DR Debit Quantity this Fiscal Period QTY_DR_YTD Debit Quantity Year-to-Date QTY_PER_BEGIN Period Beginning Quantity QTY_PER_ROLLING Rolling 16 Periods Quantity QTY_PTD Period-to-Date Quantity

Rapid Mart Data

The PROFIT_CENTER_SUMMARY_FACT_HZ and PROFIT_CENTER_SUMMARY_FACT_VR are represented in the Star Schema below along with associated hierarchy and stage tables.

Description

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 65

Rapid Mart Subject Areas

General Ledger Account Hierarchies

You can analyze profit center summary transactions along several dimensions:

• By Fiscal Periods (Fiscal Year, Quarter, Month)

• By Monetary Currencies

• By Financial Organization:

• Company Code

• Controlling Area

• Functional Area

• By Profit Center and Profit Center Hierarchies

• By General Ledger Account and Associated Hierarchies

• By Segment (New GL only)

• By Cost Version

• By Unit of Measure

Using the profit center transactions section, you can answer questions like:

• Which Profit Centers bring in the most revenue for the last 5 years?

• How did my profit center perform this year versus last year?

• What is the revenue period trend for selected accounts within selected

Profit Centers or Profit Center groups?

• How does my income statement for this year compare to last year?

• How does the revenue trend look this year?

• How does budget compare to actuals by each profit center for this year

broken by fiscal periods?

• How did my profit center perform this year versus last year?

How does last year period trend compare to this year for each profit center within the same group?

General Ledger Account Hierarchies

SAP solutions incorporates several hierarchies based on General Ledger account as the lowest level (leaf) of the hierarchy. In the BusinessObjects Cost Center Rapid Mart, we’ve combined these disparate sources into a single master hierarchy that facilitates reporting by any of the included hierarchies.

The hierarchies included are visible in two separate transactions in SAP solutions

66 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Rapid Mart Subject Areas

General Ledger Account Hierarchies

• Sets Hierarchies (Transaction GS03). Set hierarchies can be set up

with items other than a GL Account as the leaf level. For this reason, we only include information for two of the Set Hierarchies in the Rapid Mart.

• GLT0-RACCT - The FI Standard Ledger GL Account Hierarchy

• GLPCT-RACCT - The EC-PCA Profit Center GL Account Hierarchy

Here is a screen shot of GS03 showing how this hierarchy is presented in SAP solutions:

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 67

Rapid Mart Subject Areas

General Ledger Account Hierarchies

• Financial St atement s V ersion Hierarchies (Transaction FSE3). These

hierarchies are used to generate financial statements. Leaf levels are always a GL Account. All of these hierarchies are included in the Rapid Mart. Here is a screen shot of FSE3 showing how this hierarchy is presented in SAP solutions:

This flexible master hierarchy allows you to report by alternative hierarchies that may not be available in SAP.

Example: In SAP solutions the EC-PCA Profit Center Standard Ledger

allows reporting by the GLPCT-RACCT hierarchy, but not the GLT0-RACCT hierarchy. In the Rapid Mart, you can report by either, or both.

You can use hierarchies as dimensions in your operational reports. You can also report on the hierarchies by themselves to examine how your organization is structured, and fine tune that organization.

68 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Reports

chapter

Reports

Overview

You can use the SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions to perform adhoc analysis and produce many kinds of reports. This chapter provides examples of reports you could generate using the Cost Center Rapid Mart universes. The information in this chapter is useful for those who design reporting solutions for Cost and Profitability analysis.

This chapter describes content of Web Intelligence (WEBI) reports shipped with the and the Rapid Mart Reporting Content package and recommended joins for each componentized section in the Rapid Mart, including:

• Cost Details

• Cost Summary

• Profit Center Details

• Profit Center Summary

• SAP Master Data Reports

Note that all report SQL is located in the Rapid Mart installation directory under "\Sample\DDL".

Cost Details

Cost details (or cost accounting transactions) are extracted from SAP solutions’s Controlling accounting module. You can use this information to analyze incurred costs within each Controlling Area and/or Company Code by Cost Elements and several cost objects, such as Cost Center, Activity, Internal Order, Project Element.

Reports

Using the cost detail information, you can complete numerous analyses and generate different reports including the following examples:

• Transaction Summary by Material

• Transaction Detail Listing

• Top 10 Vendor Cost Accounting Docs

70 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Transaction Summary by Material

View a Controlling Area transaction summary for each Vendor by Material. The results are limited to a single Fiscal Year and Fiscal Period.This report offers drill-down capability, by allowing the user to select a Material and open the Transaction Detail Listing to review all cost details.

Reports

Cost Details

Report SQL

SELECT DISTINCT FISC_PERIOD_CTRL_AREA.FISC_YEAR, FISC_PERIOD_CTRL_AREA.FISC_PERIOD, sum(COST_TRANSACTION_F ACT.AMT_CTRL_AREA), MATERIAL.MTRL_DESCR, VENDOR.VENDOR_NAME_01, sum(COST_TRANSACTION_FACT.AMT_FIXED_CTRL_AREA), sum(COST_TRANSACTION_F ACT.AMT_VAR_CTRL_AREA), sum(COST_TRANSACTION_FACT.AMT_FIXED_VAR_CTRL_AREA), CURRENCY_CTRL_AREA.CURR_ISO_CODE, CONTROLLING_AREA.CTRL_AREA_ID, COST_CENTER_HIER_HZ.LVL_00_ID, CONTROLLING_AREA.CTRL_AREA_FULL_NAME FROM CONTROLLING_AREA, COST_TRANSACTION_FA CT, MATERIAL, VENDOR, FINANCIAL_RECORD_TYPE, CURRENCY CURRENCY_CTRL_AREA,

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 71

Reports

Cost Details

FISC_PERIOD FISC_PERIOD_CTRL_AREA, COST_CENTER_HIER_HZ WHERE ( CONTROLLING_AREA.CTRL_AREA_ID =

COST_TRANSACTION_FACT.CTRL_AREA_ID )

AND ( COST_TRANSACTION_FACT.MATERIAL_ID =

MATERIAL.MATERIAL_ID ) AND ( COST_TRANSACTION_FACT.VENDOR_ID = VENDOR.VENDOR_ID ) AND ( FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID =

COST_TRANSACTION_FACT.RECORD_TYPE_ID and

FINANCIAL_RECORD_TYPE.DIM_SRC_ID = 'COST' ) AND (

CURRENCY_CTRL_AREA.CURR_ID=COST_TRANSACTION_FACT.CURR_I

D_CTRL_AREA ) AND (

COST_TRANSACTION_FACT.FISC_PERIOD=FISC_PERIOD_CTRL_AREA.FI

SC_PERIOD and COST_TRANSACTION_FACT.FISC_YEAR=FISC_PERIOD_CTRL_AREA.FISC_YE

AR and COST_TRANSACTION_FACT.FISC_YR_VARIANT_ID_CTRL_AREA =

FISC_PERIOD_CTRL_AREA.FISC_YR_VARIANT_ID ) AND (

COST_CENTER_HIER_HZ.COST_CNTR_ID=COST_TRANSACTION_FACT.C

OST_CNTR_ID and

COST_CENTER_HIER_HZ.CTRL_AREA_ID=COST_TRANSACTION_FACT.C

TRL_AREA_ID ) AND ( FISC_PERIOD_CTRL_AREA.FISC_YEAR = 2000 AND FISC_PERIOD_CTRL_AREA.FISC_PERIOD = 1 AND FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID = '04' AND MATERIAL.MTRL_DESCR <> '?' AND CONTROLLING_AREA.CTRL_AREA_FULL_NAME = '1000 - CO Europe' ) GROUP BY FISC_PERIOD_CTRL_AREA.FISC_YEAR, FISC_PERIOD_CTRL_AREA.FISC_PERIOD, MATERIAL.MTRL_DESCR, VENDOR.VENDOR_NAME_01, CURRENCY_CTRL_AREA.CURR_ISO_CODE, CONTROLLING_AREA.CTRL_AREA_ID, COST_CENTER_HIER_HZ.LVL_00_ID, CONTROLLING_AREA.CTRL_AREA_FULL_NAME

72 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Transaction Detail Listing

View detailed Controlling Area cost information for a selected Cost Center Hierarchy and Material. The results are limited to a single Fiscal Year and Fiscal Period.

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DDL".

Top 10 Vendor Cost Accounting Docs

View the Top 10 Vendor Cost Accounting documents (for selected calendar year and month); grouped by Controlling Area. This report uses the Web Intelligence ranking feature to limit to the top 10 documents by Actual V alue in Controlling Area Currency.

Reports

Cost Details

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DDL".

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 73

Reports

Cost Details

Recommended Table Joins

To analyze Cost Details data you will need to create joins between the fact and dimension tables as follows

Note: Additional joins between dimension and hierarchy tables are shown in

“Recommended table joins” on page 27 for master reports.

Fact Table Dimension Table Join Text

COST_TRANSACTION_F ACT

ACTIVITY ACTIVITY.ACTIVITY_ID=COST_TRANSACTION_FA

ACTIVITY_HIER_HZ ACTIVITY_HIER_HZ.ACTIVITY_ID=COST_TRANSA

ACTIVITY_HIER_VR COST_TRANSACTION_FACT.CTRL_AREA_ID=ACT

BUSINESS_AREA BUSINESS_AREA.BUS_AREA_ID =

CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS.CHART_OF_ACCT_ID=C

COMPANY_CODE COMPANY_CODE.CMPNY_CODE_ID =

CONTROLLING_AREA CONTROLLING_AREA.CTRL_AREA_ID =

CONTROLLING_TRANS ACTION

COST_CENTER COST_CENTER.COST_CNTR_ID=COST_TRANSA

COST_CENTER_HIER_HZCOST_CENTER_HIER_HZ.COST_CNTR_ID=COST

COST_CENTER_HIER_VRCOST_TRANSACTION_FACT.CTRL_AREA_ID=CO

COST_ELEMENT COST_ELEMENT.CHART_OF_ACCT_ID=COST_TR

CT.ACTIVITY_ID and ACTIVITY.CTRL_AREA_ID=COST_TRANSACTION_ FACT.CTRL_AREA_ID

CTION_FACT.ACTIVITY_ID and ACTIVITY_HIER_HZ.CTRL_AREA_ID=COST_TRAN SACTION_FACT.CTRL_AREA_ID

IVITY_HIER_VR.CTRL_AREA_ID and COST_TRANSACTION_FACT.ACTIVITY_ID=ACTIVI TY_HIER_VR.CHILD_ID

COST_TRANSACTION_FACT.BUS_AREA_ID

OST_TRANSACTION_FACT.CHART_OF_ACCT_ID

COST_TRANSACTION_FACT.CMPNY_CODE_ID

COST_TRANSACTION_FACT.CTRL_AREA_ID CONTROLLING_TRANSACTION.CTRL_TRX_ID =

COST_TRANSACTION_FACT.CTRL_TRX_ID

CTION_FACT.COST_CNTR_ID and COST_CENTER.CTRL_AREA_ID=COST_TRANSAC TION_FACT.CTRL_AREA_ID

_TRANSACTION_FACT.COST_CNTR_ID and COST_CENTER_HIER_HZ.CTRL_AREA_ID=COST_ TRANSACTION_FACT.CTRL_AREA_ID

ST_CENTER_HIER_VR.CTRL_AREA_ID and COST_TRANSACTION_FACT.COST_CNTR_ID=CO ST_CENTER_HIER_VR.CHILD_ID

ANSACTION_FACT.CHART_OF_ACCT_ID and COST_ELEMENT.COST_ELEM_ID=COST_TRAN SA CTION_FACT.COST_ELEM_ID

74 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Fact Table Dimension Table Join Text

COST_TRANSACTION_F ACT

COST_ELEMENT_HIER_HZCOST_TRANSACTION_FACT.COST_ELEM_ID=CO

COST_ELEMENT_HIER_VRCOST_TRANSACTION_FACT.CHART_OF_ACCT_I

CURRENCY CURRENCY.CURR_ID =

CURRENCY CURRENCY.CURR_ID=COST_TRANSACTION_FAC

DEBIT_CREDIT_INDICATORDEBIT_CREDIT_INDICATOR.DR_CR_ID=COST_TR

FINANCIAL_RECORD_T YPE

FINANCIAL_VERSION FINANCIAL_VERSION.LEDGER_ID = 'COST and

FISC_PERIOD COST_TRANSACTION_FACT.FISC_PERIOD=FISC_

FUNCTIONAL_AREA COST_TRANSACTION_FACT.FUNCTNL_AREA_ID

FUNCTIONAL_AREA_HI ER_HZ

FUNCTIONAL_AREA_HI ER_VR

ST_ELEMENT_HIER_HZ.COST_ELEM_ID and COST_TRANSACTION_FACT.CHART_OF_ACCT_I D=COST_ELEMENT_HIER_HZ.CHART_OF_ACCT_ ID

D=COST_ELEMENT_HIER_VR.CHART_OF_ACCT_ ID and COST_TRANSACTION_FACT.COST_ELEM_ID=CO ST_ELEMENT_HIER_VR.CHILD_ID

COST_TRANSACTION_FACT.CURR_ID_OBJ

T.CURR_ID_CTRL_AREA

T.CURR_ID_TRX

ANSACTION_FACT.DR_CR_ID and DEBIT_CREDIT_INDICATOR.DIM_SRC_ID = 'COST'

FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID = COST_TRANSACTION_FACT.RECORD_TYPE_ID and FINANCIAL_RECORD_TYPE.DIM_SRC_ID = 'COST'

FINANCIAL_VERSION.VERSION_ID = COST_TRANSACTION_FACT.VERSION_ID and FINANCIAL_VERSION.DIM_SRC_ID = 'COST'

PERIOD.FISC_PERIOD and COST_TRANSACTION_FACT.FISC_YEAR=FISC_P ERIOD.FISC_YEAR and COST_TRANSACTION_FACT.FISC_YR_VARIANT_I D_CTRL_AREA = FISC_PERIOD.FISC_YR_VARIANT_ID

PERIOD.FISC_PERIOD and COST_TRANSACTION_FACT.FISC_YEAR=FISC_P ERIOD.FISC_YEAR and COST_TRANSACTION_FACT.FISC_YR_VARIANT_I D_CMPNY_CODE = FISC_PERIOD.FISC_YR_VARIANT_ID

= FUNCTIONAL_AREA.FUNCTNL_AREA_ID COST_TRANSACTION_FACT.FUNCTNL_AREA_ID

= FUNCTIONAL_AREA_HIER_HZ.FUNCTNL_AREA_I D

COST_TRANSACTION_FACT.FUNCTNL_AREA_ID = FUNCTIONAL_AREA_HIER_VR.CHILD_ID

Reports

Cost Details

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 75

Reports

Cost Details

Fact Table Dimension Table Join Text

COST_TRANSACTION_F ACT

GL_ACCOUNT_BY_COM PANY

INTERNAL_ORDER INTERNAL_ORDER.INTERNAL_ORDER_ID =

INTERNAL_ORDER_HIE R_HZ

INTERNAL_ORDER_HIE R_VR

MATERIAL COST_TRANSACTION_FACT.MATERIAL_ID =

MATERIAL_BY_PLANT COST_TRANSACTION_FACT.PLANT_ID =

OBJECT_CLASS OBJECT_CLASS.OBJ_CLASS_ID =

OBJECT_TYPE COST_TRANSACTION_FACT.OBJ_TYPE_ID =

PLANT COST_TRANSACTION_FACT.PLANT_ID =

PROJECT COST_TRANSACTION_FACT.PROJ_ID=PROJECT.

PROJECT_ELEMENT COST_TRANSACTION_FACT.PROJ_ELEM_ID=PR

PROJECT_ELEMENT_HI ER_HZ

PROJECT_ELEMENT_HI ER_VR

TIME_DIM TIME_DIM.CALENDAR_DATE=COST_TRANSACTI

UNIT_OF_MEASURE COST_TRANSACTION_FACT.UOM_ID=UNIT_OF_M

VENDOR COST_TRANSACTION_FACT.VENDOR_ID =

COST_TRANSACTION_FACT.CHART_OF_ACCT_I D=GL_ACCOUNT_BY_COMPANY.CHART_OF_ACC T_ID and COST_TRANSACTION_FACT.GL_ACCT_ID=GL_AC COUNT_BY_COMPANY.GL_ACCT_ID and COST_TRANSACTION_FACT.CMPNY_CODE_ID=G L_ACCOUNT_BY_COMPANY.CMPNY_CODE_ID

COST_TRANSACTION_FACT.INTERNAL_ORDER_I D

COST_TRANSACTION_FACT.INTERNAL_ORDER_I D = INTERNAL_ORDER_HIER_HZ.INTERNAL_ORDER_ ID

COST_TRANSACTION_FACT.INTERNAL_ORDER_I D=INTERNAL_ORDER_HIER_VR.CHILD_ID

MATERIAL.MATERIAL_ID

MATERIAL_BY_PLANT.PLANT_ID AND COST_TRANSACTION_FACT.MATERIAL_ID = MATERIAL_BY_PLANT.MATERIAL_ID

COST_TRANSACTION_FACT.OBJ_CLASS_ID

OBJECT_TYPE.OBJ_TYPE_ID AND OBJECT_TYPE.DIM_SRC_ID = 'COST'

PLANT.PLANT_ID

PROJ_ID

OJECT_ELEMENT.PROJ_ELEM_ID COST_TRANSACTION_FACT.PROJ_ELEM_ID=PR

OJECT_ELEMENT_HIER_HZ.PROJ_ELEM_ID COST_TRANSACTION_FACT.PROJ_ELEM_ID=PR

OJECT_ELEMENT_HIER_VR.CHILD_ID

ON_FACT.CREATE_DATE

ON_FACT.POST_DATE

EASURE.UOM_ID

VENDOR.VENDOR_ID

76 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Cost Summary

The cost summary contains cost transaction balances by fiscal period. The summary data is presented in horizontal format, where each period balance is stored in a separate column (up to 16 periods), and in vertical format, where there is an individual record for each fiscal period.

You can use this information to analyze planned versus actual costs and to determine the variance within each Controlling Area and/or Company Code by Cost Elements and several cost objects, such as Cost Center, Activity, Internal Order, Project Element.

Reports

Using the cost summary information, you can complete numerous analyses and generate different reports including the following examples:

• Cost Center Actual-Planned-Variance

• Cost Center Activities

• Cost Summary Trend by Cost Center

• Cost Summary Trend by Cost Element

• YTD Cost Drilldown by Activity and Cost Center

• Cost Summary Actuals Analysis

• Cost Summary Rolling 12 Periods vs. Period Comparison

Reports

Cost Summary

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 77

Reports

Cost Summary

Cost Center Actual-Planned-Variance

View Cost Center Actual/Planned/Variance and Top 10 Analysis for a specified Fiscal Year and Fiscal Period range.

by Cost Element Summary

Analyze Cost Center Actual/Planned/Variance values for a Controlling Area over a selected Fiscal Year and Fiscal Period range.

78 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Reports

Cost Summary

Top 10 Analysis

View basic Top 10 Analysis; including Top 10 Cost Centers by Actual Value and Planning Efficiency Analysis (based on variance%).

Web Intelligence ranking

feature to limit to the top 10 Cost Centers.

This report uses the

Report SQL

SELECT DISTINCT sum(case when FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID = '04' AND FINANCIAL_VERSION.VERSION_ID = '000' THEN

COST_SUMMARY_FACT_VR.AMT_DR_CTRL_AREA-

COST_SUMMARY_FACT_VR.AMT_CR_CTRL_AREA else 0 end), sum(case when FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID = '01' AND FINANCIAL_VERSION.VERSION_ID = '000' THEN

COST_SUMMARY_FACT_VR.AMT_DR_CTRL_AREA-

COST_SUMMARY_FACT_VR.AMT_CR_CTRL_AREA else 0 end), FISC_PERIOD_CTRL_AREA.FISC_YEAR, FISC_PERIOD_CTRL_AREA.FISC_QUARTER, FISC_PERIOD_CTRL_AREA.FISC_PERIOD, CURRENCY_CTRL_AREA.CURR_ISO_CODE, COST_ELEMENT.COST_ELEM_FULL_NAME, COST_CENTER.COST_CNTR_FULL_NAME FROM

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 79

Reports

Cost Summary

FINANCIAL_VERSION, FINANCIAL_RECORD_TYPE, COST_SUMMARY_FACT_VR, FISC_PERIOD FISC_PERIOD_CTRL_AREA, CURRENCY CURRENCY_CTRL_AREA, COST_ELEMENT, COST_CENTER, CONTROLLING_AREA WHERE (

COST_SUMMARY_FACT_VR.FISC_PERIOD=FISC_PERIOD_CTRL_AREA.FI SC_PERIOD and

COST_SUMMARY_FACT_VR.FISC_YEAR=FISC_PERIOD_CTRL_AREA.FISC_YE

AR and

COST_SUMMARY_FACT_VR.FISC_YR_VARIANT_ID_CTRL_AREA =

FISC_PERIOD_CTRL_AREA.FISC_YR_VARIANT_ID )

AND (

CONTROLLING_AREA.CTRL_AREA_ID=COST_SUMMARY_FACT_VR.CTR L_AREA_ID )

AND (

CURRENCY_CTRL_AREA.CURR_ID=COST_SUMMARY_FACT_VR.CURR_I D_CTRL_AREA )

AND (

COST_SUMMARY_FACT_VR.COST_CNTR_ID=COST_CENTER.COST_CNT R_ID and COST_SUMMARY_FACT_VR.CTRL_AREA_ID=COST_CENTER.CTRL_ARE A_ID )

AND (

COST_ELEMENT.CHART_OF_ACCT_ID=COST_SUMMARY_FACT_VR.CHA RT_OF_ACCT_ID and COST_ELEMENT.COST_ELEM_ID=COST_SUMMARY_FACT_VR.COST_ELE M_ID )

AND (

FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID=COST_SUMMARY_FACT_ VR.RECORD_TYPE_ID and FINANCIAL_RECORD_TYPE.DIM_SRC_ID = 'COST' )

AND (

FINANCIAL_VERSION.VERSION_ID=COST_SUMMARY_FACT_VR.VERSIO

N_ID and FINANCIAL_VERSION.DIM_SRC_ID = 'COST' ) AND ( CONTROLLING_AREA.CTRL_AREA_ID = '1000' AND FISC_PERIOD_CTRL_AREA.FISC_YEAR = 2000 ) GROUP BY FISC_PERIOD_CTRL_AREA.FISC_YEAR, FISC_PERIOD_CTRL_AREA.FISC_QUARTER, FISC_PERIOD_CTRL_AREA.FISC_PERIOD, CURRENCY_CTRL_AREA.CURR_ISO_CODE, COST_ELEMENT.COST_ELEM_FULL_NAME, COST_CENTER.COST_CNTR_FULL_NAME

80 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Cost Center Activities

View Cost Center summary by Activity for a specified Controlling Area, including Actual/Planned/Variance amounts by Activity.

Reports

Cost Summary

Top 10 Analysis

View Top 10 Cost centers according to highest Variance%. This report uses

the Web Intelligence ranking

on Variance%.

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 81

feature to limit to the Top 10 Cost Centers based

Reports

Cost Summary

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DDL".

Cost Summary Trend by Cost Center

View Cost Center period trends for a selected fiscal year. View graphical analysis of cost summary data to analyze cost center planning efficiency . This report offers drill down capability in order to further analyze cost details in

Transaction Summary by Material.

by Actual Values

82 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Reports

Cost Summary

by Variance%

Cost Center Analysis

View overall Variance vs. Actual Value and Cost Center Actual Value Trends by Fiscal Month.

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DDL".

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 83

Reports

Cost Summary

Cost Summary Trend by Cost Element

View Cost Element period trends for a selected fiscal year. View graphical analysis of cost summary data to analyze cost center planning efficiency.

by Actual Value

84 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Cost Summary

by Variance%

Cost Element Analysis

View overall Variance vs. Actual Value and Cost Elements Actual Value Trends by Fiscal Month.

Reports

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DDL".

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 85

Reports

Cost Summary

YTD Cost Drilldown by Activity and Cost Center

View YTD cost summary breakdown (for a specified Controlling Area) by Activities or Cost Centers.

by Activity

86 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

by Cost Center

Reports

Cost Summary

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DDL".

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 87

Reports

Cost Summary

Cost Summary Actuals Analysis

View Cost Summary actuals trend analysis by Controlling Area for the selected Company Code, and Fiscal Year.

Actual Balance by Quarter

88 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Actual Balance by Period

Reports

Cost Summary

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DDL".

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 89

Reports

Cost Summary

Cost Summary Rolling 12 Periods vs. Period Comparison

View Cost Rolling 12 periods versus Actual PTD Balances for the selected Fiscal Years.

By Company

90 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

By Cost Center

Reports

Cost Summary

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DDL".

Recommended Table Joins

To analyze Cost Summary data you will need to create joins between the fact and dimension tables as follows

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 91

Reports

Cost Summary

Note: Additional joins between dimension and hierarchy tables are shown in

“Recommended table joins” on page 27 for master reports.

Fact Table Dimension Table Join Text

COST_SUMMARY_FACT _HZ

ACTIVITY ACTIVITY.CTRL_AREA_ID=COST_SUMMARY_FAC

ACTIVITY_HIER_HZ COST_SUMMARY_FACT_HZ.CTRL_AREA_ID=ACT

ACTIVITY_HIER_VR COST_SUMMARY_FACT_HZ.CTRL_AREA_ID=ACT

BUSINESS_AREA BUSINESS_AREA.BUS_AREA_ID=COST_SUMMAR

CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS.CHART_OF_ACCT_ID=C

COMPANY_CODE COMPANY_CODE.CMPNY_CODE_ID=COST_SUM

CONTROLLING_AREA CONTROLLING_AREA.CTRL_AREA_ID=COST_SU

CONTROLLING_TRANS ACTION

COST_CENTER COST_SUMMARY_FACT_HZ.CTRL_AREA_ID=COS

COST_CENTER_HIER_HZCOST_SUMMARY_FACT_HZ.CTRL_AREA_ID=COS

COST_CENTER_HIER_VRCOST_SUMMARY_FACT_HZ.CTRL_AREA_ID=COS

COST_ELEMENT COST_ELEMENT.CHART_OF_ACCT_ID=COST_SU

COST_ELEMENT_HIER_HZCOST_SUMMARY_FACT_HZ.COST_ELEM_ID=CO

T_HZ.CTRL_AREA_ID and ACTIVITY.ACTIVITY_ID=COST_SUMMARY_FACT_ HZ.ACTIVITY_ID

IVITY_HIER_HZ.CTRL_AREA_ID and COST_SUMMARY_FACT_HZ.ACTIVITY_ID=ACTIVI TY_HIER_HZ.ACTIVITY_ID

IVITY_HIER_VR.CTRL_AREA_ID and COST_SUMMARY_FACT_HZ.ACTIVITY_ID=ACTIVI TY_HIER_VR.CHILD_ID

Y_FACT_HZ.BUS_AREA_ID

OST_SUMMARY_FACT_HZ.CHART_OF_ACCT_ID

MARY_FACT_HZ.CMPNY_CODE_ID

MMARY_FACT_HZ.CTRL_AREA_ID CONTROLLING_TRANSACTION.CTRL_TRX_ID=C

OST_SUMMARY_FACT_HZ.CTRL_TRX_ID

T_CENTER.CTRL_AREA_ID and COST_SUMMARY_FACT_HZ.COST_CNTR_ID=CO ST_CENTER.COST_CNTR_ID

T_CENTER_HIER_HZ.CTRL_AREA_ID and COST_SUMMARY_FACT_HZ.COST_CNTR_ID=CO ST_CENTER_HIER_HZ.COST_CNTR_ID

T_CENTER_HIER_VR.CTRL_AREA_ID and COST_SUMMARY_FACT_HZ.COST_CNTR_ID=CO ST_CENTER_HIER_VR.CHILD_ID

MMARY_FACT_HZ.CHART_OF_ACCT_ID and COST_ELEMENT.COST_ELEM_ID=COST_SUMMA RY_FACT_HZ.COST_ELEM_ID

ST_ELEMENT_HIER_HZ.COST_ELEM_ID and COST_SUMMARY_FACT_HZ.CHART_OF_ACCT_ID =COST_ELEMENT_HIER_HZ.CHART_OF_ACCT_I D

92 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Fact Table Dimension Table Join Text

COST_SUMMARY_FACT _HZ

COST_ELEMENT_HIER_VRCOST_SUMMARY_FACT_HZ.CHART_OF_ACCT_ID

COST_SUMMARY_FACT _HZ

CURRENCY CURRENCY.CURR_ID=COST_SUMMARY_FACT_H

FINANCIAL_RECORD_T YPE

FINANCIAL_VERSION FINANCIAL_VERSION.LEDGER_ID = 'COST' and

GL_ACCOUNT_BY_COM PANY

INTERNAL_ORDER COST_SUMMARY_FACT_HZ.INTERNAL_ORDER_I

INTERNAL_ORDER_HIE R_HZ

INTERNAL_ORDER_HIE R_VR

OBJECT_CLASS OBJECT_CLASS.OBJ_CLASS_ID=COST_SUMMAR

OBJECT_TYPE COST_SUMMARY_FACT_HZ.OBJ_TYPE_ID=OBJE

PROJECT COST_SUMMARY_FACT_HZ.PROJ_ID=PROJECT.

PROJECT_ELEMENT COST_SUMMARY_FACT_HZ.PROJ_ELEM_ID=PR

=COST_ELEMENT_HIER_VR.CHART_OF_ACCT_I D and COST_SUMMARY_FACT_HZ.COST_ELEM_ID=CO ST_ELEMENT_HIER_VR.CHILD_ID

COST_SUMMARY_FACT_HZ.FISC_YEAR=COST_S UMMARY_FACT_HZ.PARTITION_YEAR

Z.CURR_ID_TRX

Z.CURR_ID_CTRL_AREA

Z.CURR_ID_OBJ

Z.CURR_ID_LOC FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID=C

OST_SUMMARY_FACT_HZ.RECORD_TYPE_ID and FINANCIAL_RECORD_TYPE.DIM_SRC_ID = 'COST'

FINANCIAL_VERSION.VERSION_ID=COST_SUMM ARY_FACT_HZ.VERSION_ID and FINANCIAL_VERSION.DIM_SRC_ID = 'COST'

GL_ACCOUNT_BY_COMPANY.CHART_OF_ACCT_I D=COST_SUMMARY_FACT_HZ.CHART_OF_ACCT _ID and GL_ACCOUNT_BY_COMPANY.CMPNY_CODE_ID= COST_SUMMARY_FACT_HZ.CMPNY_CODE_ID and GL_ACCOUNT_BY_COMPANY.GL_ACCT_ID=COST _SUMMARY_FACT_HZ.COST_ELEM_ID

D=INTERNAL_ORDER.INTERNAL_ORDER_ID COST_SUMMARY_FACT_HZ.INTERNAL_ORDER_I

D = INTERNAL_ORDER_HIER_HZ.INTERNAL_ORDER_ ID

COST_SUMMARY_FACT_HZ.INTERNAL_ORDER_I D=INTERNAL_ORDER_HIER_VR.CHILD_ID

Y_FACT_HZ.OBJ_CLASS_ID

CT_TYPE.OBJ_TYPE_ID AND OBJECT_TYPE.DIM_SRC_ID = 'COST'

PROJ_ID

OJECT_ELEMENT.PROJ_ELEM_ID

Reports

Cost Summary

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 93

Reports

Cost Summary

Fact Table Dimension Table Join Text

COST_SUMMARY_FACT _HZ

COST_SUMMARY_FACT _VR

PROJECT_ELEMENT_HI ER_HZ

PROJECT_ELEMENT_HI ER_VR

UNIT_OF_MEASURE COST_SUMMARY_FACT_HZ.UOM_ID=UNIT_OF_M

ACTIVITY ACTIVITY.CTRL_AREA_ID=COST_SUMMARY_FAC

ACTIVITY_HIER_HZ COST_SUMMARY_FACT_VR.CTRL_AREA_ID=ACT

ACTIVITY_HIER_VR COST_SUMMARY_FACT_VR.CTRL_AREA_ID=ACT

BUSINESS_AREA BUSINESS_AREA.BUS_AREA_ID=COST_SUMMAR

CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS.CHART_OF_ACCT_ID=C

COMPANY_CODE COMPANY_CODE.CMPNY_CODE_ID=COST_SUM

CONTROLLING_AREA CONTROLLING_AREA.CTRL_AREA_ID=COST_SU

CONTROLLING_TRANS ACTION

COST_CENTER COST_SUMMARY_FACT_VR.COST_CNTR_ID=CO

COST_CENTER_HIER_HZCOST_SUMMARY_FACT_VR.CTRL_AREA_ID=CO

COST_CENTER_HIER_VRCOST_SUMMARY_FACT_VR.CTRL_AREA_ID=CO

COST_ELEMENT COST_ELEMENT.CHART_OF_ACCT_ID=COST_SU

COST_ELEMENT_HIER_HZCOST_SUMMARY_FACT_VR.COST_ELEM_ID=CO

COST_SUMMARY_FACT_HZ.PROJ_ELEM_ID=PR OJECT_ELEMENT_HIER_HZ.PROJ_ELEM_ID

COST_SUMMARY_FACT_HZ.PROJ_ELEM_ID=PR OJECT_ELEMENT_HIER_VR.CHILD_ID

EASURE.UOM_ID

T_VR.CTRL_AREA_ID and ACTIVITY.ACTIVITY_ID=COST_SUMMARY_FACT_ VR.ACTIVITY_ID

IVITY_HIER_HZ.CTRL_AREA_ID and COST_SUMMARY_FACT_VR.ACTIVITY_ID=ACTIVI TY_HIER_HZ.ACTIVITY_ID

IVITY_HIER_VR.CTRL_AREA_ID and COST_SUMMARY_FACT_VR.ACTIVITY_ID=ACTIVI TY_HIER_VR.CHILD_ID

Y_FACT_VR.BUS_AREA_ID

OST_SUMMARY_FACT_VR.CHART_OF_ACCT_ID

MARY_FACT_VR.CMPNY_CODE_ID

MMARY_FACT_VR.CTRL_AREA_ID CONTROLLING_TRANSACTION.CTRL_TRX_ID=C

OST_SUMMARY_FACT_VR.CTRL_TRX_ID

ST_CENTER.COST_CNTR_ID and COST_SUMMARY_FACT_VR.CTRL_AREA_ID=CO ST_CENTER.CTRL_AREA_ID

ST_CENTER_HIER_HZ.CTRL_AREA_ID and COST_SUMMARY_FACT_VR.COST_CNTR_ID=CO ST_CENTER_HIER_HZ.COST_CNTR_ID

ST_CENTER_HIER_VR.CTRL_AREA_ID and COST_SUMMARY_FACT_VR.COST_CNTR_ID=CO ST_CENTER_HIER_VR.CHILD_ID

MMARY_FACT_VR.CHART_OF_ACCT_ID and COST_ELEMENT.COST_ELEM_ID=COST_SUMMA RY_FACT_VR.COST_ELEM_ID

ST_ELEMENT_HIER_HZ.COST_ELEM_ID and COST_SUMMARY_FACT_VR.CHART_OF_ACCT_I D=COST_ELEMENT_HIER_HZ.CHART_OF_ACCT_ ID

94 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Fact Table Dimension Table Join Text

COST_SUMMARY_FACT _VR

COST_ELEMENT_HIER_VRCOST_SUMMARY_FACT_VR.CHART_OF_ACCT_I

COST_SUMMARY_FACT _VR

CURRENCY CURRENCY.CURR_ID=COST_SUMMARY_FACT_V

FINANCIAL_RECORD_T YPE

FINANCIAL_VERSION FINANCIAL_VERSION.LEDGER_ID = 'COST' and

FISC_PERIOD COST_SUMMARY_FACT_VR.FISC_PERIOD=FISC_

GL_ACCOUNT_BY_COM PANY

INTERNAL_ORDER COST_SUMMARY_FACT_VR.INTERNAL_ORDER_I

INTERNAL_ORDER_HIE R_HZ

D=COST_ELEMENT_HIER_VR.CHART_OF_ACCT_ ID and COST_SUMMARY_FACT_VR.COST_ELEM_ID=CO ST_ELEMENT_HIER_VR.CHILD_ID

COST_SUMMARY_FACT_VR.FISC_YEAR=COST_S UMMARY_FACT_VR.PARTITION_YEAR

R.CURR_ID_TRX

R.CURR_ID_CTRL_AREA

R.CURR_ID_OBJ

R.CURR_ID_LOC FINANCIAL_RECORD_TYPE.RECORD_TYPE_ID=C

OST_SUMMARY_FACT_VR.RECORD_TYPE_ID and FINANCIAL_RECORD_TYPE.DIM_SRC_ID = 'COST'

FINANCIAL_VERSION.VERSION_ID=COST_SUMM ARY_FACT_VR.VERSION_ID and FINANCIAL_VERSION.DIM_SRC_ID = 'COST'

PERIOD.FISC_PERIOD and COST_SUMMARY_FACT_VR.FISC_YEAR=FISC_P ERIOD.FISC_YEAR and COST_SUMMARY_FACT_VR.FISC_YR_VARIANT_I D_CTRL_AREA = FISC_PERIOD.FISC_YR_VARIANT_ID

PERIOD.FISC_PERIOD and COST_SUMMARY_FACT_VR.FISC_YEAR=FISC_P ERIOD.FISC_YEAR and COST_SUMMARY_FACT_VR.FISC_YR_VARIANT_I D_CMPNY_CODE = FISC_PERIOD.FISC_YR_VARIANT_ID

GL_ACCOUNT_BY_COMPANY.CHART_OF_ACCT_I D=COST_SUMMARY_FACT_VR.CHART_OF_ACCT _ID and GL_ACCOUNT_BY_COMPANY.CMPNY_CODE_ID= COST_SUMMARY_FACT_VR.CMPNY_CODE_ID and GL_ACCOUNT_BY_COMPANY.GL_ACCT_ID=COST _SUMMARY_FACT_VR.COST_ELEM_ID

D=INTERNAL_ORDER.INTERNAL_ORDER_ID COST_SUMMARY_FACT_VR.INTERNAL_ORDER_I

D = INTERNAL_ORDER_HIER_HZ.INTERNAL_ORDER_ ID

Reports

Cost Summary

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 95

Reports

Cost Summary

Fact Table Dimension Table Join Text

COST_SUMMARY_FACT _VR

INTERNAL_ORDER_HIE R_VR

OBJECT_CLASS OBJECT_CLASS.OBJ_CLASS_ID=COST_SUMMAR

OBJECT_TYPE COST_SUMMARY_FACT_VR.OBJ_TYPE_ID=OBJE

PROJECT COST_SUMMARY_FACT_VR.PROJ_ID=PROJECT.

PROJECT_ELEMENT COST_SUMMARY_FACT_VR.PROJ_ELEM_ID=PR

PROJECT_ELEMENT_HI ER_HZ

PROJECT_ELEMENT_HI ER_VR

UNIT_OF_MEASURE COST_SUMMARY_FACT_VR.UOM_ID=UNIT_OF_M

COST_SUMMARY_FACT_VR.INTERNAL_ORDER_I D=INTERNAL_ORDER_HIER_VR.CHILD_ID

Y_FACT_VR.OBJ_CLASS_ID

CT_TYPE.OBJ_TYPE_ID AND OBJECT_TYPE.DIM_SRC_ID = 'COST'

PROJ_ID

OJECT_ELEMENT.PROJ_ELEM_ID COST_SUMMARY_FACT_VR.PROJ_ELEM_ID=PR

OJECT_ELEMENT_HIER_HZ.PROJ_ELEM_ID COST_SUMMARY_FACT_VR.PROJ_ELEM_ID=PR

OJECT_ELEMENT_HIER_VR.CHILD_ID

EASURE.UOM_ID

96 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Profit Center Details

The Profit Center Detail section obtains information from the EC-PCA Profit Center Accounting Standard Ledger in SAP ERP and R/3. Profit Center Details contain actual and planned (or budget) transactions for profit centers. You can use this information to analyze profit center performance and trends within each Controlling Area and/or Company Code by Cost Elements, Cost Centers, Profit Centers, and other accounting transaction attributes.

Profit Center Detail data is organized horizontally and vertically.

Profit Center Details - Horizontal

In horizontal organization, a single row in the table represents an entire fiscal year’s worth of data, with separate fields for monetary amounts in each fiscal period.

Reports

Using the profit center detail horizontal information, you can complete numerous analyses. A single report, Profit Center Detail Trend Analysis, is included as an example of how to use this horizontal summary data.

Reports

Profit Center Details

Profit Center Detail Trend Analysis

Analyze Profit Center detail statistics for selected Fiscal Years and Local Currency. Results displayed by Customer Geography and Profit Center.

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 97

Reports

Profit Center Details

Calculations

All Average Debit amounts are calculated as:

• Avg Debit Amt 01 = [PC DTL Hz Line Debit Amt Period 01 LOC]/[PC DTL

Hz Document Count Period 01]

Report SQL

SELECT DISTINCT COMPANY_CODE.CMPNY_CODE_NAME, PROFIT_CENTER_FACT_HZ.FISC_YEAR, PROFIT_CENTER.DEPARTMENT, SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then

PROFIT_CENTER_FACT_HZ.AMT_PER_BEGIN_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then

PROFIT_CENTER_FACT_HZ.AMT_PER_BEGIN_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then

PROFIT_CENTER_FACT_HZ.AMT_PER01_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then

PROFIT_CENTER_FACT_HZ.AMT_PER01_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then

PROFIT_CENTER_FACT_HZ.AMT_PER02_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then

PROFIT_CENTER_FACT_HZ.AMT_PER02_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then

PROFIT_CENTER_FACT_HZ.AMT_PER03_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then

PROFIT_CENTER_FACT_HZ.AMT_PER03_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then

PROFIT_CENTER_FACT_HZ.AMT_PER04_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then

PROFIT_CENTER_FACT_HZ.AMT_PER04_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then

PROFIT_CENTER_FACT_HZ.AMT_PER05_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then

PROFIT_CENTER_FACT_HZ.AMT_PER06_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then

PROFIT_CENTER_FACT_HZ.AMT_PER06_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then

PROFIT_CENTER_FACT_HZ.AMT_PER07_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then

PROFIT_CENTER_FACT_HZ.AMT_PER07_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then

PROFIT_CENTER_FACT_HZ.AMT_PER08_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then

PROFIT_CENTER_FACT_HZ.AMT_PER08_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then

PROFIT_CENTER_FACT_HZ.AMT_PER09_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then

PROFIT_CENTER_FACT_HZ.AMT_PER09_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then

PROFIT_CENTER_FACT_HZ.AMT_PER10_LOC else 0 end), SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then

PROFIT_CENTER_FACT_HZ.AMT_PER10_LOC else 0 end),

98 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

Reports

Profit Center Details

SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then

PROFIT_CENTER_FACT_HZ.AMT_PER11_LOC else 0 end),

SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then

PROFIT_CENTER_FACT_HZ.AMT_PER11_LOC else 0 end),

SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'H' then

PROFIT_CENTER_FACT_HZ.AMT_PER12_LOC else 0 end),

SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then

PROFIT_CENTER_FACT_HZ.AMT_PER12_LOC else 0 end),

SUM(case when PROFIT_CENTER_FACT_HZ.DR_CR_ID = 'S' then

PROFIT_CENTER_FACT_HZ.AMT_PER05_LOC else 0 end), PROFIT_CENTER_F ACT_HZ.CURR_ID_LOC, CUSTOMER.COUNTRY_NAME, CUSTOMER.REGION_NAME, CUSTOMER.CITY, PROFIT_CENTER.PROFIT_CNTR_FULL_NAME, COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER01_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER02_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER03_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER04_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER05_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER06_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER07_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER08_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER09_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER10_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER11_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER12_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER13_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER14_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER15_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), COUNT(DISTINCT case when PROFIT_CENTER_FACT_HZ.AMT_PER16_TRX !=

0 then PROFIT_CENTER_FACT_HZ.SURROGATE_DOC_ID else 0 end), CUSTOMER.CUSTOMER_FULL_NAME FROM COMPANY_CODE, PROFIT_CENTER_F ACT_HZ, PROFIT_CENTER, CUSTOMER WHERE ( COMPANY_CODE.CMPNY_CODE_ID =

PROFIT_CENTER_FACT_HZ.CMPNY_CODE_ID )

SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide 99

Reports

Profit Center Details

AND (

PROFIT_CENTER_FACT_HZ.PROFIT_CNTR_ID=PROFIT_CENTER.PROFIT_ CNTR_ID and PROFIT_CENTER_FACT_HZ.CTRL_AREA_ID=PROFIT_CENTER.CTRL_ARE A_ID )

AND (

PROFIT_CENTER_FACT_HZ.CUSTOMER_ID=CUSTOMER.CUSTOMER_ID ) AND ( ( PROFIT_CENTER_FACT_HZ.RECORD_TYPE_ID='0' ) AND PROFIT_CENTER_FACT_HZ.FISC_YEAR In @prompt('Fiscal Year(s):','N','Prof

Cntr Hz - Dates & Fiscal Periods\Fiscal Year',Multi,Free,Persistent,,User:0) AND PROFIT_CENTER_FACT_HZ.CURR_ID_LOC = @prompt('Local Currency

Id:','A','Prof Cntr Hz - Monetary Currency\Local Currency

Id',Mono,Free,Persistent,,User:1) ) GROUP BY COMPANY_CODE.CMPNY_CODE_NAME, PROFIT_CENTER_FACT_HZ.FISC_YEAR, PROFIT_CENTER.DEPARTMENT, PROFIT_CENTER_FACT_HZ.CURR_ID_LOC, CUSTOMER.COUNTRY_NAME, CUSTOMER.REGION_NAME, CUSTOMER.CITY, PROFIT_CENTER.PROFIT_CNTR_FULL_NAME, CUSTOMER.CUSTOMER_FULL_NAME

Profit Center Details - Vertical

In vertical organization, a single row represents a single fiscal period. There is a separate row for each fiscal period / fiscal year combination.

Reports

Using the profit center detail vertical information, you can complete numerous analyses and generate different reports including the following examples:

• Profit Center Trend Activity Analysis

• Top 10 Profit Centers Actual/Planned/Variance

• Profit Center Listing

Profit Center Trend Activity Analysis

View Profit Center period activity trends and Top 10 Analysis for a selected Profit Center hierarchy and Controlling Area during the desired fiscal year and period range.

This report contains two tabs; Profit Center Trend and Top 10 Analysis.

100 SAP BusinessObjects Cost Center Rapid Mart XI 3.2 for SAP solutions User Guide

SAP BusinessObjects Cost Center Rapid 3.2 User Manual

Specifications and Main Features

Frequently Asked Questions

User Manual

Contents

Introduction

What is a Rapid Mart?

Rapid Marts packages accelerate Time to Value

SAP BusinessObjects Rapid Marts packages architecture

About this document

Overview

Overview

What you can do with this Rapid Mart

Supported analyses

Dimensions available to support these analyses

Related Rapid Marts

Fitting into the accounting process

SAP BusinessObjects Cost Center Rapid Mart Schema

Rapid Mart Subject Areas

Overview

Cost Analysis Basics

Cost Objects

Cost Centers

Internal Orders

Project Elements

Activities

Financial Organization Structure

Cost Elements

Profit Centers

Projects

Vendors

Accounting Hierarchies

Cost Transaction Section

Rapid Mart Processing

Fact Table Fields

Rapid Mart Data

Cost Summary Section

Rapid Mart Processing

Fact Table Fields

Rapid Mart Data

Profit Center Detail Section

Overview

Rapid Mart Processing

Dimensions

Fact Table Fields

Rapid Mart Data

Profit Center Summary Section

Overview

Rapid Mart Processing

Dimensions

Fact Table Fields

Rapid Mart Data

General Ledger Account Hierarchies

Reports

Reports

Overview

Cost Details

Transaction Summary by Material

Transaction Detail Listing

Top 10 Vendor Cost Accounting Docs

Recommended Table Joins

Cost Summary

Reports

Cost Center Actual-Planned-Variance

Cost Center Activities

Cost Summary Trend by Cost Center

Cost Summary Trend by Cost Element

YTD Cost Drilldown by Activity and Cost Center

Cost Summary Actuals Analysis

Cost Summary Rolling 12 Periods vs. Period Comparison

Recommended Table Joins

Profit Center Details

Profit Center Details - Horizontal

Reports

Reports

Profit Center Details - Vertical