1. On the EPM Cube Editor - Edit Business Definition screen, expand the Formula node.
The Calculation and Filter nodes display.
2. Right-click Calculation and select Define calculation as.
The list of calculation types displays. The following image displays the context menu.
You can select among the following calculation types:
• A binary operator
Every binary operator can have as many operands as you specify. The following table describes binary operators and their ways of handling the operands.
Description Symbol
The Addition operator provides the sum of all child operand nodes.
+
The Multiplication operator provides the multiplication of all child operand nodes.
×
The Subtraction operator subtracts all child operand nodes from the first child operand node.
-The Division operator uses the first child operand node as a dividend and all the following child operand nodes as divisors.
÷
• A function
Every function can have as many operands as you specify. The following table describes the functions and their ways of handling the operands.
Description Abbreviation
The Square Root function calculates the square root of the first child operand. All the following child operands are ignored.
sqrt
The Power function raises the first child operand in the power of the second child operand. All the following child operands are ignored.
pow
The Logarithm function calculates the logarithm of the first child operand with the logarithmic base represented by the second child operand. All the following child operands are ignored.
log
The Common Logarithm function calculates the common logarithm (the base is 10) of the first child operand. All the following child operands are ignored.
lg
The Natural Logarithm function calculates the natural logarithm (the base is the Euler number) of the first child operand. All the following child operands are ignored.
ln
The Summation function calculates the summation of all child operands.
sum
The Size function calculates the size of the first child operand. All the following child operands are ignored.
length
The Substring function extracts a substring of the first child operand. The second child operand denotes the start position of extraction. The third child operand Substring
denotes the length of the string being extracted. All the following child operands are ignored.
Description Abbreviation
This function converts the first child operand into uppercase. All the following child operands are ignored.
Uppercase
This function converts the first child operand into lowercase. All the following child operands are ignored.
Lowercase
The Maximal function selects the maximal child operand of all child operands available.
Max
The Minimal function selects the minimal child operand of all child operands available.
Min
• Just a value of something
The following table describes the values from which you can select.
Description Name
When you select this value, the EPM Cube Editor - Business Glossary screen displays where you can select the required business definition.
Only Standard and User Defined business definitions can be selected.
Business Definition
When you select this value, the EPM Cube Editor - <ERP system> Database Structure Browser dialog displays where you navigate to and select the required database table, and then database field.
Database tables and fields that you can add to the current cube calculation display.
Those that cannot be added to the calculation do not display and so are unavailable Database Field
for selection. For example, all the TEXT type columns, which cannot be used in cube calculations, are hidden.
Note
SQL tables pertaining to the SQL schema different than dbo also display in the Database Structure Browser. EPM Server can talk to multiple schemas in the same SQL server source database at once to build a single cube.
When you select this value, the EPM Cube Editor - Supply Literal dialog displays.
Specify the literal value and click OK.
Literal
Selecting Context prompts for further selection. The available values are:
Context
• Company Code
• Financial Year
• Accounting Dimension Number
• Current Year
Description Name
Selecting constant prompts for further selection. You can select one of the following constants:
Constant
• Null Value (0)
• Euler Number (e)
• Pi Number
3. Select the calculation type in the context menu.
Notice, the item you select displays as a new node under the Calculation node on the EPM Cube Editor - Edit Business Definition screen.
4. If you selected a binary operator or a function as the calculation type, select the calculation operands.
For this purpose, right-click the name of the calculation type and select Add Operand. The following menu similar to the menu for selecting calculation type displays.
An operand can be a binary operator, a function, or a value.
You can add as many operands as you want for any binary operator or function. However, not all the specified operands may be processed. Review the information in step 2 for details on processing operands by binary operators and functions.
Notice, the operands you select display as a new nodes under the Calculation - <Operator or Function>
node on the EPM Cube Editor - Edit Business Definition screen.
5. You can perform the following actions on the operands:
• Replace one operand with another
For this purpose select the Change to command. The menu similar to the menu for selecting a value (see the description of the Just a value of something option) displays. In this menu, select the value with which the operand must be changed.
• Reorder operands
For this purpose, use the Move Up and Move Down commands. These commands are available if there is more than one operand. If you move down the last operand, it becomes the first; similarly, if you move the first operand up, it becomes the last.
• Remove operands
For this purpose select the Remove command.
Right-click the operand and select one of these options.
You can compose calculations at any level of difficulty. In addition, any nesting level is supported for the calculation.
Repeat steps 2-5, in any order, as many times as required to compose the calculation you need.