Financial Consolidation and Close (FCC): Designing the Close Process

Creating Rules for Advanced Consolidations

• Objectives
• Consolidation and Translation Rules
• Default Translation Settings
• Default Translation Settings: Change Setting
• Types of Override Translation Rules
• Creating Override Translation Rules
• Creating Override Translation Rules: Illustration
• Deploying Override Translation Rules: Overview
• Deploying Override Translation Rules
• Creating Rate Accounts for Translation Overrides: Overview
• Creating Rate Accounts for Translation Overrides: Global Rate Accounts
• Creating Rate Accounts for Translation Overrides: Local Rate Accounts
• Creating Rate Accounts for Translation Overrides
• Creating Configurable Calculations: Overview
• Creating Configurable Calculations: Calculation Manager
• Creating Configurable Calculations
• Enabling Auto Create Blocks for Configurable Calculations
• Creating On-Demand Rules: Overview
• Creating On-Demand Rules
• Adding On-Demand Rules to Data Forms: Overview
• Adding On-Demand Rules to Data Forms: Create Menu Item
• Adding On-Demand Rules: Illustration
• Adding On-Demand Rules to Data Forms: Add the Menu to Form and
• Business Rules
• Creating Opening Balance Override Rules: Overview
• Creating Opening Balance Override Rules
• Creating Configurable Consolidation Rules: Overview
• Seeded Rulesets
• Deploying the Seeded Rulesets
• Creating Consolidation Rulesets
• Creating Consolidation Rulesets: Illustration
• Equity Pickup: Overview
• Equity Pickup: Ruleset
• Enabling and Disabling the Equity Pickup Calculation
• Summary

Managing Approvals

• Objectives
• Approval Overview
• Approval Overview: Approval Units
• Approval Overview: Approval Stages
• Approval Overview: Owners and Reviewers
• Approval Templates
• Approval Template: Consolidation
• Approval Template: Consolidation – Bottom Up Template
• Approval Unit Promotional Path
• Validation Rules and Approvals
• Approval Status Reports
• Approval Status Reports: Creating Reports
• Setting Up Approval Unit Hierarchies: Overview
• Setting Up Approval Unit Hierarchies
• Setting Up Approval Unit Hierarchies: Illustration
• Setting Up Approval Unit Hierarchies: Select Primary Members
• Setting Up Approval Unit Hierarchies: Assign Owners and Reviewers
• Assigning Approval Unit Hierarchies to Scenarios and Time Periods
• Starting the Approval Process
• Promote, Approve, and Lock Approval Units: Promoting
• Promote, Approve, and Lock Approval Units: Promoting – Illustration
• Promote, Approve, and Lock Approval Units: Actions
• Promote, Approve, and Lock Approval Units: Approving
• Promote, Approve, and Lock Approval Units: Locking
• Promote, Approve, and Lock Approval Units: Approval Status
• Promote, Approve, and Lock Approval Units: Approval Unit Status
• Setting Up Approval Unit Hierarchies: Usage
• Setting Up Approval Unit Hierarchies: Synchronizing Approval Unit Hierarchies
• Summary

Managing Approval Phases

• Objectives
• Approval Group: Overview
• Defining Approval Groups: Overview
• Defining Approval Groups: Steps
• Defining Approval Groups: Anchor and Non-Anchor Dimensions
• Defining Approval Groups: Add Rule
• Adding Members
• Approval Groups: Edit, Duplicate, Delete
• Editing, Duplicating, and Deleting Approval Groups
• Setting Up Extended Approval Unit Hierarchy: Overview
• Setting Up Extended Approval Unit Hierarchy: Approval Templates
• Setting Up Extended Approval Unit Hierarchy: Enabling Phase Dependency
• Setting Up Extended Approval Unit Hierarchy
• Setting Up Extended Approval Unit Hierarchy: Approvals Dimension – Entity
• Setting Up Extended Approval Unit Hierarchy: Assigning Approval Groups
• Setting Up Extended Approval Unit Hierarchy: Changing Approval
• Group Order
• Setting Up Extended Approval Unit Hierarchy: Default Approval Group
• Setting Up Approval Unit Hierarchies: Selecting Primary Members
• Setting Up Approval Unit Hierarchies: Assigning Owners for Each Phase
• Copying Owners to Corresponding Approval Group Members
• Assigning Approval Unit Hierarchies to Scenarios and Time Periods
• Starting the Approval Process for Each Approval Group
• Starting the Approval Process for Each Approval Group: Illustration
• Viewing Approval Status by Phase
• Viewing Approval Status by Phase: Data Status – Illustration
• Summary

