Oracle ABM Analyzer

1y ago
7 Views
2 Downloads
1.36 MB
122 Pages
Last View : 1m ago
Last Download : 2m ago
Upload by : Javier Atchley
Transcription

Oracle ABM Analyzer User Guide Release 11i December 2001 Part No. A90840-02

Oracle ABM Analyzer User Guide, Release 11i Part No. A90840-02 Copyright 1996, 2001, Oracle Corporation. All rights reserved. Primary Author: Frank Colligan Contributing Authors: Michael Casey, Scott Date, Srinivasan Jandyala, Steven Roepke, Lauren Schwartz, Dan Sinnreich The Programs (which include both the software and documentation) contain proprietary information of Oracle Corporation; they are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright, patent and other intellectual and industrial property laws. Reverse engineering, disassembly or decompilation of the Programs, except to the extent required to obtain interoperability with other independently created software or as specified by law, is prohibited. The information contained in this document is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. Oracle Corporation does not warrant that this document is error-free. Except as may be expressly permitted in your license agreement for these Programs, no part of these Programs may be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle Corporation. If the Programs are delivered to the U.S. Government or anyone licensing or using the programs on behalf of the U.S. Government, the following notice is applicable: Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are "commercial computer software" and use, duplication, and disclosure of the Programs, including documentation, shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, Programs delivered subject to the Federal Acquisition Regulations are "restricted computer software" and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR 52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle Corporation, 500 Oracle Parkway, Redwood City, CA 94065. The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be the licensee's responsibility to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle Corporation disclaims liability for any damages caused by such use of the Programs. Oracle is a registered trademark, and Oracle Discoverer is a trademark or registered trademark of Oracle Corporation. Other names may be trademarks of their respective owners.

Contents Send Us Your Comments . vii Preface. ix 1 Introduction What is Oracle ABM?. What is Oracle Discoverer?. Basic Features of ABM Analyzer . The ABM Analyzer Integration Process. ABM Analyzer Integration . 2 1-1 1-2 1-2 1-3 1-4 Using Workbooks Opening Workbooks and Duplicating Sheets . Creating New Worksheets. Using Tools. Conditions . Sorts . Totals . Percentages . Calculations . Parameters . Sharing Workbooks. Exporting Data to Excel. Data Variance. 2-2 2-7 2-8 2-8 2-12 2-14 2-16 2-18 2-19 2-21 2-23 2-25 iii

For Further Information. 2-26 3 Standard Workbooks Worksheets in Standard Workbooks. Case Study . Departments Workbook . Worksheets . Department Account . Department Statistic . Department Workbook Hierarchy . Examples of Using Hierarchy in Report. Activity Workbook. Activity Cost Account . Activity Statistic . Activity Rate . Activity Rate Set. Driver Volume. Activity Driver Source . RE or Department Driver Source . Activity Workbook Hierarchy . Materials Workbook . Material Account Report . Material Statistic Report . Material Cost Report . Material Workbook Hierarchy. Cost Objects Workbook . Cost Object Detail . Cost Object Account . Cost Object Statistic . Cost Object Revenue and Cost. Cost Objects Workbook Hierarchy. Data Set Hierarchy. Model Export Using Discoverer Worksheets. Using Specific Export Files . Using Any Extract Worksheet . iv 3-2 3-3 3-15 3-15 3-16 3-17 3-20 3-21 3-22 3-23 3-24 3-25 3-26 3-27 3-28 3-29 3-29 3-31 3-31 3-32 3-32 3-33 3-33 3-34 3-37 3-39 3-40 3-41 3-42 3-44 3-45 3-46

The Bill Item Extract . 3-46 Opening Export Workbooks . 3-46 Verifying and Saving Bill Item Worksheet Data. 3-46 4 Adding Optional Attributes Creating Attributes and Attribute Values. Creating Attribute Folders in the End User Layer. Creating Business Views for Attributes . Add the Attribute Folder to the End User Layer . Set the Folder Item Properties in Administration Edition. Joining Attribute Folders to Business Area Detail Folders. Using ABM Attributes in Reports . 4-2 4-6 4-6 4-7 4-11 4-17 4-23 5 Security The ABM Security Model . ABM Analyzer Security. Example. Securable Objects . Business Area Privileges . 5-1 5-2 5-3 5-3 5-4 Index v

vi

