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
Setup of Work Status Dimensions
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
Business Process Flow Management
Creating New Business Process Flows
Setting Up BPFs
Defining Steps and Sub-Steps
Defining Actions
Finishing BPFs
Copying Business Process Flows
Managing Business Process Flow Instances
Deleting Business Process Flows
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
Work Status Setup
Work Status Example
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
Custom Menu Setup
Business Calculations
Business Rules Management
Account Transformations
Automatic Adjustments
Consolidation Rules, Methods, and Formulas
Consolidation as Script Logic
Ultimate Ownership Calculation using the Direct Share Method
Automatic Adjustments Detail
Carry-Forward Rules
Currency Conversions
Intercompany Bookings
US Eliminations
Validations
Automatic Adjustments for Legal Consolidation
Logic
Dimension Logic
Script Logic
Logic Execution
Logic Assistant
Logic Debugger
UDF functions
Building Advanced Rules
Library of MDX Functions
MDX Formula Syntax
Simple Rule Formula Examples
Advanced Rule Formula Examples
MDX Subroutines
Basic Financial Functions
Liquidity Analysis Ratios
Profitability Analysis Ratios
Activity and Efficiency Analysis Ratios
Capital Structure Analysis Ratios
User-Defined Functions
Library of SQL Functions
Performing Intercompany Eliminations
ACCUMULATE
CALCULATE_TOTAL_AND_COMMIT
CALC_MOVEMENT
CARRYFORWARD_AND_COMMIT
DERIVE_YTD
FX_OVERRIDE
FX_OVERRIDE_RATE
FX_OVERRIDE_NOZERO
ROLLTOBS
TRANSLATE_LDI
TRANSLATE_PROFIT_AND_COMMIT
Logic Keyword Reference
*ADD_DIM
*ADD / *ENDADD
*BEGIN / *END
*CALC_EACH_PERIOD
*CALC_ORG
*CALCULATE_DIFFERENCE
*CLEAR_DESTINATION
*COMMIT
*COMMIT_EACH_LEVEL
*COMMIT_EACH_MEMBER
*COMMIT_MAX_MEMBERS
*DESTINATION
*DESTINATION_APP
*FIRST_PERIOD
*FLAG_PERIOD
*FOR / *NEXT
*FUNCTION / *ENDFUNCTION
*GO
*INCLUDE
*JOIN
*LAST_MEMBER
*LOCAL_CURRENCY
*LOGIC_BY
*LOGIC_MODE
*LOGIC_PROPERTY
*LOOKUP / *ENDLOOKUP
*MEASURES
*MEMBERSET
*Memory Variables
*NO_PARALLEL_QUERY
*PRIOR
*PROCESS_EACH_MEMBER
*PROCESS_FAC2
*PUT
*QUERY_FILTER
*QUERY_SIZE
*QUERY_TYPE
*REC
*RENAME_DIM
*RUN_STORED_PROCEDURE
*RUNLOGIC
*SCOPE_BY
*SELECT
*SELECTCASE / *ENDSELECT
*SKIP_DIM
*STORE_ORG
*SUB( ) / *ENDSUB
*SYSLIB
*TEST_WHEN
*USE
*WHEN/ENDWHEN
*WRITE_TO_FAC2
*WRITE_TO_FILE
*XDIM_ADDMEMBERSET
*XDIM_DEFAULT
*XDIM_FILTER
*XDIM_GETINPUTSET
*XDIM_GETMEMBERSET
*XDIM_MAXMEMBERS
*XDIM_MEMBER
*XDIM_MEMBERSET
*XDIM_NOSCAN
*XDIM_REQUIRED
Time-Shift Instructions
Insight Management
Setting Up Insight
Root Cause Event Setup
User Management
Key Performance Indicator Definition
Defining Key Performance Indicators
Key Performance Indicator Export and Import
Importing Key Performance Indicators
Exporting Key Performance Indicators
System Configuration Export and Import
Exporting System Configuration Files
Importing System Configuration Files
System Configuration Setup
Setting the Current Time Period
Viewing E-Mail Server Information
Synchronizing Insight Data
Defining KPI Variance Categories
Setting Measures Types
Viewing Insight Service Status and Logs
Data Management
Package Usage
Standard Packages
Example Packages
Running a Package
Viewing the Status of a Package
Viewing the Status of a Package Schedule
Creating and Using a Selected Packages List
Assigning Packages to Teams
Testing Packages
Logic Usage in Packages
Package Maintenance (Organization)
Adding and Modifying Packages
Package Properties
Adding Sample Packages to the Data Manager
Moving or Copying Packages
Removing Packages
Data Transformations
Sample Transformation File
Data Conversion Maintenance
Uploading a Data File
Uploading a Text File into the Database
Downloading Data Files from the File Service
Previewing Data Files
Data Management Examples Using Standard Packages
Import Transaction from a Data File Example
Import Master Data from a Data File Example
Import Master Data Descriptions from a Data File Example
Import Transaction Data from an Information Provider Example
Copying Application Data
Scheduling Dimension Member Processing
Custom Tasks
Using Custom Tasks in Custom Packages
Registering Custom Tasks
DumpLoad Task Usage
MODIFYSCRIPT Package Variable (DumpLoad)
Processing the Application using DumpLoad
Accessing Microsoft SSIS
Importing into SQL Server
Exporting from Microsoft SQL Server
Exporting from a Cube
Importing into a Cube
Clear Data from SQL
Exporting Journal Data
Restoring Journal Data
Clearing Journal Data
Admin Task Usage
MODIFYSCRIPT Package Variable (Admin)
Validating Logic
Validating Security
Optimizing the Application
Processing the Application
Creating Dimensions
Send Mail Task Usage
MODIFYSCRIPT Package Variable (Send Mail)
Sending Mail
Trigger Task Usage
MODIFYSCRIPT Package Variable (Trigger)
Setting Triggers
System Available Task Usage
MODIFYSCRIPT Package Variable (System Available)
Setting System Availability
FTP Task Usage
MODIFYSCRIPT Package Variable (FTP)
Transferring Files
Logic Task Usage
MODIFYSCRIPT Package Variable (Logic)
Running Simulation Mode
Logic Execution Audits
Memory Management
MODIFYSCRIPT Package Variable Tasks (Memory Management)
Logic Query Control with MDX Query Type Settings
MODIFYSCRIPT Package Variable (MDX Query Types)
MODIFYSCRIPT Package Variable Task Usage
MODIFYSCRIPT Syntax
DATATRANSFERMODE Property
TASKCOPYCOLUMNS Command
Dynamic Constants
Using MODIFYSCRIPT to Dynamically Pass Text to Logic
MODIFYSCRIPT and Microsoft SSIS Global Variables
MODIFYSCRIPT and Script Variable Values
Dynamically Generated INFO Instructions
SELECTION_FROM_FILE and FACTSELECTION_FROM_FILE for GETINFO
DELETESTATEMENT_FROM_FILE for GETINFO
Multi-Line Info Instructions
Predefined Paths for the INFILE, TRANSFORMATION, and OUTFILE Pro
User Prompts
CHECKBOXGROUP Prompt() Command
CHECKBOXNO Prompt() Command
CHECKBOXYES Prompt() Command
CONVERSION Prompt() Command
COPYMOVE Prompt() Command
COPYMOVEINPUT Prompt() Command
DELIMITER Prompt() Command
INFILE Prompt() Command
INFILES Prompt() Command
LOGICFILE Prompt() Command
MESSAGE Prompt() Command
OUTFILE Prompt() Command
RADIOBUTTON Prompt() Command
SELECT Prompt() Command
SELECTINPUT Prompt() Command
SELECTIONFILE Prompt() Command
TEXT Prompt() Command
TRANSFORMATION Prompt() Command
Business Process Flows
Member Lookup
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
Common Report and Input Schedule Features
Workbook Options
Current View
Drill Down
Refresh Report Data
Dimension Locks
Park N Go
Dynamic Expansion
Drill-Through
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
Document Publishing
Client Options
Working Offline
Book Publishing
Create a Book Template
Validate a Book Template
Publish a Book
Dynamic Hierarchies
Create Dynamic Hierarchies
Dynamic Hierarchy Requirements
Reporting on Dynamic Hierarchies
Custom Menus
Custom Menu Design
Custom Menu Content
Custom Menu Functions
List of Menu Commands
Journals
Journal Entries
Journal Entry Form
Journal Postings
Journal Queries
Reopen Journal Entries
Journal Reopen Translations
Journal Reports
Work Status
Comments
Interface for the Web
Content Library
Creating a Web Page
Content Library Objects
Monitor Variances, KPIs, and Predictions with Insight
Dashboard
Variance Analysis
Insight Properties Setup
Analysis Tasks
View Options
Data Scaling
Account Data Graphs
Key Performance Indicator Alerts
Predictions
KPI Annotation using Actions
Insight Reports
Key Performance Indicators
Adding a Key Performance Indicator
Key Performance Indicator Algorithms
Live Reporting (Interface for the Web)
Building Reports
Status of Live Report Data
Charts in Live Reports
Format of Live Reports
Functions Reference
Text Functions
EvAPP
EvASD
EvAST
EvDES
EvDIM
EvLCK
EvPRO
EvPRO Formulas
EvPRP
EvRTI
EvSVR
EvUSR
OsAMT
Actionable Functions
EvCGP
EvCGT
EvCVW
EvHNV
EvHOT
EvMBR
EvMNU
Linking Functions
EvBNV
EvDNV
OsCLD
Expansion Functions
EvENE
EvEXP
EvLST
EvNXP
EvPXR
EvSET
Value Functions
EvBET
EvCOM
EvGET
EvGTS
EvSEN
EvSND
EvTIM
Exchange Functions
EvINP
EvDRE
EvDRE Syntax
EvDRE Parameters
EvDRE Structure
EvDRE Processing Sequence
EvRNG
Key Range Parameter
Multiple Key Ranges
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
MDX Expressions for Sorting and Ranking
System Reports
Reporting on Activity Auditing
Reporting on Security Information
Reporting on Data Audit Information
Reporting on Comments
Reporting on Work Status
Reporting on Business Process Flows
Copyright
Important Disclaimers on Legal Aspects