SAP BusinessObjects Planning and Consolidation
Getting Started
Connection Wizard
Interface for Office
Interface for the Web
Interface for Administration
Interface for Word and PowerPoint
My Settings
More Information
Administration
Application Set Management
New Application Sets
ApShell Sample Application Set
Planning Sample Application
Rate Sample Application
Application Set Status
Dimension Management
Dimension Types
Dimension Security
Dimension Processing
Maintenance of Dimension Members
Assignment of Dimensions to Applications
Custom Measure Formulas
Member Behavior Using Dimension Properties
Owner Property Usage
Reviewer Property Usage
Required Properties for Account Dimensions
Required Properties for Category Dimensions
Required Properties for Currency Dimensions
Required Properties for Entity Dimensions
Required Properties for Group Dimensions
Required Properties for Intercompany Dimensions
Required Properties for Time Dimensions
Required Properties for User-Defined Dimensions
Required Properties for Datasrc Dimensions
Required Properties for Subtables Dimensions
Application Management
Reporting Applications
Non-Reporting Applications
Drill-Through Setup
Consolidation Framework Setup
Application Set Setup for Consolidations
Dimensions Setup for Consolidations
Consolidation Application Setup
Data Manager Packages and Script Logic Setup for Consolidations
Rate and Ownership Data for Consolidations Setup
Work Status Settings for Consolidations
Journal Template and Validation Settings for Consolidations
Journal Administration
Journal Template Creation
Journal Security
Journal Table Clearing
Limits to Dimension Members for Journal Entries
Data Modification by Journal Entries Only
Journals Application Parameters
Validation Rule Setup
Work Status Setup
Work Status Example
Business Process Flow Management
Creating New Business Process Flow Templates
Setting Up Business Process Flows
Defining Steps and Substeps
Criteria for Defining Steps and Substeps
Defining Step Region Criteria
Criteria for Opening Steps
Criteria for Reopening Steps
Defining Actions
Creating Business Process Flow Instances
Management of Business Process Flow Instances
Administration for the Web Tasks
Application Set Parameters
Application Parameters
Activity Auditing
Data Auditing
Log and Trace File Management
Managing Document Types and Subtypes
Deletion of Books
Business Calculations
Business Rules Management
Account Transformation Business Rule
Account Transformation as Script Logic
Currency Conversion Setup
Currency Conversion as Script Logic
Intercompany Booking Setup
Intercompany Booking as Script Logic
Carry-Forward Business Rule
Carry-Forward as Script Logic
US Eliminations Setup
US Eliminations as Script Logic
Validation Business Rule
Validations as Script Logic
Automatic Adjustments for Legal Consolidation
Consolidation Rules, Methods, and Formulas
Consolidation as Script Logic
Ultimate Ownership Calculation using the Direct Share Method
Logic
Dimension Logic
MDX Formula Syntax
Simple Rule Formula Examples
Advanced Rule Formula Examples
Script Logic
Library of MDX Functions
Custom Logic and BADI
Logic Keyword Reference
*ADD / *ENDADD
*BEGIN / *END
*DESTINATION_APP
*FOR / *NEXT
*FUNCTION / *ENDFUNCTION
*INCLUDE
*REC
LOOKUP
*RUNALLOCATION
*SELECT
*SELECTCASE / *ENDSELECT
*SUB( ) / *ENDSUB
*WHEN / *ENDWHEN
*XDIM_MEMBERSET
*XDIM_ADDMEMBERSET
*XDIM_MAXMEMBERS
*XDIM_FILTER
*COMMIT
Special Keywords
TMVL Parameter
Data Management
Uploading Data Files to the File Service
Downloading Data Files from the File Service
Previewing Data Files
Package Usage
Running a Package
Running a Package Link
Viewing the Status of a Package
Viewing the Status of a Package Link
Viewing the Status of a Package Schedule
Data Conversion Maintenance
Maintaining a Data Conversion Definition
Creating a Data Conversion File
Copying Data Conversion Files
Inserting Conversion Sheets
Validating Conversion Definitions
Data Transformation Maintenance
Sample Transformation File
Validating Transformation Files
Importing and Exporting Data Having Multiple Key Figures
Maintaining a Data Conversion Definition
Creating a Data Conversion File
Copying Data Conversion Files
Inserting Conversion Sheets
Validating Conversion Definitions
BAdI for Start Routine and End Routine
Package Maintenance
Clear Saved Prompts
Manage Packages
Adding and Modifying Packages
Package Properties
Modifying the Dynamic Script of a Package
Moving and Copying Packages
Removing a Package from a Package List
Manage Package Links
Manage Access to Packages by Users and Teams
Packages and Process Chains
Defining Dynamic Script Instructions
Predefined Constants
INFO Instructions
Task Instructions
Prompt Commands
CHECKBOX Prompt() Command
CHECKBOXGROUP Prompt() Command
CHECKBOXNO Prompt() Command
COMBOBOX Prompt() Command
CONVERSION Prompt() Command
COPYBOXNO Prompt() Command
COPYBOXYES Prompt() Command
COPYMOVE Prompt() Command
COPYMOVEINPUT Prompt() Command
DELIMITER Prompt() Command
DIMENSIONMEMBER Prompt() Command
DIMENSIONNAME Prompt() Command
HIERARCHYSELECTION Prompt() Command
INFILE Prompt() Command
INFILES Prompt() Command
LOGICFILE Prompt() Command
MASTERSELECTION Prompt() Command
MEASURELIST Prompt() Command
MEMBERFROMTOINPUT Prompt() Command
MESSAGE Prompt() Command
OUTFILE Prompt() Command
RADIOBUTTON Prompt() Command
SELECT Prompt() Command
SELECTINPUT Prompt() Command
SELECTION Prompt() Command
SELECTIONFILE Prompt() Command
TEXT Prompt() Command
TRANSFORMATION Prompt() Command
Packages Delivered with ApShell
Data Management Packages
Clear Saved Prompts
Manage Packages
Adding and Modifying Packages
Package Properties
Modifying the Dynamic Script of a Package
Moving and Copying Packages
Removing a Package from a Package List
Manage Package Links
Manage Access to Packages by Users and Teams
Financial Processes Packages
System Administration Packages
Installation Packages
Process Chains Delivered with ApShell
Data Management Process Chains
Export Transaction Data to a File Stored in File Service
Export Master Data to a File Stored in File Service
Export Transaction Data to a File on the Application Server
Export Master Data to a File on the Application Server
Import Master Data from an SAP BW InfoObject
Transformation Example
Write Mode Example
Import Compound SAP BW InfoObjects
Import Hierarchies from an SAP BW InfoObject
Mapping Example
Hierarchy Transformation Example
Select Hierarchy Level Example
Clearing Application Data
Copying Application Data
Moving Application Data
Import Transaction Data from a File
Import Master Data from a File
Import Master Data Descriptions from a File
Import Data from a BW InfoProvider
Retracting Master Data and Transaction Data
Retract Master Data Using a BAdI
Retract Transaction Data Using a BAdI
Retraction BAdI Definition
Import and Send E-Mail
Import File Using FTP
Clear Comments
Export Journals to File on File Service
Clear Journals
Import Journals from File on File Service
Run BW Process Chain
Run Default Logic
System Administration Process Chains
Run Full Optimize
Run Light Optimize
Validate Logic File
Run Activity Archive
Run Data Archive
Financial Process Chains
Run Allocations
Calculate Ownership
Run Currency Restatement
Process Intercompany Reconcilations
Process Intercompany Booking
Run Intercompany Eliminations
Run Legal Consolidation
Run Opening Balance Calculation
Run Account Transformations
Run Validations
Business Process Flows
Business Process Flows: My Activities
Business Process Flows: Monitor
Reporting on Business Process Flows
Reports and Input Schedules
Creating Reports and Input Schedules
Dynamic Report and Input Schedule Templates
EvDRE Builder
Drag and Drop Reporting
Editing Reports and Input Schedules
Live Reporting (Interface for the Web)
Building Reports
Format of Live Reports
Charts in Live Reports
Common Report and Input Schedule Features
Workbook Options
Current View
Member Lookup
Refresh Report Data
Dimension Locks
Park N Go
Dynamic Expansion
Drill Down
Drill-Through
Client Options
Working Offline
Data Modeling
Spread Modeling
Trend Modeling
Weighted Modeling
Data Submission
Distribute and Collect Offline Data
Create Distribution Lists
Distribute Reports and Input Schedules
Collect Input Schedules
Advanced Report and Input Schedule Tasks
Custom VBA Functions
VBA Workbook Options
Journals
Journal Entries
Journal Entry Form
Journal Postings
Journal Queries
Reopen Journal Entries
Journal Reopen Translations
Journal Reports
Work Status
Dynamic Hierarchies
Create Dynamic Hierarchies
Dynamic Hierarchy Requirements
Reporting on Dynamic Hierarchies
EvMNU Functions and VBA Macros with MNU Commands
Menu Commands
List of Menu Commands
EvMNU Formulas
VBA Macros
VBA Variables
Creating Buttons for VBA (MNU) Macros
Scenario 1: Worksheet Instructions Using MNU_ Commands
Scenario 2: Menu Creation Using EvMNU Formulas
Scenario 3: Menu Creation Using VBA
Comments
Content Library
Creating a Web Page
Content Library Objects
Functions Reference
EvDRE
EvDRE Syntax
EvDRE Parameters
EvDRE Structure
EvDRE Processing Sequence
EvRNG
Key Range Parameter
Current View Precedence
PageKey Range
RowKey Range
ColKey Range
CellKey Range
GetOnly Range
Format Ranges
Multiple Format Ranges
EvDRE Options
Sorting Range
Style Imports
Include Blank Rows or Columns
Expand Range Parameter
MemberSet Parameter
BeforeRange Parameter
AfterRange Parameter
EvSUM and EvSUB
Suppress Parameter
Insert Members
Repeated Expansions
Sequential Expansions
Expansion Across Sheets
Actionable Functions
EvCOM
EvCGP
EvCGT
EvCVW
EvHOT
EvHNV
EvMBR
Expansion Functions
EvEXP
EvNXP
Linking Functions
EvDNV
OsCLD
Text Functions
EvAPP
EvASD
EvAST
EvDES
EvDIM
EvPRO
EvPRO Formulas
EvPRP
EvRTI
EvSVR
EvUSR
OsAMT
Value Functions
EvBET
EvGET
EvGTS
EvSEN
EvSND
EvTIM
System Reports
Reporting on Activity Auditing
Reporting on Security Information
Reporting on Comments
Reporting on Data Audit Information
Reporting on Work Status
Reporting on Business Process Flows