Send Us Your Comments Oracle ABM Analyzer User Guide, Release 11i Part No. A90840-02 Oracle Corporation welcomes your comments and suggestions on the quality and usefulness of this document. Your input is an important part of the information used for revision. Did you find any errors? Is the information clearly presented? Do you need more information? If so, where? Are the examples correct? Do you need more examples? What features did you like most? If you find any errors or have any other suggestions for improvement, please indicate the document title and part number, and the chapter, section, and page number (if available). You can send comments to us in the following ways: Electronic mail: fsdocmail@us.oracle.com FAX: (650) 506-7200. Attn: Oracle Financials Documentation Manager Postal service: Oracle Corporation Oracle Financials Documentation Manager 500 Oracle Parkway Redwood Shores, CA 94065 USA If you would like a reply, please give your name, address, telephone number, and (optionally) electronic mail address. If you have problems with the software, please contact your local Oracle Support Services. vii

viii

Preface This user guide is the primary reference for Release 11i of Oracle ABM Analyzer. It contains detailed discussions of product features and functions, plus procedures, case studies, and examples. The preface explains how the user guide is organized and introduces other sources of information. Product Overview Oracle ABM Analyzer is a relational online analytical processing (OLAP) reporting and analysis application. It was created specifically for activity-based management (ABM) and works in conjunction with Oracle Discoverer tools. ABM Analyzer enables users throughout an organization to easily generate multidimensional, custom reports without writing code. ABM Analyzer is part of Oracle Applications is an integrated suite of more than 45 software modules for financial management, supply chain management, manufacturing, project systems, human resources, and sales and service management. Intended Audience This guide is intended for system administrators, database managers, consultants, and other users of ABM Analyzer. ix

How the User Guide is Structured This book is divided into the following chapters. There is also an index. Chapter 1 Chapter 1 provides a brief introduction to ABM Analyzer, ABM, and Discoverer. Chapter 2 Chapter 2 discusses how to use, create, copy, and customize ABM Analyzer workbooks. Chapter 3 Chapter 3 describes the four standard workbooks available in ABM Analyzer. Chapter 4 Chapter 4 explains how to add ABM attribute folders to a worksheet. Chapter 5 Chapter 5 explains how to secure ABM data and limit access to secured ABM objects. Assumptions It is assumed that you have the requisite knowledge and skills for your business area. If you are an administrator, you are familiar with the Discoverer Administration Edition. If you are a user, you are familiar with activity-based management, Oracle ABM, and the Discoverer User Edition. Related Documents The following are reference materials for products related to ABM Analyzer: Oracle Activity-Based Management User Guide This guide covers activity-based management, setting up activities and cost objects, flex-budgeting, and standard reports. x

Oracle Discoverer User Guide This guide explains how to use Discoverer to access, view, and analyze data in your database, and how to produce reports. Oracle Discoverer User Tutorial This tutorial helps the user to quickly learn Discoverer. Oracle Discoverer Administration Guide This guide enables database administrators to prepare database data in a manner that facilitates use. Oracle Activity-Based Management Installation Guide This guide explains how to install ABM, ABM Analyzer, and SEM Exchange. Oracle Discoverer Installation and Upgrade Guide This guide contains instructions for installing Discoverer, the demonstration database, and the tutorial examples. It also describes how to migrate existing Discoverer/2000 End-User Layer to the latest version of Discoverer. Modifying Oracle Applications Data It is strongly recommended that you use only Oracle Applications to modify table data within Oracle Applications. There are at least three reasons for this. First, Oracle Applications tables are interrelated, and revising one table causes related tables to be updated automatically. Second, the system reviews your changes to ensure their validity. Third, the system keeps track of who made the changes and when they were made. If you enter information into database tables using database tools, you risk storing invalid information. Also, you cannot track who has changed your information because SQL*Plus and other database tools do not keep a record of changes. Caution: Oracle strongly recommends that you never use SQL*Plus or any other tool to modify Oracle Applications data unless otherwise instructed. xi

