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