Table of Contents
- Title and Copyright Information
- Documentation Accessibility
- Documentation Feedback
- 1 Financial Consolidation and Close Overview
-
2
Creating a Financial Consolidation and Close Application
- Application Prerequisites
- Workflow for Creating an Application
- Creating an Application
- Enabling Application Features
- Enabling Ownership Management in Applications
- Managing Ownership
- Copying Local Rate Account Data
- Migrating to Extended Dimensionality
- Migrating to Extended Dimensionality and Enterprise Cloud Service
- 3 Managing Security
-
4
Managing Applications
- Application Overview
- Restrictions for Dimensions, Members, Aliases, and Forms
- Managing Dimensions
- Importing Metadata
- Exporting Metadata
- Validating Metadata
- Metadata Validation Messages
-
Importing Data
- Creating the Data Import File
- Data Import File Format
- Data Load Methods
- Load Method Examples
- Loading the Data Import File
- Example: Data Import File - Periodic View
- Example: Data Import File - YTD View
- Example: Data Import File - YTD Input and Replace Mode
- Example: Data Import File - Closing Balance Input and Replace Mode
- Example: Data Import File - Overrides
- Example: Data Import File - Exchange Rates
- Exporting Data
- Viewing Data Import and Export Status
- Importing Data Using Data Management
- Exporting Data Using Data Management
- Data Integrations
- Copying Data
- Using Copy Data Profiles
- Clearing Data
- Using Clear Data Profiles
- Refreshing the Database
- Restructuring Cubes
- Removing an Application
- Scheduling Maintenance
- Using the Inbox/Outbox
- Working with Activity Reports and Access Logs
-
5
Managing Application and System Settings
- Specifying Application Settings
- Uploading Fonts in Enterprise Performance Management Cloud Deployments
- Specifying a Default Alias Table, and Setting Member and Alias Display Options
- Specifying Number Formatting Preferences
- Defining User Variables
- Customizing Your Application Appearance
- Making Announcements
- Specifying Artifact Labels
- Working With the Artifact Labels Grid
- Adding Languages and Defining Localized Artifact Labels
- Exporting and Importing Artifact Labels for Editing
- Reviewing Artifacts
- Working with Substitution Variables
-
6
Connecting Environments in EPM Cloud
- About Connecting EPM Cloud Environments
- Considerations for Migrating EPM Cloud Connections
- Creating, Editing, and Deleting Connections to Other EPM Cloud Environments
- Connecting to External Web Services
- Specifying Advanced Options for External Connections
- Navigating Across EPM Cloud Environments
- Customizing Navigation Flows to Access Other EPM Cloud Environments
- Using Direct URLs to Integrate Connected Environments
-
7
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
- 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 to a Tabular Page
- About Using URLs to Embed Third-Party Pages in EPM Cloud Applications
- Removing Navigation Flows, Cards, and Tabs
- Grouping Cards into Clusters
- Reloading a Navigation Flow
- Switching Navigation Flows at Runtime
- 8 Designing Infolets
- 9 Designing Financial Dashboards
-
10
Working with Dimensions
- Dimensions Overview
- Converting Period and Movement Dimensions to Dense Dimensions
- Viewing and Editing Dimensions
- Working with Dimension Hierarchies
- Adding Custom Dimensions
- Defining Accounts
- Defining Entity Members
- Creating Alternate Hierarchies
- Financial Consolidation and Close Data Model Overview
- Working with Members
- Setting Up Currencies
- Setting Up Scenarios
- Customizing Application Years
- Working with Attributes
- Working with Attribute Values
- Working with User-Defined Attributes (UDAs)
- Working with Member Formulas
- Working with Alias Tables
- 11 Editing Dimensions in the Simplified Dimension Editor
- 12 Managing Jobs
- 13 Auditing Tasks and Data
-
14
Defining Valid Intersections
-
Understanding Valid Intersections
- Valid Intersection Groups
- Valid Intersection Rules
- Anchor and Nonanchor Dimensions
-
Valid Intersection Examples
- Example: Anchor and Nonanchor Dimensions
- Example: Required Dimension
- Example: Unselected Members are Valid
- Example: Redundant or Overlapping Valid Intersection Rules Within the Same Valid Intersection Group
- Example: Redundant or Overlapping Valid Intersection Rules in Different Valid Intersection Groups
- Redundancy or Overlap in Valid Intersection Rules
- Shared Members and Valid Intersection Rules
- Substitution Variables and Valid Intersection Rules
- Evaluation Order
- Creating Valid Intersections
- Managing Valid Intersections
- Suppressing Invalid Data in Forms
- Working with Valid Intersections in Forms
- Managing Invalid Intersection Reports
-
Understanding Valid Intersections
-
15
Managing Forms
- Predefined Forms
- Form Components
- Form Design Considerations
-
Creating Simple Forms
- Setting Form Layout
- Setting Form Grid Properties
- Setting Form Dimension Properties
- Setting Display Properties
- Setting Printing Options
- Including Data Validation Rules in Forms
- Setting Form Precision and Other Options
- Creating Asymmetric Rows and Columns
- Adding Formula Rows and Columns
- Defining Simple Form Page and Point of View
- Working with Forms and Form Components
- Working with User Variables
- Working with Smart Lists
- 16 Managing Consolidation Journals
-
17
Consolidating Data
- Consolidation Process
- Data Flow
- Consolidation Process Flow
- Intercompany Eliminations
- Consolidation Dimension
- Translation Process
- Translating Data
- About Exchange Rates
- Entering Exchange Rates
- Entering Override Rates
- Specifying Default Translation Settings
- Consolidation and Translation Security Access
- Calculation Status
- Consolidating Data
- Viewing Consolidation Progress
- Running a Consolidation Report
- Consolidation Examples
- Advanced Consolidation Overview
- Consolidation Logic
- Managing Consolidation Methods
- Modifying Consolidation Methods
- Adding Consolidation Methods
- Importing and Exporting Consolidation Methods
- Recomputing Ownership Data
- Managing Ownership
- Changing Manage Ownership Settings
- Importing and Exporting Ownership Data
- Ownership Settings Year to Year
- Ownership Settings in Forms and Configurable Calculation Rules
- Advanced Consolidation Rules
- About Configurable Consolidation Rules
- Managing Consolidation Rule-sets and Rules
- Creating Consolidation Rule-sets
- Creating Consolidation Rules
- Consolidation Strings
- Viewing Rule-Sets
- Deploying and Undeploying Rule-Sets
- Duplicating and Deleting Rule-Sets
- Re-ordering Rule-sets and Rules
-
Seeded Consolidation Rules
- Investment Rule-Set
- Investment PP Rule-Set
- Owner's Equity (Subsidiary/Proportional) Rule-Set
- Owner's Equity (Subsidiary/Proportional) PP Rule-Set
- Owner's Equity (Equity) Rule-Set
- Owner's Equity (Equity) PP Rule-Set
- Owner's Equity (Holding) Rule-Set
- Net Income (Subsidiary) Rule-Set
- Net Income (Equity) Rule-Set
- Seeded Consolidation Rule Examples
- Seeded Consolidation Rules - Example (January)
- Seeded Consolidation Rules - Example (February)
- Seeded Consolidation Rules - Example (March)
- Optimizing the Performance of Configurable Consolidation Rules
-
18
Working with Rules
- Consolidation and Translation Rules
- Selecting Business Rules
- Assigning Access to Rules
- Disabling View Calculations
- Updating View Calculations
- Viewing Predicted Consolidation Time
- Using the Control To-Date View Storage Option
- Troubleshooting Financial Consolidation and Close Retrieval Performance
- Working with Override Translation Rules
-
Working with Configurable Calculations
- Creating Configurable Calculations
- Enabling Auto Create Blocks for Configurable Calculations
- Configurable Calculation Rules
- System Calculations
- Working within Calculation Manager
- Configurable Calculations Best Practices
- Best Practices for Calculations in Extended Dimensionality Applications
- Calculate Movements (from Closing Balance Input)
- Equity Pickup Overview
- Working with On-Demand Rules
- Working with Essbase Calc Script
- Supported Essbase Functions
- Financial Consolidation and Close Custom Functions
- Using Groovy Rules
- 19 Managing Approval Unit Hierarchies
- 20 Managing the Approval Process
-
21
Managing Enterprise Journals
- About Enterprise Journals
- Enterprise Journals Sample Task Flows
- Enabling Enterprise Journals
- Working with Enterprise Journal Views, Lists, and Filters
- Enterprise Journal Status
- Enterprise Journals Security Roles
- Managing Enterprise Journal Teams
- Managing Dimensions in Enterprise Journals
- Managing Enterprise Journals System Settings
- Configuring Periods for Enterprise Journals
- Creating Connections for Enterprise Journals
- Managing Enterprise Journal Targets
-
Managing Enterprise Journal Templates
- Creating Enterprise Journal Templates
- Editing Enterprise Journal Templates
- Duplicating Enterprise Journal Templates
- Deleting Enterprise Journal Templates
- Creating Ad-Hoc Enterprise Journals
- Deleting Ad-Hoc Enterprise Journals
- Validating Enterprise Journals
- Exporting Enterprise Journals
- Exporting Enterprise Journals Line Items
- Deploying an Enterprise Journal Template
- Un-Deploying an Enterprise Journal Template
- Enterprise Journals Posting Process
- Copying Enterprise Journals
- Force Closing Enterprise Journals
- Working with Enterprise Journal Dashboards
- Generating Custom Reports for Enterprise Journals
-
22
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
- Managing Task Manager Attributes
- 23 Managing Teams for Task Manager
- 24 Managing Task Types
-
25
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
-
26
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 Tasks
- Submitting Tasks
- Approving or Rejecting Tasks
- Managing Task Reassignments
- Aborting Tasks
- Deleting Tasks
-
27
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
- 28 Managing Task Manager Integrations
- 29 Managing Alert Types for Task Manager and Supplemental Data Manager
- 30 Using Task Manager and Supplemental Data Manager Reports
-
31
Managing Supplemental Data
- Supplemental Data Process Overview
- Managing Supplemental Data Manager Views, Lists, and Filters
- Managing Supplemental Data System Settings
- Working with the Supplemental Data Analysis Dashboard
- Managing Dimension Attributes in Supplemental Data Manager
- Working with Collection Intervals
- Working with Supplemental Data Collections
- Creating Supplemental Data Manager Form Templates
- Editing Form Templates
- Duplicating Form Templates
- Deleting Form Templates
- Deploying a Form Template to a Data Collection Period
- Un-Deploying a Form Template
- Re-opening Supplemental Data Forms
- Bulk Loading of Data into Collections
- Reassigning Users in Supplemental Data Manager
- Validating Supplemental Data Total Against an Account Balance
- Viewing Data in the Supplemental Data Analysis Dashboard
- Working with Supplemental Data in Smart View
- Using Currency Translation
-
32
Managing Supplemental Data Manager Teams
- Adding Teams and Members for Supplemental Data Manager
- Importing and Exporting Teams and Members for Supplemental Data Manager
- Exporting Supplemental Data Manager Users
- Editing Teams and Members for Supplemental Data Manager
- Deleting Teams and Removing Members for Supplemental Data Manager
- Managing Supplemental Data Manager Users
- A Financial Consolidation and Close Best Practices