Conventions The following conventions are used in this book: Convention Meaning . . . Vertical ellipsis points in an example mean that information not directly related to the example has been omitted. . Horizontal ellipsis points in statements or commands mean that parts of the statement or command not directly related to the example have been omitted boldface text Boldface type in text indicates a term defined in the text, the glossary, or in both locations. italic text Italic type indicates a term defined in the text, the glossary, or in both locations. It can also represent a variable and be used to provide emphasis. Menu name Command Text in this format conveys a sequence of choices. For example, choose the menu and then the command under that menu. courier text Text in this format indicates a command line to be typed. Angle brackets enclose user-supplied names. [] Brackets enclose optional clauses from which you can choose one or none. Oracle Products and Support Oracle Corporation is the second largest software company in the world. It is also the leading supplier of software for information management, with products and services being used in more than 140 countries. Oracle provides an integrated line of software for database management, applications development, decision support, and office automation. These products are available for mainframes, minicomputers, personal computers, network computers, and personal digital assistants. They enable organizations to integrate various computers, operating systems, networks, and database management systems into a single, unified resource. In addition to software, Oracle provides consulting, education, and support services. xii

1 Introduction ABM Analyzer is a reporting and analysis application. It enables you to navigate the Oracle ABM database using Oracle Discoverer, and to compare details across dimensions such as time periods, accounts, customers, and products. ABM Analyzer also enables you to customize reports by using such Discoverer functions as drilling, pivoting, and sorting data. ABM Analyzer automates the manual procedures required to run a report in ABM. This chapter contains the following sections: What is Oracle ABM? What is Oracle Discoverer? Basic Features of ABM Analyzer The ABM Analyzer Integration Process ABM Analyzer Integration What is Oracle ABM? Oracle ABM is an enterprise-wide, activity-based costing (ABC) and management application that supports any ABC methodology in any industry. ABM provides flexible modeling, which enables profit and loss analysis to occur at any level of the organization. Activity-based analysis of profitability provides a new foundation for making decisions about customers, products, and services. It also facilitates volume-based forecasting of expenses, capacity, and resources. The Oracle ABM solution includes both ABM Analyzer and SEM Exchange. (SEM stands for Strategic Enterprise Management.) SEM Exchange enables you to completely integrate with Oracle General Ledger those auditable monetary amounts that are the source of operating expenses viewed in ABM. Introduction 1-1

What is Oracle Discoverer? What is Oracle Discoverer? Oracle Discoverer is a multidimensional relational online analytical processing (OLAP) and reporting tool. The Discoverer Administration Edition enables a system administrator to customize the End User Layer so that users can instantly access specific, predefined reports. The Discoverer User Edition enables users to navigate and construct reports, select data items based on the existing relational structure, and to perform advanced data edits. Basic Features of ABM Analyzer The following are basic features of ABM Analyzer: Built-in multidimensional reports on ABM objects (such as departments, activities, materials, and cost objects) for cost and profitability analysis. Sophisticated security model allows access control over models and period data sets. Wizards automate query definitions of SQL for accessing ABM tables. Supports a mix of dynamic and precomputed queries to optimize performance. This feature is invisible to the user. With ABM Analyzer, you can do the following: Define attribute sets for presenting data in new dimensions. Rapidly create new ABM reports from a list of predefined dimensions on ABM data. Add and remove dimensions from reports by selecting folders and items in ABM Analyzer. Drill up or down through predefined ABM hierarchies. Store workbooks in the database for enterprise-wide distribution. 1-2 Perform cost variance analysis by comparing actual, budgeted, or forecast amounts. Extract model data and structure from ABM and import into another model or separate ABM instance. Oracle ABM Analyzer User Guide

The ABM Analyzer Integration Process The ABM Analyzer Integration Process The process of integrating ABM and Discoverer with ABM Analyzer involves four tasks and an optional fifth step. They are as follows: 1. Install Discoverer and ABM. ABM Analyzer needs both ABM and Discoverer to be installed. Refer to the Oracle ABM Installation Guide, the Oracle Discoverer Administration Guide, and the Oracle Discoverer User Guide for details. 2. Define EUL and Business Areas. The system administrator, using Discoverer Administration Edition, creates the End User Layer and installs the ABM Analyzer business areas and workbooks. Refer to the Oracle ABM Installation Guide for more information. 3. Set Up Security. The system administrator defines users and roles through Oracle Applications. The administrator also grants business area security privileges to users and responsibilities. Refer to the Oracle ABM Installation Guide for additional information. 4. Load or Create Workbooks. The system administrator loads or creates workbooks using Oracle Discoverer User Edition. 5. Add Attributes to Worksheets (Optional). The administrator, using Discoverer Administration Edition, customizes the ABM Analyzer workbooks. Each attribute adds a new dimension to a worksheet. Introduction 1-3

