Table of Contents
- Title and Copyright Information
- Documentation Accessibility
- Documentation Feedback
- 1 Creating and Running an EPM Center of Excellence
-
Part I Getting Started with Enterprise Profitability and Cost Management
- About Enterprise Profitability and Cost Management
- About Enterprise Profitability and Cost Management Applications
- Launching the Application
- About the Home Page
- About the Standardized Cloud EPM Platform Artifact Pages
- Using Dynamic Tabs
- Considerations When Using the Application Interface
- Downloading and Installing Smart View
- Managing Your Enterprise Profitability and Cost Management Implementation
- De-Support of Legacy Features
-
Part II Creating and Managing Applications
- 2 Creating an Enterprise Profitability and Cost Management Application
-
3
Managing Applications
- Application Overview
- Managing Cubes
-
Managing Dimensions
- Dimension Overview
- Best Practices When Designing Dimensions
- Creating a Dimension
- Accessing the Dimension Editor
- Reviewing Dimensions
- Editing Dimension Properties
-
Working with Members
- Adding Members to a Dimension
- Adding "No<dimname>" Members
- Editing Member Properties
- Deleting Members
- Adding Shared Members
- Assigning Access to Dimension Members
-
Working in the Edit Member Properties Grid
- Switching to Another Dimension
- Customizing the Column Layout
- Context Menu Options
- Viewing Ancestors
- Showing Member Usage in an Application
- Focusing Your Editing
- Finding Members
- Moving Members
- Sorting Members
- Moving Members to Another Hierarchy
- Working with Member Formulas
- Copying Member Names from Microsoft Excel
- Working with Attributes
- Importing and Exporting Dimension Metadata
- Viewing Activity Reports
- Importing and Exporting Data
- Importing Exchange Rates for a Multicurrency Application
- Uploading and Downloading Files Using the Inbox/Outbox Explorer
- Refreshing the Application Database
- Validating Metadata
- Removing an Application
- 4 Managing Application and System Settings
-
5
Defining Valid Intersections
- Understanding Valid Intersections
- Creating Valid Intersections
-
Managing Valid Intersections
- Viewing Valid Intersections
- Filtering Valid Intersections
- Importing and Exporting Intersections
- Changing the Valid Intersection Group Evaluation Order
- Disabling and Enabling Valid Intersection Groups
- Editing Details for a Valid Intersection Group
- Duplicating Valid Intersection Groups
- Deleting a Valid Intersection Group
- Suppressing Invalid Data in Forms
- Clearing Invalid Data
- Working with Valid Intersections
- 6 Administering Data Integration
- 7 Managing Jobs
-
Part III Building and Calculating Models
- 8 Creating and Managing Models
-
9
Creating and Managing Rules
- About Rules
- Types of Rules
- Rule and Rule Member Considerations
- Dimension and Member Requirements When Creating Rules
- Understanding Model and Rule Set Context
- Understanding How System Dimensions Are Used in Rules
-
Creating Allocation Rules
- About Creating Allocation Rules
- Creating an Allocation Rule Definition
- Defining an Allocation Rule Source and Destination
- Defining an Allocation Rule Driver
- Defining an Allocation Rule Offset
- Validating Allocation Rules
- Running a Rule Data Validation Report for Allocation Rules
- Using Ad Hoc to Analyze Allocation Rule Data
- Creating Custom Calculation Rules
- Creating Rule Sets
- Creating Multiple Rules
- Creating Multiple Rule Sets
- Using the Rule Designer
- Viewing Rule Definitions
- Renaming Rules
- 10 Running Model Validation
- 11 Calculating Models
-
12
Analyzing Calculations
- About Calculation Analysis
- Filtering Which Calculation Records Are Displayed
- Generating a Calculation Statistics Summary Report
- Generating a Calculation Statistics Diagnostics Report
- Generating a Model Snapshot Documentation Report
- Generating a Compare Snapshot with Current Model Report
- Generating a Compare Model Snapshots Report
- Creating a Model from a Snapshot
- Editing Comments
- Re-Running Calculations
- Providing Feedback
- Analyzing Calculation Performance
- 13 Viewing Rule Balancing Reports
-
14
Using Profitability and Cost Management (PCM) Agent
- About Profitability and Cost Management (PCM) Agent
- Enabling Profitability and Cost Management (PCM) Agent
- Accessing Profitability and Cost Management (PCM) Agent
- Creating, Confirming, and Running Modeling and Analysis Commands
- Configuring PCM Agent for Specific Tasks
-
Part IV Analyzing Data
-
15
Working with Data in Forms
- You Enter Data in Forms
- About Forms Versions
- Viewing Forms
- Exporting Data to Microsoft Excel
-
Working in Forms 1.0
- Selecting Different Data to Work With
- Understanding Form Colors
- Viewing Server Status on Forms
- Navigating Quickly in a Form
- Basics of Working With Data
-
More About Working With Data
- Viewing Member Formulas
- Working with Business Process Data in Excel
- Drilling Through to Source Data
- Cell Icons
- Resolving Data Validation Errors
- Pushing Data for Reporting
- About Cell Comments
- Working with Attachments
- Searching for Forms, Dashboards, and Infolets
- Why Cells May Be Read-Only
- Seeing What's Changed
- Working in Forms 2.0
-
Managing Data Validation and Format Rules in Forms
- About Data Validation Rules
- About Format Rules in Forms
- 16 Working with Reports
-
17
Designing and Working with Dashboards
-
Designing Dashboards
- The Power of Dashboards
- Creating and Managing Dashboards
-
Creating and Managing Dashboards 1.0
- Concepts in Designing 1.0 Dashboards
- Creating Dashboard 1.0 Dashboards
- Creating Dashboards Containing Master Forms and Details
- About Your Dashboard's Layout - Version 1.0
- About the Gauge Chart Type
- About the Tile Chart Type
- Customizing Dashboard Colors
- About Global and Local POVs in 1.0 Dashboards
- Dashboard POVs and Valid Intersections
-
Creating and Managing Dashboards 2.0
- Concepts in Designing Dashboard 2.0 Dashboards
- Considerations for Dashboard 2.0
- Creating Dashboard 2.0 Dashboards
- Working with the Member Selector When Designing Dashboards 2.0
- About Forms 2.0 Grids in Dashboard 2.0
- Using Tables in Dashboards
- About Global and Local POVs in Dashboard 2.0
- About Quick Analysis
- About Dashboard Charts
- Dashboard Design Guidelines
-
Using Dashboards to Work with Data
- Understanding Dashboards
- About Dashboard Versions
- Viewing Dashboards
- Working with Dashboard 1.0 Dashboards
-
Working with Dashboard 2.0 Dashboards
- Working with the Dashboard 2.0 Global Toolbar
- Working with Dashboard 2.0 Components
- Working with Forms 2.0 Grids in Dashboard 2.0
- Drilling Through on Charts and Legends
- Working with POVs in Dashboard 2.0
- Opening the Member Selector in Dashboards 2.0
- Working with Dashboard 2.0 Dashboards in Navigation Flows
- Working with Master Forms and Details in Dashboard 2.0 Components
- Support for Valid Intersections in Dashboard 2.0 Dashboards
- About Quick Analysis
- Drilling into Ad Hoc from a Dashboard 2.0 Chart
-
Designing Dashboards
- 18 Viewing Key Information with Infolets
-
19
Configuring and Working with IPM
-
Configuring IPM Insights
- About IPM
- Enabling AI for Insights in Enterprise Profitability and Cost Management
- About IPM Insights
- About Using Calendars and Events in IPM Insights
- Configuring Calendars and Events
- Configuring IPM Insights
- Running and Scheduling Insights
- Managing Insight Definitions and Generated Insights
- Managing Tags
- Using IPM Insights to Inform Your Decision-Making
-
IPM Insights Metrics
- IQR (Interquartile Range)
- MAD (Mean Absolute Deviation)
- MAPE (Mean Absolute Percentage Error)
- ME (Mean Error)
- Modified Z-Score
- MPE (Mean Percentage Error)
- RMSE (Root Mean Squared Error)
- RPD (Relative Percentage Difference)
- Standard Variance
- TOTD (Total Deviation)
- TOTPD (Total Percentage Difference )
- Z-Score
- Impact Magnitude Thresholds
-
Configuring IPM Insights
-
20
Using Ad Hoc for Data Entry and Analysis
- Get Started Performing Ad Hoc
- Creating an Ad Hoc Grid
- Submitting Ad Hoc Data and Saving the Grid Definition
- Performing Calculations Without Having to Submit Your Changes (Calc on the Fly)
- Accessing an Ad Hoc Grid
- Designing Ad Hoc Grids
- Ad Hoc Grid Keyboard Shortcuts and Quick Data Entry Commands
- Applying Rules to Ad Hoc Grids
- Adding Comments and Attachments
- Adjusting Values
- Using Ad Hoc Action Menus
- About Using Line Item Details
- Printing Ad Hoc Grids
- Using Free-Form Ad Hoc
- 21 Working with Profit Curves
- 22 Tracing Allocations
-
23
Using Smart View to Import and Edit
Application Metadata
- About Using Smart View to Work with Application Metadata
- Using Smart View Grids to Import and Edit Application Metadata
- Importing Dimensions in Smart View
- Editing Members in Smart View
- Adding Application Members in Smart View
- Moving Members in Smart View
- Working with Attribute Dimensions
- Designating Shared Members in Smart View
- Refreshing Databases
- Planning Admin Extension and Office AutoCorrect
-
15
Working with Data in Forms
-
Part V Using Tools
- Customizing Your Display
- Working with Variables
- Announcing Upcoming Events
- Managing Access Control
-
Designing Custom Navigation Flows
- Understanding Navigation Flows
-
Viewing and Working with Navigation Flows
- Navigation Flow Design Best Practices and Naming Considerations
- Creating and Duplicating Navigation Flows
- Editing a Navigation Flow
- Activating and Deactivating Navigation Flows
- Previewing the Runtime View of a Navigation Flow for a User
- Using Validate to Find Missing Artifacts in Navigation Flows
- Resolving Navigation Flows that Display a Warning Icon
- Customizing Labels for Cards, Tabs, and Clusters
- Customizing Icons for Cards and Vertical Tabs
- Hiding and Unhiding Clusters, Cards, and Tabs
- Changing the Display Order of Cards on the Home Page
- Adding Cards
- Adding Tabs
- About Using URLs to Embed Third-Party Pages in Cloud EPM Applications
- Removing Navigation Flows, Cards, and Tabs
- Grouping Cards into Clusters
- Reloading a Navigation Flow
- Switching Navigation Flows at Runtime
- Sharing the Current Page URL for Cards, Tabs, and Sub Tabs
- Setting the Daily Maintenance Process Time
-
Connecting Environments in Cloud EPM
- About Connecting Cloud EPM Environments
- Considerations for Migrating Cloud EPM Connections
- Creating, Editing, and Deleting Connections to Other Cloud EPM Environments
- Connecting to External Web Services
- Specifying Advanced Options for External Connections
- Navigating Across Cloud EPM Environments
- Customizing Navigation Flows to Access Other Cloud EPM Environments
- Using Direct URLs to Integrate Connected Environments
- Using Migration
- Cloning Your Environment
- Auditing Tasks and Data
- Setting User Preferences
-
Part VI Creating and Managing Business Rules
- About Business Rules
- 24 Using Business Rules
- 25 Resources for Designing Groovy Business Rules
- Part VII Administrative Tasks Accessed from the Navigator
-
Part VIII Setting Up Access Permissions and Data Security
- 26 About Managing Access and Data Security
-
27
Working with Access Permissions
- Types of Access Permissions
- About Assigning Access Permissions
- Application Artifacts That Can Be Assigned Permissions
- Adding, Changing, and Removing Permissions to Artifacts and Folders
- Enabling or Disabling Security for Dimensions
- Reporting on Access Permissions
-
Part IX Administering and Working with Task Manager
- Overview of Using Task Manager with Enterprise Profitability and Cost Management
-
28
Administering Tasks with Task Manager
-
Setting Up Task Manager
- Task Manager Terms
- Task Manager Overview
- Sample Task Flows
- Managing Task Manager Views, Lists, and Filters
-
Managing Task Manager System Settings
- Managing Global Integration Tokens
- Managing Task Manager Organizational Units
- Managing Holiday Rules for Tasks
-
Changing Configuration Settings
- Allowing Editing and Deleting Comments
- Allowing Task Deletions
- Enabling Application Dimension Alias
- Enabling Artifact Labels
- Enabling Email Notifications
- Setting Task Manager Governors
- Allowing Reassignment Request Approvals
- Reopening Tasks
- Settings for Task Manager Reports
- Setting Export to Excel Format
- Specifying Task Display in Smart View
- Displaying Upcoming Tasks in Worklist and Welcome Panel
- Using Oracle Cloud Object Storage to Store Attachments
- Managing Task Manager Attributes
- Managing Artifact Labels in Task Manager
- Managing Task Types
-
Managing Task Templates
- Creating Task Templates
- Opening Templates
- Adding Tasks to Templates
- Editing Templates
- Importing Tasks into Templates
- Task Import File Format
- Exporting Tasks to Microsoft Excel
- Reassigning Users in Templates
- Creating Schedules from Templates
- Manually Validating Templates
- Viewing Task Manager Templates
- Searching for Templates
- Deleting Templates
-
Managing Tasks
- Creating Tasks
- Viewing Task History
- Working with the Task Dialog Box
- Importing and Exporting Tasks
- Editing Tasks
- Adding Attachments
- Sorting Tasks
- Searching for Tasks
- Moving Tasks
- Cutting, Copying, and Pasting Tasks
- Reopening Manual and Automated Tasks
- Submitting Tasks
- Approving or Rejecting Tasks
- Claiming or Releasing Tasks
- Managing Task Reassignments
- Automated Task Execution
- Canceling Tasks
- Deleting Tasks
- Managing Services
-
Managing Schedules
- Manually Creating Schedules
- Setting Required Task Parameters
- Opening Schedules
- Editing Schedules
- Adding Tasks to Schedules
- Importing Tasks into Schedules
- Updating Tasks in Schedules
- Reassigning Users in Schedules
- Authorizing Process-Automated Tasks
- Setting Schedule Status
- Viewing Schedule History
- Validating Schedules
- Locking Schedules
- Viewing Schedules
- Searching for Schedules
- Deleting Schedules
- Managing Task Manager Integrations
- Managing Alert Types for Task Manager
- Managing Views in Task Manager
- Viewing Currencies in Task Manager
- Using Reports
-
Working with Views and Filters
-
Working with Filters
- About Filters
- Viewing the Existing Saved Filters
- Creating a New Filter
- Using the Filter Bar to Adjust Your View
- Clearing Filter Conditions
- Removing a Filter
- Editing a Filter
- Duplicating a Filter
- Saving a Filter
- Applying a Saved Filter
- Publishing a Filter
- Deleting a Filter
- Displaying Columns for Filters
- Reordering Columns for Filters
-
Working with Views
- About Views
- Working With List Views
- Working with Pivot Views
- Working with Chart Views
- Working With Gantt Chart Views
- Working With Calendar Views
- Saving Views
- Editing Saved Views
- Deleting Views
- Publishing Views
- Setting a Default View
- Exporting List Views and Pivot Views
-
Working with Filters
-
Managing Dashboards
- Overview of Operational Dashboards
- Viewing and Opening Operational Dashboards
- Operational Dashboards: Design Mode
- Creating Operational Dashboards
- Setting the Object Type Within Operational Dashboards
- Specifying View Options for Operational Dashboards
- Editing Operational Dashboards
- Duplicating Operational Dashboards
- Deleting Operational Dashboards
- Exporting Operational Dashboards
- Importing Operational Dashboards
- Running Operational Dashboards
- Displaying Columns for Viewing Operational Dashboards
- Reordering Columns for Viewing Operational Dashboards
- Copying a URL for Operational Dashboards
- Applying Filters to Data Displayed Within Operational Dashboards
- Example: Task Manager Operational Dashboard
-
Setting Up Task Manager
-
29
Using Task Manager
- Working with Task Manager
- Working with Alerts
-
Working with Views and Filters
-
Working with Filters
- About Filters
- Viewing the Existing Saved Filters
- Creating a New Filter
- Using the Filter Bar to Adjust Your View
- Clearing Filter Conditions
- Removing a Filter
- Editing a Filter
- Duplicating a Filter
- Saving a Filter
- Applying a Saved Filter
- Deleting a Filter
- Displaying Columns for Filters
- Reordering Columns for Filters
-
Working with Views
- About Views
- Working With List Views
- Working with Pivot Views
- Working with Chart Views
- Working With Gantt Chart Views
- Working With Calendar Views
- Saving Views
- Editing Saved Views
- Setting a Default View
-
Working with Filters
- Working with Dashboards
-
Part X Appendices
- 30 Best Practices
- 31 Frequently Asked Questions (FAQ) about Enterprise Profitability and Cost Management
- 32 Using the Member Selector
- 33 Naming and Character Restrictions
- 34 Integrating Cloud EPM and Cloud EDM with Oracle Guided Learning
- 35 Migrating from Profitability and Cost Management to Enterprise Profitability and Cost Management