Table of Contents
- Title and Copyright Information
- Documentation Accessibility
- Documentation Feedback
- 1 Creating and Running an EPM Center of Excellence
- 2 Overview of Calculation Manager
-
3
Designing Business Rules
- About Business Rules
- Creating a Business Rule
-
Creating a Groovy Business Rule
- About Groovy Business Rules
- Creating a Groovy Business Rule for Planning ASO Cubes
- Creating a Groovy Business Rule for Planning BSO Cubes
- Editing the Script For a Groovy Business Rule or Template
- Java API Reference for Groovy Rules
- Groovy Business Rule Examples
- Groovy Business Rule Tutorial Videos
- Groovy Business Rule Tutorials
- Opening a Business Rule
- Editing a Business Rule
- Editing a Business Rule in Script Mode
- Saving Business Rules
- Running a Business Rule
- Copying Business Rules
- Searching in Business Rules
- Printing a Business Rule
- Deleting a Business Rule
- Defining Common Dimensions In Business Rule Components
- Analyzing and Debugging Business Rules
- Refreshing Business Rules or Business Rulesets
- Showing the Usages of a Business Rule or Ruleset
- Optimizing Business Rules
-
4
Designing Business Rule Sets
- About Business Rulesets
- Creating a Business Ruleset
- Opening a Business Ruleset
- Opening a Business Rule Within a Business Ruleset
- Adding a Business Rule to a Business Ruleset
- Removing a Business Rule from a Business Ruleset
- Copying a Business Ruleset to Another Application
- Savings Business Rulesets
- Deleting a Business Ruleset
-
5
Working with System Templates
- About System Templates
- Displaying System Templates
- Using System Templates
- Showing the Template Flow
- Saving a System Template as a Custom Template
- Removing a System Template from a Business Rule
-
6
Working with Custom Templates
- About Custom Templates
- Creating a Custom Template
-
Creating Design-Time Prompts for Custom Templates
- Attribute DTP
- Boolean DTP
- Cross Dimension DTP
- Condition DTP
- DateAsNumber DTP
- Dimension DTP
- Dimensions DTP
- Integer DTP
- Member DTP
- Members DTP
- Member Range DTP
- Numeric DTP
- Password DTP
- Percent DTP
- Restricted List DTP
- Separator DTP
- Smart List DTP
- StringAsNumber DTP
- String DTP
- UDA DTP
- Creating Steps for Design-Time Prompts
- Defining Dependencies for Design-Time Prompts
- Defining Dimension Limits for Cross Dimension, Dimension, Dimensions, Member, and Member Range Design-time Prompts
- Finding and Replacing Text in Design-Time Prompts
- Opening a Custom Template
- Refreshing Custom Templates
- Showing the Usages of a Custom Template
- Copying and Pasting a Custom Template
- Deleting a Custom Template
- Finding and Replacing Text in Graphical Custom Templates
-
7
Using Components to Design Business Rules and Templates
- About Components
- Formula Components
- Script Components
- Condition Components
- Member Block Components
- Member Range Components
- Fixed Loop Components
- Metadata Loop Components
-
DTP Assignment Components
- About DTP Assignment Components
- Creating DTP Assignment Components
- Opening DTP Assignment Components
- Editing DTP Assignment Components
- Deleting DTP Assignment Components
- Copying and Pasting DTP Assignment Components
-
Using Design-Time Prompt Functions in DTP Assignment Components
- About Design-Time Prompt Functions
- @AvailDimCount
- @Compare
- @Compliment
- @Concat
- @DenseMember
- @Dependency
- @DimAttribute
- @DimMember
- @DimName
- @DimType
- @DimUDA
- @EndsWith
- @Evaluate
- @FindFirst
- @FindLast
- @GetData
- @Integer
- @Intersect
- @IsAncest
- @IsChild
- @IsDataMissing
- @IsSandBoxed
- @IsVariable
- @Length
- @Matches
- @Member
- @MemberGeneration
- @MemberLevel
- @MsgFormat
- @Notin
- @OpenDimCount
- @Plandim
- @PlanDimMember
- @Quote
- @RemoveQuote
- @ReplaceAll
- @ReplaceFirst
- @SmartListFromIndex
- @SmartListFromValue
- @SparseMember
- @StartsWith
- @SubString
- @ToLowerCase
- @ToMDX
- @ToUpperCase
- @Trim
- @Union
- @ValueDimCount
- Sharing Script and Formula Components
- Copying Components
- Saving Components
- Refreshing Formula and Script Components
- Showing the Usages of Formula and Script Components
-
Working with Components in a Flow Chart
- About Working With Components in a Flow Chart
- Collapsing and Expanding a Component in a Flow Chart
- Removing a Component from a Flow Chart
- Copying and Pasting a Component in a Flow Chart
- Copying and Pasting a Reference to a Component in a Flow Chart
- Copying and Pasting a Component Group in a Flow Chart
-
8
Using Aggregate Storage Components to Design Business Rules
- About Using Aggregate Storage Components to Design Business Rules
- Working with Point of View Components
- Working with Allocation Components
- Opening a Point of View or Allocation Component
- Deleting a Point of View or Allocation Component
- Copying and Pasting a Point of View or Allocation Component
- Saving a Point of View or Allocation Component
-
Working with Aggregate Storage Formula Components
- Creating an Aggregate Storage Formula Component
- Opening an Aggregate Storage Formula Component
- Editing an Aggregate Storage Formula Component
- Deleting an Aggregate Storage Formula Component
- Copying and Pasting an Aggregate Storage Formula Component
- Copying an Aggregate Storage Formula Component to Another Application or Database
- Showing an Aggregate Storage Formula Component's Usages
-
9
Using Member Selection, Variables, Functions, Smart Lists, and Planning Formula Expressions to Design Components
- About Member Selection, Variables, Functions, and Smart Lists
-
Adding Members and Functions to a Component
- About Adding Members and Functions to a Component
- Adding One Member or Function from One or More Dimensions to a Component
- Adding Multiple Members or Functions from One or More Dimensions to a Component
- Removing Members and Functions from a Component
- Searching for Members within the Member Selector
- Searching for Members in the Member Selector by Name, Alias, or Property
-
Working with Variables
- About Variables
-
Creating a Variable
- Entering Variable Values for a Numeric Variable
- Entering Variable Values for a String Variable
- Entering Values for an Array Variable
- Entering Values for a Member Range Variable
- Entering Variable Values for a Cross Dimension Variable
- Entering Variable Values for a Dimension Variable
- Entering Variable Values for a Member or Members Variable
- Entering Variable Values for Percent Variables
- Entering Values for Integer Variables
- Entering Variable Values for String as Number Variables
- Entering Variable Values for Date as Number Variables
- Entering Runtime Prompt Variables
- Selecting a Variable
- Editing a Variable
- Deleting a Variable
- Refreshing Variables
- Copying a Variable
- Finding and Replacing Text in the Variable Designer
- Showing the Usages of a Variable
- Working with Functions
- Essbase Functions Supported by Calculation Manager
-
Working with Custom Functions
- About Custom Functions
- Using a Custom Function with a Year Parameter
- @CalcMgrExcel Custom Functions with Date Parameters
- Bitwise Functions
-
Counter Functions
- @CalcMgrCounterAddNumber
- @CalcMgrCounterAddText
- @CalcMgrCounterClear
- @CalcMgrCounterClearAll
- @CalcMgrCounterClearKey
- @CalcMgrCounterDecrement
- @CalcMgrCounterDecrementKey
- @CalcMgrCounterGetKeyNumber
- @CalcMgrCounterGetKeyText
- @CalcMgrCounterGetNumber
- @CalcMgrCounterGetText
- @CalcMgrCounterIncrement
- @CalcMgrCounterIncrementKey
- @CalcMgrCounterUpdate
- @CalcMgrCounterUpdateNumber
- @CalcMgrCounterUpdateNumberText
- @CalcMgrCounterUpdateText
-
Date/Time Functions
- @CalcMgrAddDate
- @CalcMgrAddDatePart
- @CalcMgrAddDays
- @CalcMgrAddMonths
- @CalcMgrAddWeeks
- @CalcMgrAddYears
- @CalcMgrDateDiff
- @CalcMgrDateToExcel
- @CalcMgrDatesToExcel
- @CalcMgrDateTimeToExcel
- @CalcMgrDateTimesToExcel
- @CalcMgrDateToString
- @CalcMgrDaysBetween
- @CalcMgrDaysDiff
- @CalcMgrDiffDate
- @CalcMgrExcelADD
- @CalcMgrExcelDATE
- @CalcMgrExcelDATEDIF
- @CalcMgrExcelDAYOFYEAR
- @CalcMgrExcelDAYS360
- @CalcMgrExcelDAYSINMONTH
- @CalcMgrExcelEOMONTH
- @CalcMgrExcelHOUR
- @CalcMgrExcelMINUTE
- @CalcMgrExcelMONTH
- @CalcMgrExcelNETWORKDAYS
- @CalcMgrExcelSECOND
- @CalcMgrExcelToDate
- @CalcMgrExcelToDateTime
- @CalcMgrExcelWEEKNUM
- @CalcMgrExcelWEEKDAY
- @CalcMgrExcelWORKDAY
- @CalcMgrExcelYEAR
- @CalcMgrExcelYEARFRAC
- @CalcMgrGetCurrentDate
- @CalcMgrGetCurrentDateTZ
- @CalcMgrGetCurrentDateTime
- @CalcMgrGetCurrentDateTimeTZ
- @CalcMgrGetCustomDate
- @CalcMgrGetCustomDateTime
- @CalcMgrGetDatePart
- @CalcMgrGetDateTimePart
- @CalcMgrGetDay
- @CalcMgrGetDayOfYear
- @CalcMgrGetFormattedDate
- @CalcMgrGetMaxDaysInMonth
- @CalcMgrGetMonth
- @CalcMgrGetStringFormattedDateTime
- @CalcMgrGetWeekOfMonth
- @CalcMgrGetWeekOfYear
- @CalcMgrGetYear
- @CalcMgrIsLeapYear
- @CalcMgrMonthsBetween
- @CalcMgrMonthsDiff
- @CalcMgrRollDate
- @CalcMgrRollDay
- @CalcMgrRollMonth
- @CalcMgrRollYear
- @CalcMgrWeeksBetween
- @CalcMgrWeeksDiff
- @CalcMgrYearsBetween
- @CalcMgrYearsDiff
-
Financial Functions
- @CalcMgrExcelACCRINT
- @CalcMgrExcelACCRINTM
- @CalcMgrExcelAMORDEGRC
- @CalcMgrExcelAMORLINC
- @CalcMgrExcelCOUPDAYBS
- @CalcMgrExcelCOUPDAYS
- @CalcMgrExcelCOUPDAYSNC
- @CalcMgrExcelCOUPNCD
- @CalcMgrExcelCOUPNUM
- @CalcMgrExcelCOUPPCD
- @CalcMgrExcelCUMIPMT
- @CalcMgrExcelCUMPRINC
- @CalcMgrExcelDB
- @CalcMgrExcelDDB
- @CalcMgrExcelDISC
- @CalcMgrExcelDOLLARDE
- @CalcMgrExcelDOLLARFR
- @CalcMgrExcelDURATION
- @CalcMgrExcelEFFECT
- @CalcMgrExcelFV
- @CalcMgrExcelFVSCHEDULE
- @CalcMgrExcelMDURATION
- @CalcMgrExcelINTRATE
- @CalcMgrExcelPMT
- @CalcMgrExcelIRR
- @CalcMgrExcelISPMT
- @CalcMgrExcelMIRR
- @CalcMgrExcelNPER
- @CalcMgrExcelNPV
- @CalcMgrExcelPPMT
- @CalcMgrExcelPRICE
- @CalcMgrExcelPRICEDISC
- @CalcMgrExcelPRICEMAT
- @CalcMgrExcelPV
- @CalcMgrExcelRATE
- @CalcMgrExcelRECEIVED
- @CalcMgrExcelSLN
- @CalcMgrExcelSYD
- @CalcMgrExcelTBILLEQ
- @CalcMgrExcelTBILLPRICE
- @CalcMgrExcelTBILLYIELD
- @CalcMgrExcelXIRR
- @CalcMgrExcelXNPV
- @CalcMgrExcelYIELD
- @CalcMgrExcelYIELDDISC
- @CalcMgrExcelYIELDMAT
- Log Functions
-
Math Functions
- @CalcMgrExcelCEILING
- @CalcMgrExcelCOMBIN
- @CalcMgrExcelEVEN
- @CalcMgrExcelFACT
- @CalcMgrExcelFLOOR
- @CalcMgrExcelGCD
- @CalcMgrExcelLCM
- @CalcMgrExcelMROUND
- @CalcMgrExcelMULTINOMIAL
- @CalcMgrExcelODD
- @CalcMgrExcelPOWER
- @CalcMgrExcelPRODUCT
- @CalcMgrExcelROUNDDOWN
- @CalcMgrExcelROUNDUP
- @CalcMgrExcelSQRT
- @CalcMgrExcelSQRTPI
- @CalcMgrExcelSUMPRODUCT
- @CalcMgrExcelSUMSQ
- Statistical Functions
-
String Functions
- @CalcMgrCompare
- @CalcMgrConcat
- @CalcMgrDecimalFormat
- @CalcMgrDoubleFromString
- @CalcMgrDoubleToString
- @CalcMgrDQuote
- @CalcMgrEndsWith
- @CalcMgrFindFirst
- @CalcMgrFindLast
- @CalcMgrFormatDouble
- @CalcMgrGetListCount
- @CalcMgrGetListItem
- @CalcMgrIndexOf
- @CalcMgrIntegerToString
- @CalcMgrLastIndexOf
- @CalcMgrLowercase
- @CalcMgrMatches
- @CalcMgrMessageFormat
- @CalcMgrPadText
- @CalcMgrUppercase
- @CalcMgrRemoveQuotes
- @CalcMgrRemoveDQuotes
- @CalcMgrRemoveSQuotes
- @CalcMgrReplaceAll
- @CalcMgrReplaceFirst
- @CalcMgrSortAndReturn
- @CalcMgrSortList
- @CalcMgrSortValues
- @CalcMgrSplit
- @CalcMgrSQuote
- @CalcMgrStartsWith
- @CalcMgrStringsToString
- @CalcMgrSubstring
- @CalcMgrTextLength
- @CalcMgrTrim
- Inserting Functions into Components
- Working with Smart Lists
- Inserting Smart Lists
- Working with Planning Formula Expressions
- Working with Hybrid Aggregation in Essbase
-
10
Validating and Deploying
- Validating Business Rules, Business Rulesets, and Formula and Script Components from the System View
- Validating a Business Rule from the Rule Designer
-
Deploying Business Rules and Business Rulesets
- About Deploying Business Rules and Business Rulesets
- Making Business Rules and Business Rulesets Deployable and Not Deployable
- Deploying Business Rules and Business Rulesets from the Deployment View
- Deploying a Business Rule or Business Ruleset from the Rule or Ruleset Designer
- Deploying Business Rules with Shortcuts
- Specifying Which Deployed Business Rules Are Displayed in Planning
- 11 Launching Business Rules
- 12 Exporting and Importing Business Rules, Business Rulesets, Templates, and Formula and Script Components
-
13
Administering Essbase Servers, Applications, and Databases for Planning Applications
- Working with Database Properties
- Removing Locks from Database Objects
- Starting and Stopping Applications
- Starting and Stopping Databases
- Restructuring a Database
- Verifying an Outline
- Clearing Data from the Database
- Working With Location Aliases for Block Storage Applications
- Using Query Tracking on Aggregate Storage Databases
- Compacting Aggregate Storage Database Outlines
- Importing and Exporting Level Zero Data
- Merging Incremental Data Slices
- Aggregating Data
- Executing the Aggregation Process
- Managing Requests
- Adding Planning Drill Through Definitions