ABM Analyzer Integration Figure 1–1 illustrates the ABM Analyzer integration process. Figure 1–1 Process Flow for ABM Analyzer Integration ABM Analyzer Integration The ABM Analyzer administrator installs and configures the business areas, assigns business area access to users, and installs the ABM Analyzer workbooks. Users are predefined in the Oracle Applications environment. The administrator can create new business areas or add attributes to existing business areas at any time. Users access ABM Analyzer workbooks through Oracle Discoverer User Edition. 1-4 Oracle ABM Analyzer User Guide

ABM Analyzer Integration Figure 1–2 shows the architecture of the ABM Analyzer package as integrated with Discoverer and ABM. Figure 1–2 ABM Analyzer System Introduction 1-5

ABM Analyzer Integration 1-6 Oracle ABM Analyzer User Guide

2 Using Workbooks ABM Analyzer workbooks have predefined attributes and you can add calculations, totals, and percentages to help identify trends and relationships. You can also apply special filters (conditions and parameters) to a worksheet, share workbooks with other users, and export data to Microsoft Excel. This chapter discusses how to use, create, copy, and customize workbooks. It is broken into sections as follows: Opening Workbooks and Duplicating Sheets Creating New Worksheets Using Tools Sharing Workbooks Exporting Data to Excel Data Variance For Further Information Using Workbooks 2-1

Opening Workbooks and Duplicating Sheets Opening Workbooks and Duplicating Sheets This section describes how to open an existing workbook or duplicate worksheets in a different format. How To Open an Existing Workbook 2-2 1. Log in to Discoverer User Edition with your user name and password. 2. From within Discoverer User Edition, select Open an Existing Workbook. 3. Select Database as the location of the workbook. 4. Select Next to continue. Oracle ABM Analyzer User Guide

Opening Workbooks and Duplicating Sheets A list of workbooks stored in your ABM database appears. 5. Select a workbook from the list and choose Open. Using Workbooks 2-3

Opening Workbooks and Duplicating Sheets A progress screen displays while the last opened sheet in your workbook is formatted for viewing. When formatting is complete, your workbook opens to the sheet that was active when the workbook was previously open. 2-4 Oracle ABM Analyzer User Guide

Opening Workbooks and Duplicating Sheets How To Make a Copy of an Existing Worksheet 1. Open the worksheet in Discoverer User Edition. 2. To duplicate your sheet as a crosstab, select Sheet, then Duplicate as Crosstab. To copy your sheet as a table, select Sheet, then Duplicate as Table. 3. Customize the placement of row and column headers by using the Layout tab. 4. Select Options. 5. In the Sheet Format tab, choose whether to show a title, cell grid lines, or row numbers, and how to display null values. You can also select a maximum number of rows to display per page. Using Workbooks 2-5

Opening Workbooks and Duplicating Sheets 6. Select the Query Governor tab. 7. Choose when to use summary data. You can also set warnings if a query is predicted to exceed a time limit, or limit query time or the volume of data that a query returns. 8. When you are finished, choose OK. ABM Analyzer generates a duplicate worksheet. 2-6 Oracle ABM Analyzer User Guide

Creating New Worksheets Creating New Worksheets You can create a new worksheet within a standard workbook to include dimensions for different analyses. In doing so, you can select from a list of folders available for the standard business areas, or from the folders created by the system administrator when new business areas are defined. How To Create a New Worksheet 1. From the File menu, select New to create a worksheet. 2. Select a format for the worksheet: The Table and Page-Detail Table lists data in rows and columns. The Crosstab and Page-Detail Crosstab lists data in rows and columns that you can pivot, displaying data in more than two dimensions. For example, one row could contain a period dimension underneath which one or more dimensions are grouped (such as product line or department). 3. Choose Next. 4. To include an item in your new worksheet, highlight the item in the Available list and choose Add (the button pointing to the Selected list). Note: Items not associated with one of the four ABM Analyzer business areas, or business areas to which the system administrator has granted access, are not included in the Available column. However, the system administrator can use the join feature in Discoverer to join folders between different business areas. For more information on using the join feature, see Oracle Discoverer Administrator’s Guide. When you create a new workbook or new worksheet for an existing workbook, a wizard displays all of the folders available for a business area. In the following example, the Activities business area contains three standard folders: Activity Rates, Activity Rate Sets, and Activity Rate Data Sets. Using Workbooks 2-7