Setting Up Task Manager

• Objectives
• Task Manager: Overview
• Task Manager: Key Components
• Task Manager: Security Roles
• Task Manager: View Tasks
• Task Manager Menu
• Organizational Units
• Adding Organization Units
• Importing Organization Units
• Holiday Rules
• Defining Holiday Rules
• Teams
• Defining Teams
• Import Export of Team Data
• Task Manager Attributes Attributes
• Defining Attributes
• Task Manager Attributes Attribute Data Types
• Task Templates: Overview
• Task Template: Sections
• Defining Template: Properties
• Defining Template: Instructions
• Defining Template: Assign Viewers
• Defining Template: Assign Viewers – Illustration
• Defining Template: Applying Template Attributes
• Defining Template: Day Labels
• Defining Template: Embedding Templates
• Defining Template: Rules
• Defining Template: Steps to Add Rule
• Defining Template: Viewing Template History
• Task Types: Overview
• Task Types: Creating Task Types
• Adding Tasks to Templates: Overview
• Adding Tasks to Templates
• Adding Tasks to Templates: Properties
• Adding Tasks to Templates: Parameters
• Adding Tasks to Templates: Workflow
• Adding Tasks to Templates: Questions
• Adding Tasks to Templates: Predecessors
• Schedules: Overview
• Creating Schedules: Manual
• Creating Schedule: Manual – Instructions, Viewers, Attributes, Rules, and
• Day Labels
• Creating Schedule from a Template
• Summary

Managing Close Process Using Task Manager

• Objectives
• Opening a Schedule: Overview
• Opening a Schedule
• Pending and Opening a Schedule
• Closing and Locking a Schedules
• Managing Tasks: Viewing Tasks from the Home Page
• Managing Tasks: Viewing Task Details
• Managing Tasks: Task Actions
• Managing Tasks: Task Status
• Managing Tasks: Submitting and Approving task
• Alert Types
• Alerts Overview
• Alert Types: Properties
• Alert Types: Instructions, Workflow, Questions, Viewers, Attribute and History
• Alerts: Creating Alert
• Alerts: Creating Alert on a Task
• Alert Actions
• Alerts: Creating Alert on a Schedule
• Task Manager Reports: Custom Report
• Task Manager Reports: Creating a Task Manager Query
• Task Manager Reports: Creating a Template
• Task Manager Reports: Setting Up a Report Group
• Task Manager Reports: Creating Reports
• Task Manager Reports: Generating Reports
• Summary

Managing Task Manager Integrations

• Objectives
• Integrations: Overview
• Managing Connections: Create a New Connection
• Integration Types: Overview
• End User Integration
• Process Automation Integration
• Event Monitoring Integrations
• Enabling Connections
• Sync EPM Connections
• Process Automation Integration: Use Case Create Tasks to Load Data into
• Planning and Verify Data Load
• Step 1: Create Connection to Planning
• Step 2: Sync EPM Connection to Planning
• Step 3: Enable Connection to Planning
• Step 4: Create Task Template for Monthly Data Load
• Step 5: Create Basic to Approve Corporate Data Load
• Step 6a: Create Automated Integration Task Set Task Properties
• Step 6b: Create Automated Integration Task Set Task Parameters
• Step 6c: Create Automated Integration Task Set Workflow
• Step 6d: Create Automated Integration Task Set Predecessor Task
• Step 7a: Create Task to Verify Data into Planning Enter Form Data
• Step 7b: Create Task to Verify Data into Planning Set Parameters
• Step 7c: Create Task to Verify Data into Planning Set Workflow
• Step 7d: Create Task to Verify Data into Planning Set Predecessors
• Step 8: View Task List
• Step 9: Create and Change Schedule Status to Open
• Step 10: View Worklist and Authorize Task to Start
• Summary

Setting Up Supplemental Data

• Objectives
• Supplemental Data
• Supplemental Data Process
• Supplemental Data: Menu
• Viewing Collections
• Creating Collections
• Creating Collections: Properties
• Creating Collections: Adding Attributes
• Creating Collections: Adding Attributes – Properties
• Importing Data Set List Attributes
• Creating Collections: Adding Attributes – Validation, Calculations
• Creating Form Templates: Overview
• Creating Form Templates
• Creating Form Templates: Properties
• Creating Form Templates: Instructions
• Creating Form Templates: Sections
• Creating Form Templates: Sections – Properties
• Creating Form Templates: Sections – Columns
• Creating Form Templates: Sections – Total Validation
• Creating Form Templates: Sections – Group By
• Creating Form Templates: Sections – Mapping
• Creating Form Templates: Workflow
• Creating Form Templates: Workflow – Illustration
• Creating Form Templates: Questions
• Creating Form Templates: Access
• Creating Form Templates: History
• Summary

Collecting Supplemental Data

• Objectives
• Deploying Form Template to Data Collection Periods: Overview
• Deploying Form Template to Data Collection Periods: Steps
• Deploying and Redeploying Options
• Deploying and Redeploying Options: Illustration
• Un-Deploy
• Deploying Form Template: Deployment Status
• Entering Data in Supplemental Data Form: Viewing Supplemental Data Tasks
• Entering Data in Supplemental Data Form: Methods
• Entering Data in Supplemental Data Form: Steps
• Entering and Submitting Data in Supplemental Form: Illustration
• Approving Data in Supplemental Data Forms
• Submitting, Approving, Rejecting, or Posting Supplemental Data Forms
• Summary

Installing Smart View

• Objectives
• Smart View: Overview
• Smart View Capabilities
• Installing Smart View: Overview
• Installing Smart View: Steps
• Setting Up Smart View Add-Ons
• Setting Up Smart View Add-ons: Installation and Updates
• Setting Up Smart View Add-ons: Enabling and Disabling Extensions
• Smart View Components
• Smart View Components: Provider and Provider Ad Hoc Ribbons
• Smart View Components: Ribbon
• Smart View Components: Panel
• Smart View Components: Right-Click Context Menu
• Data Source Connection
• Data Source Connection: Shared Connection
• Data Source Connection: Private Connection
• Data Source Connection: Quick Connection Wizard
• Supplemental Data Manager (SDM) Extension
• Task Manager Extension
• Summary

Viewing and Analyzing Data with Smart View

• Objectives
• Entering Data Through Forms: Overview
• Opening Forms
• Setting the Form POV
• Setting the Form POV: Illustration
• Entering and Submitting Data: Entering Data
• Entering and Submitting Data: Submitting Data
• Entering and Submitting Data: Submitting Data – Steps
• Entering and Submitting Data: Submitting Data – Illustration
• Cell Actions: Adding Comments
• Cell Actions: Adding Supporting Details
• Cell Actions: Adding Supporting Details – Illustration
• Cell Actions: Adding Attachments to Data Cells
• Cell Actions: Adding Attachments to Data Cells – Illustration
• Cell Style: Overview
• Cell Style: Step
• Cell Style: Illustration
• Creating Ad Hoc Analysis: Overview
• Creating Ad Hoc Analysis
• Creating Ad Hoc Analysis: FCCS Ad Hoc Ribbon
• Creating Ad Hoc Analysis: Analysis Options
• Creating Ad Hoc Analysis: Zoom In and Zoom Out
• Creating Ad Hoc Analysis: Zoom In Illustration
• Creating Ad Hoc Analysis: Keep Only
• Creating Ad Hoc Analysis: Remove Only
• Changing Point of View: Point of View Toolbar
• Changing Point of View: Pivot
• Changing Point of View: Pivot – Illustration
• Changing Point of View: Pivot to POV
• Changing Members: Member Selection
• Changing Members : Select Members for POV
• Selecting an Alias Table for the Current Worksheet
• Smart View Options
• Setting Smart View Options: Types
• Creating Ad Hoc Analysis: Save as Ad Hoc Grid
• Submitting and Approving Tasks in Smart View
• Submitting and Approving Tasks in Smart View: Connecting to SmartView
• Task Manager
• Submitting and Approving Tasks in Smart View: Opening Task
• Submitting and Approving Tasks in Smart View: Workflow Activities
• Entering Data in Supplemental Data Forms in Smart View
• Entering Data in Supplemental Data Forms in Smart View: Connecting to Supplemental Data
• Entering Data in Supplemental Data Forms in Smart View: Entering and
• Submitting Data
• Summary

Automating Administrative Tasks Using EPM Automate

• Objectives
• EPM Automate Overview
• EPM Automate Overview: Automate Repeatable Tasks
• Download and Install EPM Automate: Windows
• Download and Install EPM Automate: Linux/UNIX/MacOs X
• Launching EPM Automate: Windows
• Launching EPM Automate: macOS X, Linux
• Launching EPM Automate: Login – Windows
• Launching EPM Automate: Login – Linux
• EPM Automate Utility Commands
• EPM Automate Utility Command: help
• EPM Automate Utility Command: listFiles
• EPM Automate Utility Command: uploadFile
• EPM Automate Utility Command: downloadFile
• EPM Automate Utility Command: importMetadata
• EPM Automate Utility Command: exportMetadata
• EPM Automate Utility Command: runBusinessRule
• EPM Automate Utility Command: importData
• EPM Automate Utility Command: exportData
• EPM Automate Utility Command: importMapping
• EPM Automate Utility Command: exportMapping
• Summary

Managing Operational Dashboards

• Objectives
• Overview of Operational Dashboards
• Overview of Operational Dashboards: Features
• Viewing and Opening Operational Dashboards
• Viewing and Opening Operational Dashboards: View Mode
• Viewing and Opening Operational Dashboards: Design Mode
• Creating Operational Dashboards
• Create Operational Dashboards: Dashboard Settings
• Create Operational Dashboards: Dashboard Settings – Access
• Specifying View Options
• Specifying View Options: Illustration
• Specifying View Options: Chart
• Specifying View Options: Chart Properties
• Specifying View Options: Chart Properties – Types
• Specifying View Options: Chart Layout
• Specifying View Options: Chart Axis
• Specifying View Options: Legend
• Specifying View Options: List Views
• Specifying View Options: Customizing List Views
• Specifying View Options: Pivot Views
• Specifying View Options: Pivot View – Illustration
• Specifying View Options: Customizing Pivot View
• Managing Operational Dashboards
• Running Operational Dashboards
• Exporting/Importing Operational Dashboards
• Applying Filters to Data in Operational Dashboards
• Applying Filters to Data in Operational Dashboards: New Filter
• Summary

Designing Financial Dashboards

• Objectives
• Financial Dashboards: Overview
• Financial Dashboards: Features
• Converting Dashboard 1.0 Dashboards to 2.0
• Opening Dashboard 2.0 in Designer
• Opening the Dashboard 2.0 Designer: From Runtime Environment
• Dashboard 2.0 Designer: Components
• Selecting a Data Source: Cube
• Selecting a Data Source: Form
• Using the Object Palette to Select Dashboard Content
• Working with Dashboard Toolbar
• Adding Components to the Dashboard Workspace
• Properties Panel: General
• Properties Panel: Associations
• Properties Panel: Chart
• Properties Panel: Chart Properties
• Properties Panel: Layout
• Dashboard Component Toolbar
• Working with Chart Types -1
• Working with Chart Types -2
• Drilling Down on Charts
• Working with Dashboard POVs: Global and Local POV
• Working with Dashboard POVs: Global and Local POV Illustration
• Working with Dashboard POVs: POV Settings
• Working with the Member Selector
• Viewing, Editing, and Selecting Dashboard Actions
• Summary