Using Tools 5. Choose OK to finish creating your worksheet. Using Tools Discoverer User Edition contains tools for customizing workbooks. For example, you can apply filters so that a worksheet displays only data meeting certain criteria, such as revenue greater than a given amount. You can add totals and percentages, creating new summary rows or columns of data. This makes data easier to present and helps in identifying trends and relationships. In addition, you can add custom calculations that relate items in the worksheet, such as a field that displays data for all accounts where the account department is the same as the material department. Conditions A condition is a logical relationship between an item or calculation and another item, another calculation, or a parameter. A logical relationship means that one entity is greater than, equal to, or less than the other. A parameter is a placeholder for a condition requiring values to be entered upon activation. (See "Parameters".) 2-8 Oracle ABM Analyzer User Guide

Using Tools ABM Analyzer uses conditions to limit or filter the data it returns for a given worksheet. This enables you to view, without modifying the base data, only records in which data for a certain field exceeds or falls below a given threshold or meets a more complex logical condition. You can create conditions in the Discoverer Administration Edition and add them to business areas for later incorporation into your workbooks. The following section describes how to add conditions to ABM Analyzer workbooks from within Discoverer User Edition. F

Chapter 1 provides a brief introduction to ABM Analyzer, ABM, and Discoverer. Chapter 2 Chapter 2 discusses how to use, create, copy, and customize ABM Analyzer workbooks. Chapter 3 Chapter 3 describes the four standard workbooks available in ABM Analyzer. Chapter 4 Chapter 4 explains how to add ABM attribute folders to a worksheet. Chapter 5

Related Documents:

Oracle e-Commerce Gateway, Oracle Business Intelligence System, Oracle Financial Analyzer, Oracle Reports, Oracle Strategic Enterprise Management, Oracle Financials, Oracle Internet Procurement, Oracle Supply Chain, Oracle Call Center, Oracle e-Commerce, Oracle Integration Products & Technologies, Oracle Marketing, Oracle Service,

Leadspace for Account-Based Marketing ABM has real, proven value for B2B ABM has the highest ROI of any B2B marketing strategy or tactic 60% of companies using ABM report increased revenue within one year 80% of B2B revenue comes from 20% of customers Leadspace solves the biggest problem with ABM Leadspace brings together predictive scoring, B2B data enrichment, and the ability

2.5 Installing Oracle Trace File Analyzer on Microsoft Windows in Non-Daemon Mode 2-4 2.6 Oracle Trace File Analyzer Key Directories 2-4 2.7 Oracle Trace File Analyzer Command Interfaces 2-5 2.8 Masking Sensitive Data 2-5 2.9 Securing Access to Oracle Trace File Analyzer 2-6 2.10 Uninstalling Oracle Trace File Analyzer 2-7iii

Oracle is a registered trademark and Designer/2000, Developer/2000, Oracle7, Oracle8, Oracle Application Object Library, Oracle Applications, Oracle Alert, Oracle Financials, Oracle Workflow, SQL*Forms, SQL*Plus, SQL*Report, Oracle Data Browser, Oracle Forms, Oracle General Ledger, Oracle Human Resources, Oracle Manufacturing, Oracle Reports,

New Features for Oracle Trace File Analyzer 18.1.1 xxxii New Features for Oracle Trace File Analyzer 18.2.0 xxxiii New Features for Oracle Trace File Analyzer 18.3.0 xxxv New Features for Oracle Trace File Analyzer 18.4.1 xxxvii 1 Introduction to Oracle Autonomous Health Framework 1.1 Oracle Autonomous Health Framework Problem and Solution .

Laporan Tahunan ABM 2016 B 2016 ABM Annual Report Menuju Masa Depan yang Berkelanjutan Keberhasilan ABM dalam menjalankan strategi diversifikasi dengan berlandaskan pada semangat untuk meningkatkan efisiensi di seluruh lini operasi sepanjang tahun 2016 membuat ABM tak hanya mampu mencetak laba bersih, tetapi juga siap menyambut tahun-tahun .

advances of ABM in social, ecological, and socio-ecological systems, compare ABM with other traditional, equation-based models, provide guidelines for ABM novice, modelers, and reviewers, and point out the chal-lenges and impending tasks that need to be addressed for the ABM community. We further point out great op-

ANsi A300 (Part 9) and isA bMP as they outline how risk tolerance affects risk rating, from fieldwork to legal defense, and we wanted to take that into account for the Unitil specification. The definitions and applications of the following items were detailed: