11Allocations and Periodic Entries

This chapter contains the following:

Overview

In Oracle Fusion General Ledger, use the Calculation Manager to create allocations and other formula journal templates for generating periodic journal entries automatically. Allocations are defined and generated from preaggregated balances in the GL Balances cubes, which provide the following benefits:

  • Immediate real-time access to financial balances for allocations and periodic entries.

  • Accelerated performance for complex allocations.

You can base formulas on multiple criteria. For example:

  • Use account balances or statistical amounts to allocate shared revenue or costs across multiple organizational units and ledgers.

  • Define complex computations based on variables from different charts of accounts.

  • Group journal formulas together and execute sequentially to update account balances in a step-by-step process.

The Calculation Manager provides flexibility, automation, intelligence, and control in distributing costs and revenues across the enterprise. In addition, the Calculation Manager:

  • Includes runtime variables, rules, formulas, and rule sets stored in Oracle Essbase.

  • Distributes revenues or costs with recursive allocation rules.

  • Creates complex formula rules using formula components.

  • Contains an Allocation Wizard to define allocation and formula rules.

  • Uses real-time checking of rule definitions to validate correctness of rules.

  • Minimizes setup and maintenance time with reusable components.

  • Simplifies allocation generation mechanism by integrating with enterprise schedule.

  • Groups rules together in rule sets and cascading allocations for efficient processing.

  • Creates primary, statistical, or foreign currency allocation and formula rules.

Access the Calculation Manager from the Tasks pane of the General Accounting dashboard or Journals work area by clicking the:

  • Define Allocation Rules link to define or modify allocation definitions

  • Generate Allocations link to run the allocation process

Note: Adobe Flash Player 10 or higher is a required component for the Calculation Manager. Upgrade your Adobe Flash Player if the Calculation Manager's performance slows down after upgrading your browser.

For more information, see the Oracle Hyperion Calculation Manager Designer's guide.

The Calculation Manager creates, validates, deploys, and administers sophisticated allocation rules. In the Calculation Manager:

  • Base formulas on multiple criteria, such as account balances or statistical amounts, to allocate shared revenue or costs across multiple organizational units.

  • Use complex computations based on different variables to automatically calculate allocated amounts.

  • Group journal formulas together and executed sequentially to update account balances step-by-step.

There are three types of objects that can be created in Calculation Manager:

  • Components: Contain formulas, points of view, or allocation objects.

  • Rules: Contain components such as points of view, formulas, and templates, which are used to create allocation calculations.

  • Rule Sets: Contain sets of rules that can be calculated sequentially

Note: The following are limitation in Oracle Fusion General Ledger.
  • Allocation rules cannot be shared across rule sets in Calculation Manager.

  • Within a rule or rule set, the same target or offset cannot be written to by multiple rule components.

  • When generating allocation rules with run time prompts other than the User Point of View in an allocation rule component, an error occurs.

Overview of Oracle Essbase Balances Cubes

Oracle Essbase is embedded within Oracle General Ledger and provides multidimensional balances cubes. Every time a transaction or journal is posted in General Ledger, the balances cubes are updated at the same time.

The flowing table lists and describes Essbase Dimensions and provides examples of dimension members.

Dimension Description Example

Accounting Period

Based upon the calendar of the ledger or ledger set. Report on years, quarters, or periods.

  • 2012

  • QTR-1

  • JAN-12

Ledger or Ledger Set

Used to select a ledger for the reporting. Multiple ledgers may be in the same cube if they share a common chart of accounts.

  • InFusion North America Ledger Set

  • InFusion US Primary Ledger

Chart of Accounts Segments

Uses a separate dimension for each of the segments from the charts of accounts. Organized by hierarchy. A default hierarchy is provided that includes all detail segment values. Hierarchies published in the Publish Account Hierarchies user interface are included.

  • Company: InFusion America: 101

  • Cost Center: Sales: 400

  • Account: Cash: 1110

Scenario

Indicates if the balances represented are actual or budget amounts. Allocation-related dimensions are predefined members and required for allocation solutions. Allocation dimensions are not used directly by end users.

Budget scenario dimension members are user-defined in the Accounting Scenario value set and appear in the cube after running Create Scenario Dimension Members process.

  • Budget 2012

  • Actual

  • Forecast 2013

Balance Amount

Indicates if the value is the beginning balance, period activity, or ending balance. Debit, Credit, and Net amounts are available for reporting.

  • Beginning Balance (DR, CR, or Net)

  • Period Activity (DR, CR, or Net)

  • Ending Balance (DR, CR, or Net)

Amount Type

Indicates whether the amounts represent Base, Period to Date, Quarter to Date, or Year to Date.

  • Base

  • PTD: Period to Date

  • QTD: Quarter to Date

  • YTD: Year to Date

Currency

Used to select the wanted currency for the balances.

  • All ISO Currencies

  • USD: US Dollar

  • JPY: Japanese yen

Currency Type

Used to select the currency type of the balances.

  • Total

  • Entered

  • Converted From (for each ISO currency)

Allocation Security

To access the Calculation Manager, you must be assigned one or more of the four privileges and permissions.

The following privileges and permissions are associated with the Calculation Manager:

  • Generate General Ledger Allocation Formula - Generate Allocation and Periodic Entries: Permits generation of allocation and periodic entries.

  • Define General Ledger Allocation Formula - Manage Allocation Rules or Rulesets through Calculation Manager: Grants the ability to update allocation rules or rule sets owned by the user with view access to all allocation rules or rule sets regardless of their ownership.

  • Define Self Managed General Ledger Allocation Formula - Manage Allocation Rules or RuleSets through Calculation Manager: Grants the ability to update allocation rules or rule sets, but limited to the ones owned by the user.

  • Administer General Ledger Allocation Formula - Administer Allocation Rules or RuleSets through Calculation Manager: Grants the ability to update all aspect of allocation rules or rule sets including the ownership attribute, regardless of the original definition's ownership.

Recurring Journals

Overview of Recurring Journals

Define recurring journal formulas for transactions that you repeat every accounting period, such as accruals, depreciation charges, and allocations. Your formulas can be simple or complex. Each formula can use:

  • Fixed amounts and account balances, including standard, actual amounts, statistics, and period-to-date or year-to-date balances.

  • Amounts from the current period, prior period, or same period last year.

  • Amounts in your formulas, including total balances, entered currency balances, or statistical balances.

You can quickly create recurring formulas by copying and modifying existing formulas. You can:

  • Define single ledger or multiple ledger recurring journal formula batches.

  • Create a recurring journal formula batch that contains recurring journal entries for different ledgers.

  • Define recurring journal formulas for your ledger currencies, entered currencies, and statistical currency.

You can use the following types of recurring journal entries to reduce data entry time and increase accuracy for journal entries that repeat each period.

  • Skeleton: With no amounts

  • Standard: With set amounts

  • Formula: With variable amounts

Skeleton Journal Entries

Skeleton journal entries contain the same accounts each period, but have different amounts. After you generate skeleton journal entries, edit the unposted journal batch by entering the journal line amounts on the Edit Journals page.

Use skeleton journal entries to record statistical journals, such as headcount, units sold, barrels of oil, or other statistical factors. For example, to enter headcount for your cost centers each period:

  1. Define a skeleton entry with your headcount accounts.

  2. Generate the skeleton entries.

  3. Enter the actual headcount amounts before posting the batch.

Note: Set the journal entry to reverse automatically at the beginning of the next period if you enter the total headcount each period. Otherwise, if you only enter the change in the headcount each period, a reversing journal isn't required.

Best practices recommend that you create skeleton recurring journal entries in spreadsheets or copy existing journals.

To create journals in spreadsheets:

  1. Navigator > Journals.

  2. Select the Create Journal in Spreadsheet link to download the workbook template once.

  3. Create and save the skeleton journal entry.

  4. For each period open the template and enter the amount for the journal lines already in the template.

  5. Upload the batch.

  6. Open the journal on the Edit Journal page and add the amounts.

  7. Once the updates are made, save, complete, and post the journal batch.

To copy journals:

  1. Navigator > Journals > Manage Journals.

  2. Search for the journal to copy.

  3. Open the journal.

  4. Click the Batch Actions Menu > Copy.

  5. Make the wanted changes to the new journal.

  6. Save, complete, and post the journal batch.

Standard Recurring Journal Entries

Standard recurring journal entries contain the same accounts and amounts each period. Just as with skeleton recurring journal entries, best practices recommend that you create standard recurring journals in spreadsheets.

  1. Navigator > Journals.

  2. Select the Create Journal in Spreadsheet link to download the workbook template once.

  3. Create and save the standard journal entry.

  4. For each period, upload, and submit the batch with posting selected. The recurring journal batch is created and posted.

Formula Recurring Journal Entries

Formula recurring journal entries contain formulas created using the formula component and allocation wizard in the Calculation Manager. These formulas calculate journal amounts that vary from period to period and are based on existing account balances or other criteria.

Use recurring journal entries to perform simple or complex allocations or eliminations. For example, you can allocate:

  • A portion of your rent expense to another division.

  • A pool of marketing costs to several departments based on the ratio of department revenues to total revenues.

Create Recurring Journals

This example shows how to define and generate formula recurring journals that are automatically generated every period.

You must have:

  • A role that can access the Journals work area in Oracle General Ledger.

  • A duty that can access the Create Allocation Rules task.

The following assumptions apply:

  • The chart of accounts includes segments for company, department, account, subaccount, and product.

  • Account 1210 is the trade receivables account.

  • The period-to-date activity in account 1210 is 100,000 USD.

Here are the goals for this example.

  • Create a journal that populates a monthly allowance for bad debt based on 5% period-to-date activity in the trade receivables account.

  • Account 7730 is the bad debt expense account and account 1260 is the allowance for bad debt account.

  • A formula rule must be defined to generate the following journal entry for the period Apr-17 and thereafter.

    • DR 01.000.7730.0000.000 5,000 USD

    • CR 01.000.1260.0000.000 5,000 USD

This worked example includes details for the following tasks:

  1. Configuring the Formula Rule

  2. Creating the Runtime Prompt Variable

  3. Creating the Rule Set

  4. Generating the Allocation Journal

Configuring the Formula Rule

Create a formula rule.
  1. Navigate to the Journals work area.

  2. From the Tasks pane, click Create Allocation Rules.

  3. Navigate to the Administer menu option and then select Calculation Manager. Calculation Manager opens in a new browser window and a cube is highlighted based on the data access set selected in the Journals work area.

  4. Expand Essbase.

  5. Expand VF_USA_Accounting_Flexfield (your cube).

  6. Expand db.

  7. Highlight the Rules row, right-click, and select New from the menu.

  8. Enter the Rule Name: Special Bad Debt Allocation, accept the other defaults, and click OK.

  9. The Rule Designer opens in a new tab. From the New Objects list, click, hold, and drag the Point of View object. Place it between the Begin and End nodes in the Rule Designer.

  10. Enter a Caption: Point of View.

  11. Perform the following steps to enter a Variable Dimension Value:

    • Click the Value field for Accounting Period.

    • Click the Actions icon and select Variable from the drop-down list. A new window opens.

    • For the Category, select Database from the drop-down list.

    • Click Accounting_Period.

    • Click OK.

  12. Perform the following steps to enter other member dimension values:

    • Click the Value field for another dimension.

    • Click the Actions icon and select Member from the drop-down list.

    • Select a member and click the Add icon to move the member to the Selections panel.

    • Click OK. Repeat for all dimensions to include in the Point of View.

    • In this scenario, the following are fixed dimension values:

      • Company: 01

      • Department: 000

      • Subaccount: 0000

      • Product: 000

      • Currency: USD

      • Currency Type: Total

    • From the New Objects list, click, hold, and drag the Formula component and place it between the Point of View nodes in the Rule Designer.

    • Enter a Caption: Bad Debts Calculation.

    • Enter the offset member.

    • Click Next.

    In this scenario, the offset is defined as account 1260, the allowance for bad debt. The offset is child combination 01.000.1260.0000.000 when combined with the fixed member dimension values in the Point of View.

  13. Perform the following steps to enter the Formula member dimension value:

    In this scenario, the formula member dimension value is defined as account 7730. The bad debt expense is charged to child combination 01.000.7730.0000.000 and combined with the fixed member dimension values in the Point of View.

    • Click the icon for the formula field and select Member from the drop-down list.

    • Select the Account dimension value, highlight the row, and click the Select icon to move the value to the Selections panel.

      In this scenario, the goal is to calculate an allowance for bad debt based on the period-to-date activity in trade receivables account 1210. Trade receivable is child combination 01.000.1210.0000.000 when combined with the fixed member dimension values in the Point of View.

    • Repeat for the other formula member values and click OK when all formula members are selected.

      In this scenario, the following dimension values are selected. Selection of members for the following dimensions is required for the source in a formula component.

      • Scenario: Actual

      • Balance Amount: Period Activity

      • Amount Type: PTD

    • Multiply the formula expression by .05.

    • Click the Save icon.

    • Click the Validate and Deploy icon.

Creating the Runtime Prompt Variable

Create a runtime prompt variable as an optional component of a rule. When you generate an allocation based on a rule with a defined runtime prompt variable, you are prompted to specify a dimension member for the variable. The variable is used in the allocation calculation.

For example, use a runtime prompt variable of Accounting Period, which prompts you to specify the period to use in the allocation calculation. A runtime prompt variable can be created once and used in multiple rules.

  1. Navigate to the Journals work area.

  2. From the Tasks pane, click Create Allocation Rules.

  3. Once the Calculation Manager opens in a new browser window, a cube is highlighted based on the data access set selected in Journals work area. To define the runtime prompt, select Variables from the Tools menu.

  4. Expand to the db for the cube, highlight the row, right-click the row, and select New from the menu.

  5. The Variable Designer opens in a new tab. A default value must be entered and the variable name can't contain any spaces. Complete the fields, as shown in this table.

    Field Value

    Name

    AccountingPeriod

    Type

    Member

    Dimension

    AccountingPeriod

    Default Value

    Apr-17

    RTP

    Selected

    RTP Text

    Enter Accounting Period

  6. Click the Save icon. The runtime prompt variable is ready for use.

Creating the Rule Set

Rule sets are created by combining two or more related rules together to enable sequential allocating of balances.
  1. Navigate to the Journals work area.

  2. From the Tasks pane, click Create Allocation Rules.

  3. After the Calculation Manager opens in a new browser window, expand to Rule Sets for the selected cube. Highlight the row, right-click the row, and select New from the menu.

  4. Enter the rule set name and click OK.

  5. The Ruleset Designer opens in a new tab. Expand to the db for the cube for which the rule set is created, expand the rules, and drag the rules for the rule set.

  6. Click the row for the rule set, click the Variables tab, and select Merge Variables.

    Merge variables means that common variables among all of the rules in the rule set are merged. You only have to select the runtime prompt value once when submitting the Generate General Ledger Allocations process.

  7. Click the Save icon.

  8. Click the Validate and Deploy icon.

Generating the Allocation Journal

Start the allocation process to create the journal entries that populate the account balances.
  1. Navigate to the Journals work area.

  2. From the Tasks pane, click Generate General Ledger Allocations.

  3. Select a rule or rule set and enter any runtime prompt values.

  4. Click Submit.

  5. The Generate General Ledger Allocations task submits four processes consecutively (three, if the Post Allocations option isn't is selected). The processes calculate the allocation, write the results to the GL_INTERFACE table, import the journal batches, and post the journal batches to the General Ledger.

Schedule Recurring Journals

You can create processing schedules for recurring journal entries that have been defined in the Calculation Manager. Scheduling automates the monthly generation of the entries and speeds up the close process.

You can define multiple schedules for each calendar in General Ledger. These schedules can increment by accounting period, based on any calendar defined. Schedules are shared across ledgers.

Scenario

In this example, you have created a reserve for bad debt recurring journal entry in the Calculation Manager. Now, add a recurring schedule to the entry to generate the entry once a month on the last day.

  1. From the Journals work area, select the Generate General Ledger Allocations task. The Generate General Ledger Allocations page opens.

  2. Select the rule: Reserve for Bad Debt.

  3. Specify Accounting Period: Blank

    Note: The Accounting Period field appears if you use a runtime prompt in your rule and select Accounting Period as the runtime variable.
  4. Select the Post Allocations option.

  5. Click Advanced.

  6. Click the Schedule tab.

  7. Select the Using a schedule option.

  8. Select a frequency of Monthly.

  9. Select Repeat: By date.

  10. Enter start and end dates.

  11. Click Submit.

    The following figure shows the Schedule tab on the Generate General Ledger Allocations process page. The options on the page are set to the values as directed in steps 7 through 10.

    This figure shows the Schedule tab on the Generate
General Ledger Allocations page.
  12. The generation process runs at the scheduled time.

Calculation Manager

Calculation Manager Toolbar

In addition to the Enterprise Performance Management Workspace buttons, the Calculation Manager toolbar displays buttons that are specific to the Calculation Manager. Not all buttons display in all the views and designers within the Calculation Manager.

The Calculation Manager toolbar consists of the following buttons:

  • Home: Displays the default start-up option for the content area.

  • System View: Displays the main view within the Calculation Manager. (This is the default view).

  • List View: Displays a list of objects that you can filter by application type, application, object or database type, deployment status, and validation status.

  • Custom View: Displays a view you can change with folders that you create.

  • Filter Options: Opens the Filter dialog that you can use to filter objects in the List View.

  • Refresh: Refreshes the view with your latest changes.

The Calculation Manager toolbar adds the following buttons when you open a rule:

  • Save: Saves the object with which you're working.

  • Validate: Validates the object with which you're working.

  • Validate and Deploy: Validates and deploys the object with which you're working.

Calculation Manager Menus

Calculation Manager menus and menu options display in addition to Enterprise Performance Management Workspace menus and menu options. The menus and options vary depending on the view you're using and the object with which you're working. The default view of the Calculation Manager displays the following menus when you launch Calculation Manager, System View.

Note: This topic describes the Calculation Manager menu options only.

File Menu

Enables you to create objects, open and close objects, import and export objects, print rules, and log off.

Note: Not all of these file menu options are available for the products that use Calculation Manager.
  • New, Rule: Creates a rule

  • New, RuleSet: Creates a rule set

Edit Menu

Enables you to edit objects you select. The Edit menu is available from most of the views and from within the Rule and Component definition pages.

  • Edit, Delete: Deletes an object selected in the System, List, or Custom View

  • Edit, Copy: Copies selected text

  • Edit, Paste: Pastes text from the clipboard

  • Edit, Copy Group: Copies a component group

Note: The Edit menu isn't available within the Deployment View.

View Menu

Enables you to open different views.

  • View, View Pane: Displays or hides a list of existing and new objects that you can add to rules, rule sets, components, and templates.

    Note: View Pan is the only View menu option available from within the Rule Designer and Rule Set Designer.
  • View, List View: Displays a list of the objects you select on the Filter dialog. The filter dialog enables you to create a filtered list, by application type of applications, databases, and objects.

  • View, System View: Displays a list of the Essbase applications, databases, and objects to which you have access. The System View is the default view.

  • View, Custom View: Displays a view that you can change with folders that you create. This view enables you to organize objects in a way that's meaningful to you.

  • View, Deployment View: Displays a list, by application type and application, of the rules and rule sets that are deployed and not deployed with their deployment and validation status.

Tools Menu

Enables you to install other products, search for objects, create a filtered list of objects for the List View, edit the caption of an object, and access the Variable Navigator and Variable Designer.

  • Tools, Filter: Opens the Filter dialog from which you can filter by application type, application, object type (rule, rule set, formula or script component, or template), calculation type, plan type, database, deployment status, and validation status. You can also select All to display all application types, applications, objects, and databases, regardless of their deployment and validation status.

  • Tools, Variables: Opens the Variable Navigator in which you can navigate to a location for which you want to create, edit, copy, or delete a variable. From the location you select in the Variable Navigator, you can display the Variable Designer in which you can create, edit, copy, and delete variables for components.

    Note: The two menu options listed aren't available within the Deployment view.

Actions Menu

Enables you to validate and deploy objects that you select in the views and from within the Rule and Rule Set Designers. Not all of the Actions menu options are available from within the views and designers.

  • Actions, Validate: Validates the rule, rule set, and formula component you selected

    Note: This is the only Actions menu option available from within the Deployment View.
  • Actions, Deploy: Deploys the rules or rule sets you selected.

  • Actions, Quick Deploy: Deploys the rule in fewer steps than regular deployment by using a shortcut to one or more applications.

    Note: This feature is available only from within the Rule Designer for Essbase business rules.

How You Use Flow Charts in Rule Designer

View rules and templates, and the components they include, in a flow chart within the Rule Designer. When you open a rule, move among the components, for example, formulas, ranges, and loops, by selecting them in the flow chart. Increase or decrease the size of the flow chart to view or hide details of the components.

When you select a component in the flow chart, its properties, usages, and other information are displayed in tabs. As you move among the components, the tabs change. For example, if you open an allocation rule and select the formula component in the flow chart the following properties are displayed:

  • Properties of the formula, such as name, description, application, and application type to which the formula belongs

  • Usages of the formula, such as which rules and templates the formula is used in.

  • Text of the formula, such as the variables, members, and functions, that are displayed in the tabs.

Calculation Manager Views

Views enable you to see Calculation Manager objects in different contexts. For example, the Deployment View displays objects according to whether they're deployed or not deployed. The Custom View displays objects according to filters and criteria that you select.

The Calculation Manager contains the following views:

  • List View

  • System View

  • Custom View

  • Deployment View

  • View Pane

List View

The List View contains a filtered list of Essbase applications or databases, and objects, rule sets, rules, or formula components, filter according to your criteria.

System View

The System View is the default view that's displayed when you start the Calculation Manager. It contains a list of all of the applications and objects to which you have access. Your privileges are determined by the role you're assigned in Shared Services. For each object, the owner, the user who made the last change, and the date the changes were last made are listed.

Custom View

The Custom View enables you to create folders and move objects into them to create a view that contains only your objects. This view enables you to organize objects in a way that's meaningful to you.

Deployment View

The Deployment View contains a list of the rules and rule sets that are deployable with their deployment and validation status. From this view, select rules and rules sets in an application to make them deployable. Deploy one or more rules or rule sets (partial deployment), or deploy all rules and rule sets in an application (full deployment).

View Pane

The View Pane enables you to create or open an object. Depending on whether you're working in a rule or a rule set, the Rule or Ruleset Palette, is displayed in the View Pane. In the palette, move new and existing objects into the rule, rule set, or flow chart.

When working with views display or hide the View Pane using the View menu. In the Custom View, move new and existing objects from the View Pane into the folders you create. In the System and List views, the View Pane is hidden by default. In the Deployment View, the View Pane isn't available.

Note: The View Pane content varies depending on which view you're in and whether you're working with a rule set, rule, template, or component.

The following table lists the tasks that can be performed from the various views in the Calculation Manager.

Tasks List View System View Custom View Deployment

Create, open, rename, delete, refresh, and close objects

Yes

Yes

Yes

Yes

Set preferences

Yes

Yes

Yes

Yes

Import and export objects

Yes

Yes

Yes

Yes

Show the usages of objects

Yes

Yes

Yes

Yes

Create a copy of objects

Yes

Yes

Yes

Yes

Print a business rule

Yes

Yes

Yes

Yes

Select views

Yes

Yes

Yes

Yes

Sign out Workspace

Yes

Yes

Yes

Yes

Work with favorites

Yes

Yes

Yes

Yes

Perform an advanced search

Yes

Yes

Yes

Yes

Start help

Yes

Yes

Yes

Yes

Filter objects in the view according to criteria you specify

Yes

No

No

No

Work with variables

Yes

Yes

No

Yes

Validate objects

Yes

No

No

Yes

Create a shortcut to a business rule

No

Yes

No

No

Import and export business rules and other objects

No

Yes

Yes

No

Validate and migrate objects

No

Yes

Yes

No

Change the owner of an object

No

No

Yes

Yes

Deploy objects

No

No

No

Yes

Filter Objects in the List View

You can use filters in the List View to filter objects according to:

  • Application Type that is populated by default with the application type, such as Essbase, your application or database, in which you are creating the new rule.

  • Object type, such as allocation rules, allocation rule sets, and formula components

  • Deployment or validation status

Scenario

To create a filtered list of objects in the List View:

  1. From the System View, select View, List View.

    The Filter dialog is displayed the first time you open the List View. If you select filtering options, then close the List View to work in the System or Custom View. When you reopen the List View, the filter dialog is not displayed. To change the filtering options when you reopen the List View, select Tools, Filter to open the Filter dialog.

  2. In the Filter dialog, on Filter Options, for Application Type, select Essbase.

  3. Do one of these tasks:

    • For Essbase: In the Application and Object Type fields, select the applications and object types you want to display in the List View. The default is All.

    • For Deployed Status and Validated Status, clear any check boxes of selections you do not want to display. All check boxes are selected by default.

      Tip: Click Reset to reset the dialog with default values.
    • On Advanced Options, for Object Label, select one of these options to display only objects whose names match the criteria:

      • Starts With, to display only objects whose names start with characters you specify.

      • Ends With, to display only objects whose names end with characters you specify.

      • Contains, to display only objects whose names contain characters you specify.

      • Matches, to display only objects whose names match characters you specify.

    • Enter the characters that are common to the names of the objects you want to display.

    • Select Ignore case to display objects whose names contain characters in either upper or lower case, even if the case does not match the case of the text you entered in step 6.

    • In Created By, enter the name of the user who created objects you want to display.

    • In Modified By, enter the name of the user who modified objects you want to display.

    • For Created Date, select After, Before, or Between to display only objects that were created after, before, or between dates you specify. Between is the default. Click the list of values to display calendars from which you can select dates.

    • For Modified Date, select After, Before, or Between to display only objects that were modified after, before, or between dates you specify. (Between is the default.) Click the list of values to display calendars from which you can select dates.

    • For Any Text, select an option to display only objects containing text that starts with, ends with, contains, or matches text that you enter. To display objects that include this text regardless of its case, select Ignore case.

  4. Click OK.

Allocation Rules

Overview of Allocation Rules

The Calculation Manager enables you to create, validate, deploy, and administer sophisticated multidimensional allocation rules. An allocation rule is logical expressions or formulas that are created within an application to produce a set of resulting values. Create an allocation rule set of two or more related rules to launch the rules sequentially.

Before you create a rule or rule set, you must understand the database outline and the application with which you are working. This information helps you create your allocation rules more efficiently. Learn the following about your data:

  • How the data is stored and aggregated.

  • What level the data gets loaded into the database.

  • What order the calculations are performed.

  • What key assumptions drive the calculations.

Create allocation rules using components like formulas, member ranges, and variables, including run time prompt variables.

Create an Allocation Rule

You can create one or more allocation rules to use to allocate balances, as needed for financial reporting from the System View. You can also create an allocation rule from the List, Custom, and Deployment Views.

Scenario

To create a new rule:

  1. Navigator > General Accounting: Journals > Create Allocation Rules link.

  2. Navigate menu > Administration > Calculation Manager.

  3. File menu > New > Rule.

  4. In New Rule, enter the rule's name.

  5. Enter the Application Type: Essbase.

    Note: The application type is populated by default with the application type in which you are creating the new rule.
  6. Select an Application Name. The application name must be a valid Essbase application such as your chart of accounts name.

  7. Select the Database.

    Note: If you expand the following options in the System View: Essbase > your Application > Database name, then right-click Rules and select New to create a new rule, the New Rule dialog is populated with the Application Type, the Application, and the Database you are working in within the System View.
  8. Click OK. The new rule is displayed in the Rule Designer.

Design an Allocation Rule

An allocation rule is a Calculation Manager object that consists of calculations. The calculations are grouped into components. A rule can contain one or more components.

You create an allocation rule for an Essbase application. The rule is represented graphically in a flow chart into which you can drag and drop components to design the rule.

Scenario

To design an allocation rule:

  1. Navigate to the Journals work area and click the Create Allocations Rules task from the Tasks pane.

  2. Click Navigate > Administration > Calculation Manager.

  3. In the System View, perform one of these tasks:

    • Click File > New > Rule. Expand the Essbase Application Type, the Application, and the Calculation Type, Plan Type, or Database.

    • Right-click Rules and select New.

  4. In New Rule, enter the rule's name, the Application Type Essbase, and the Application Name. The application name must be a valid Essbase application.

  5. Select the Database.

  6. OK.

    Note: If you right-click Rules and select New to create a new allocation rule, the New Rule dialog is populated with the Application Type, the Application, and the Calculation, Plan Type, or Database you are working in within the System View.
  7. To design the allocation rule, from the Rule Palette, drag new and existing objects, and drop them into the flow chart within the Rule Designer.

    Note: You can also create objects such as formulas and scripts independently of the rule, and add them to the rule later.
  8. From New Objects, drag and drop these components to insert a new component into the rule's flow chart:

    • Point of Views:

    • Allocations:

    • Formulas:

  9. On Properties, enter properties for the rule.

    Note: The number and contents of the tabs change as you add components to the rule and move along the rule's components in the flow chart. To enter properties and other information for the rule's components, select the component in the flow chart. You can optionally:
    • Edit the name by entering a new one of up to 50 characters. The name defaults from the New Rule dialog.

    • Enter a description of up to 255 characters for the rule.

    • Enter a caption for the rule. The caption displays in the flow chart.

    • Enter comments for the rule. For example, you may want to tell the users how to use the rule.

  10. For Essbase: On Global Range, specify what dimensions are common to all of the components in the rule by selecting values, for example, members, variables, and functions for each dimension. The values you select for the dimensions are the values that are calculated when the rule is launched.

    1. Select values for a dimension by clicking its row in the Select Value column.

    2. When the Actions icon is displayed, click the icon, and select one of these:

      • Variable

      • Member

      • Function

  11. For Essbase: On Variables, select Merge Variables to merge all instances of the same variable used in the allocation rule so only the first instance of each variable is displayed when the rule is launched. If you do not select this check box, all instances of each variable are displayed.

    Note: If you select Merge Variables, the first value that the user enters for the runtime prompt is used for all subsequent occurrences of that runtime prompt during validation and launch.
  12. On the Usages tab, you view which allocation rules and rule sets use the rule, if any. You cannot edit any of the information about this tab. The following information is displayed for the allocation rules and rule sets using the allocation rule:

    • Names

    • Application Name

    • Deployment Status

    • Validation Status

    • Description

    Note: By default, an allocation rule is not used by any allocation rules or rule sets when create.
  13. Repeat these steps for each component you want to add to the allocation rule.

    Note: As you add components to an allocation rule, you can increase or decrease the size of the component icons and the amount of detail that is displayed in the flow chart. You can use the zoom bar to zoom in and out within the flow chart. You can select a component to view its properties and edit a component on the Properties tab.
  14. Select File, Save.

  15. After you design and save the rule, you can do any of these tasks:

    • Print it.

    • Validate it.

    • Deploy it.

    • Generate it from within Oracle General Ledger by navigating to the Journals work area and clicking Generate General Ledger Allocations from the Tasks pane.

Date Effective Allocation Rules and Rule Sets

Use the Date Effectivity for Allocation Rules and Rule Sets feature to generate allocations based on an allocation rule or rule set's start and end dates. With this feature, you can prevent recurring journals from being created on the wrong dates. The Generate Allocations and Generate Intercompany Allocations processes enforce the start and end dates that you enter based on accounting period. If you don't opt in to this feature, the generation process ignores the entered start and end dates.

Where You Enter Dates

You set up allocation rules and rule sets using Calculation Manager. The date fields are in the Properties tab in the Rule Designer and Rule Set Designer.

Here's a screenshot of the Properties tab on the Rule Designer.

This screenshot shows the Rule Designer in Calculation
Manager. The Properties tab has fields for start and end date.

Here's a screenshot of the Properties tab in the Rule Set Designer.

This screenshot shows the Rule Set Designer in
Calculation Manager. The Properties tab has fields for start and end
date.

How Dates Are Used

Recurring journals are generated only if the accounting dates for the resulting journals fall between the allocation rule (or rule set) start and end dates.

Note: The generate allocations process works the same way, regardless of whether you submit it manually or through a schedule.

Let's say you have an allocation rule with a start date of March 31, 2019, and an end date of May 31, 2019. You submit the allocation process on June 6, 2019. Here's what happens depending on the accounting period.

Accounting Period Are Recurring Journals Generated?

May-19

Yes. The accounting date for the journals is the last day of the accounting period, which is May 31, 2019. That date falls within the rule's start and end dates.

Jun-19

No. The accounting date for the journals is the last day of the accounting period, which is June 30, 2019. That date falls outside of the rule's end date of May 31, 2019.

How Start and End Dates Work with Rule Sets

If a rule set doesn't have a start and end date, this is what happens.

The generate allocations process checks the accounting dates for each rule's journals against that rule's start and end date. If the accounting date for any rule falls outside of its start and end date, none of the recurring journals are generated. Either all the journals for every rule in the rule set are generated, or none are generated.

If a rule set has a start and end date, a check is performed against the rule set's dates. The generate allocations process checks the accounting dates for each rule's journals against the rule set's start and end date. If the accounting date for any rule falls outside of the rule set's start and end date, none of the recurring journals are generated. Either all the journals for every rule in the rule set are generated, or none are generated.

Start Calculation Manager

This example demonstrates how to begin to create allocations and other journal templates with formulas, to generate periodic journal entries automatically.

Starting Calculation Manager

  1. Navigate to the General Accounting, Journals work area.

  2. In the General Accounting, Journals work area, click the Create Allocation Rules link.

  3. In the Enterprise Performance Management System Workspace, select Administer, then Calculation Manager from the Navigate menu.

  4. In Allocation Manager, select Variables from the Tools menu.

  5. Expand the Essbase tree.

  6. Expand the database to which you want to add a rule set. For this example, expand VF_USA_Accounting_Flexfield.

  7. Right-click the db icon and select New from the list.

    Note: If the database already has a rule set, you can add a rule by right-clicking the rule set and selecting New.

  8. On the Properties tab, complete the fields, as shown in this table.

    Field Value

    Name

    Balancing_Segment_Value

    Type

    Member

    Dimension

    Company

    Default Value

    3888

    RTP Text

    Enter Company Text

  9. Click Save.

Create an Allocation Rule with an Allocation Component

This example demonstrates how to create an allocation rule with allocation components.

You are the General Accountant for InFusion America Inc. You are creating an allocation rule with allocation components.

A rule consists of calculations that are grouped into components. When you design allocation rules, you add variables to components. Variables assume the values that you define for them. Replacement variables provide a substitution value when you design or generate an allocation rule.

Creating an Allocation Rule with an Allocation Component

  1. Click the Navigator.

  2. Click the Journals link for the General Accounting work area to access the Journals work area.

  3. Click the Create Allocation Rules link.

  4. In the Enterprise Performance Management System Workspace, click the Navigate menu.

  5. Select Administer and then Calculation Manager.

  6. On the System View tab of Calculation Manager, expand the Essbase tree.

  7. Expand the VF_USA_Accounting_Flexfield tree node.

  8. Expand the db tree item.

  9. Right-click the Rules tree item.

  10. Select New.

  11. In the New Rule dialog box, enter EMEA Overhead Distribution in the Name field.

  12. Click OK.

    You design a rule by dragging components from the Rule Palette to the Rule Designer flow chart. Each component performs a separate task. You can add Point of View, Allocation, or Formula components to your rule.

    You enter additional rule details on the Properties tab.

  13. In the Rule Palette area, drag the Point of View object to the Rule Designer area.

    The begin and end components of the rule appear in the Rule Designer work area.

  14. On the Point of View tab, click in the Ledger field of the Dimension value table.

  15. Click the Actions button for the Ledger field.

  16. Select Member.

  17. In the Member Selector dialog box, expand the Ledger tree, and expand the All Ledgers tree node.

  18. Click the Vision Operations (USA) tree item and click Select to move it to the Selections panel.

  19. Click OK.

  20. Repeat the preceding steps and complete the following dimension fields, as shown in this table.

    Field Value

    Company

    "All Company Values","00"

    Sub-Account

    "All Sub-Account Values","0000"

    Product

    "All Product Values","[Product]@[000]"

    Currency

    "USD"

  21. From the Rule Palette, drag Allocation to the Rule Designer panel.

  22. In the Allocate Wizard, click in the Value column of the AccountingPeriod field.

  23. Click the Actions button.

  24. Select Variable.

  25. In the Select Variable dialog box, select Database in the Category field.

  26. Click the Balancing_Segment_Value field, and click OK.

  27. Click Next.

  28. Click in the Select Value column of the Company field.

  29. Click the Actions button.

  30. Select Member.

  31. In the Member Selector dialog box, expand the Company tree.

  32. Expand the All Company Values tree item.

  33. Click the 00 tree item.

  34. Click Select to move it to the Selections panel.

  35. Click Next.

  36. Use the preceding procedure and complete the dimension fields, as shown in this table.

    Field Value Action

    Department

    "[Department]@[000]"

    Member

    Account

    an account

    Member

  37. Click Save and then OK.

Create an Allocation Rule with a Formula Component

This example demonstrates how to create an allocation rule with a formula component.

You are the General Accountant for InFusion America Inc. You are tasked with creating an allocation rule with a formula component.

Rules are based on formulas. The formulas use multiple criteria. For example, you can use account balances or statistical amounts to allocate shared revenue or costs across multiple organizational units. You can define complex computations based on variables from various charts of accounts. You can group journal formulas together and execute them sequentially to update account balances in a step-by-step process.

Creating an Allocation Rule with a Formula Component

  1. Click the Navigator.

  2. Click the Journals link from the General Accounting work area to access the Journals work area.

  3. Click the Create Allocation Rules link.

  4. In the Enterprise Performance Management System Workspace, click the Navigate menu.

  5. Select Administer and then Calculation Manager.

  6. On the System View tab of Calculation Manager, expand the Essbase tree.

  7. Expand the VF_USA_Accounting_Flexfield tree item.

  8. Expand the db tree node.

  9. Right-click the Rules tree item and select New.

  10. In the New Rule dialog box, enter EMEA Overhead Distribution in the Name field and click OK.

    You design a rule by dragging components from the Rule Palette to the Rule Designer flow chart. Each component performs a separate task. You can add Point of View, Allocation, or Formula components to your rule.

    You enter additional rule details on the Properties tab.

  11. On the Properties tab, complete the fields, as shown in this table.

    Field Value

    Name

    Reserve for bad debts.

    Description

    This formula rule calculates the reserve needed for bad debts.

  12. In the Rule Palette area, drag the Point of View object to the Rule Designer area.

  13. In the Point of View area, enter POV in the Caption field.

  14. Click in the Ledger field.

  15. Click the Actions button for the Ledger field.

  16. Select Member.

  17. In the Member Selector dialog box, expand the Ledger tree.

  18. Expand the All Ledgers tree item.

  19. Click the EMEA_PC_PL tree item.

  20. Click the Select button to move the ledger to the selected panel.

  21. Click OK.

  22. Repeat the preceding steps to complete the fields, as shown in this table.

    Field Value

    Company

    "[All Company Values].[3888]"

    Cost_Center

    "000"

    Program

    "[All Program Values].[0000]"

    Location

    "[Location]@[0000]"

    Division

    "[All Division Values].[0000]"

    Product

    "[All Product Values].[0000]"

    Intercompany

    "[All Intercompany Values].[0000]"

    Currency

    "USD"

    Currency Type

    "Total"

  23. Click the Actions button for the AccountingPeriod field.

  24. Select Variable.

  25. In the Select Variable dialog box, select Database in the Category field.

  26. Select the Accounting_Period variable and click OK.

  27. To define the formula, drag the Formula object from the Rule Palette to the POV loop in the Rule Designer.

  28. On the Formula tab, enter Bad Debts Calculation in the Caption field.

  29. Click in the Enter formula field.

  30. Click the Actions button for the Enter formula field.

  31. Select Member.

  32. In the Member Selector dialog box, select Scenario in the Dimensions field.

  33. Expand the Scenario tree and click the Actual tree node.

  34. Click the Select button to move Actual to the Selections panel.

  35. Repeat the preceding steps to select the remaining dimensions and members for the formula and complete the fields, as shown in this table.

    Field Value

    Balance Amount

    Ending Balance

    Amount Type

    YTD

    Account

    1399

  36. Click OK.

  37. To enter a formula to create 5 percent of total accounts receivable as reserve for bad debts, in the Enter formula field, at the end of the formula you just created, enter *.05*-1.

  38. To specify the target members, click in the Enter member name field.

  39. Click the Actions button.

  40. Select Member.

  41. In the Member Selector dialog box, expand the Account tree until the account 75555 appears.

  42. Click account 75555.

  43. Click the Select button to move the account to the Selections panel.

  44. Click OK.

  45. To specify offset members, on the Formula tab, enter "13005" in the Offset Member field.

  46. Click Save.

  47. Click OK.

  48. Click the Validate button and then the OK button to acknowledge validation of the rule.

  49. To deploy the rule, click the Quick Deploy button in the toolbar.

  50. On the Deployment Status dialog box, click OK to acknowledge successful deployment.

Edit an Allocation Rule

You can edit the structure of an allocation rule by adding to, removing, or changing its components. You can also edit the properties of the allocation rule's components and the properties of the allocation rule itself. You can edit these properties of an allocation rule:

  • Name and caption

  • Description and comments

  • Range of dimensions and members

  • Variables, you include in the allocation rule

Scenario

To edit an allocation rule:

  1. Navigator > General Accounting: Journals > Create Allocation Rules link.

  2. Navigate menu > Administration > Calculation Manager.

  3. In the System View, expand the Essbase Application Type, the Application, or Database, and Rules. Do one of these tasks:

    1. Right-click the rule you want to edit, and select Open.

    2. Select the rule you want to edit, and select File, Open.

  4. To edit the rule, in the Rule Designer, add new components, and copy and delete existing components, from the rule's flow chart.

    Note: As you edit components in an allocation rule, you can increase or decrease the size of the component icons and the amount of detail that is displayed in the flow chart. To edit, you use the zoom bar to zoom in and out within the flow chart. When the flow chart is displayed in small or very small sizes, the component captions do not display, but you can place your mouse pointer over any icon to read its caption. Regardless of the size of the components in the flow chart, you can select a component to view its properties on the Properties tab.
  5. To delete a component from the flow chart, select the component, right-click it, and select Remove.

  6. To copy and paste a component, select the component, right-click it, and select Copy. Then paste it into the flow chart.

  7. To add a new component:

  8. From New Objects, drag and drop components to insert a new component into the rule's flow chart:

    • Point of Views

    • Allocations

    • Formulas

  9. From Existing Objects, drag existing objects from Essbase applications and drop them into the rule's flow chart.

  10. For Essbase: On Global Range, you can edit the values that is, members, variables, and functions that define the range of values to be calculated when the rule is launched.

  11. Select values for a dimension by clicking its row in the Select Value column.

  12. When the Actions icon is displayed, click it, and select one of these:

    • Variable

    • Member

    • Member

  13. For Essbase: On Variables, you can create variables for the rule.

  14. On Usages tab, you can view which rules and rule sets use the rule, if any. This is the information you can view about the rules and rule sets that use the rule:

    Note: On the Usages tab, you view which allocation rules and rule sets use the rule, if any. You cannot edit any of the information on this tab. The following information is displayed for the allocation rules and rule sets using the allocation rule:
    • Names

    • Database

    • Application Name

    • Deployment Status

    • Validation Status

    • Description

  15. Select File, Save.

Print an Allocation Rule

You can print an allocation rule's properties, its flow chart, and the details of its components. For example, if you print an allocation rule that contains a formula component for allocation expenses and shows:

  • The formula syntax.

  • The functions and variables that comprise the formula.

  • A summary of the steps in the rule's flow chart but not in graphical form.

  • The rule's properties.

Note: You cannot print allocation rule sets.

Scenario

To print an allocation rule:

  1. Navigator > General Accounting > Journals >Create Allocation Rules link.

  2. Navigate menu > Administration > Calculation Manager.

  3. In the System View, expand the Essbase Application Type, the Application, or Database, and Rules. Select the rule you want to print.

  4. Select File, Print.

    Note: You can also select File, Print from within the Rule Designer to print a rule.
  5. In Print Preview, do these tasks:

  6. Select the Print options:

    • Paper size

    • Print orientation: portrait or landscape.

  7. Select General Rule Information to print the rule's description and other details from the Properties tab. The details include the rule's name, the application, its owner, the date the rule was created, and the date the rule was last modified.

  8. Select Flow Chart and Expanded or Collapsed, to print the flow chart, and you want to print it with the component details expanded or collapse.

  9. Select the number of pages you want to print the components across (horizontally). Select the number of pages to print the components down (vertically).

  10. Select the Page Order options:

    • Down, then across: The components in the flow chart print down (vertically, as rows do) on the number of pages you specified in the previous step. Then the components print across (horizontally, as columns do) on the number of pages you specified in the previous step.

    • Across, then down: The components in the flow chart print across (horizontally, as columns do) on the number of pages you specified in the previous step. Then the components print down (vertically, as rows do) on the number of pages you specified in the previous step.

  11. Select the remaining Rule Information options:

    • Select Summary, to print a summary of the components in the flow chart.

    • Select Variable Section to print information about any variables used in the rule.

    • Select Detail Section to print detailed information about the components in the rule.

    • Select Page break before sections to create a page break between summary, variable, and detail sections. This option is selected by default.

    • Select Nested Rules to print rules contained in other rules.

  12. Select Generate PDF.

  13. A PDF file of the rule is opened in Adobe Acrobat.

  14. Click the Print icon in Adobe Acrobat.

  15. In the Print dialog, select the print options specific to the printer you are using, and click Print.

This example demonstrates how to generate an allocation or periodic entry manually from the Oracle Fusion General Ledger.

You are the General Accountant for InFusion America Inc. You have created allocation and periodic journal entry definitions for several monthly entries. You now generate these entries.

Note: Schedule allocations and periodic entries in the Journals work area for automatic generation. The accounting period automatically increments for each subsequent run if defined as a Run Time Prompt for the Allocation Rule selected.

Prior to generating the allocation and periodic entries, the following tasks must be completed:

  • The period is set to Open or Future Enterable. You post in open periods, but generation can take place in either an open or future enterable period.

  • The rules or rules sets have been defined, validated, and deployed successfully from the Calculation Manager.

  • The journal balances, which are inputs for the allocation or periodic rules, are entered and posted in the proper period.

Generating Allocations and Periodic Entries Manually

  1. From the Navigator, click the Journals link to open the Journals work area.

  2. In the task pane of the Journals page, click the Generate Allocations link to open the Submission page.

  3. Optionally select one or all of the following options:

    • Print Output

    • E-mail me the output

    • Notify me when this process ends

  4. Select a rule or rule set from the list of values.

  5. Enter the submission parameters, including Ledger, Balancing Segment Value, and Period. The application automatically sets the last day of the submission period as the Accounting Date and Calculation Effective Date.

  6. Accept the selected check box for the Post Allocations option to enable the process to post the journal entries.

    If you deselect the check box for the Post Allocations option, you must either manually post or define an AutoPost Criteria Set to post automatically.

  7. Click Submit.

    After the generation process is complete, the journal entries created by the process are available for inquiry on the Journals page.

This example distributes a cost that's recorded in one account to different cost centers, based on the headcount in each cost center. The headcount is recorded using the statistical currency, and the cost centers receiving the cost are in a parent cost center. The chart of account consists of the following segments:

  • Company

  • Line of Business

  • Account

  • Cost Center

  • Product

  • Intercompany

Create the Rule

Navigate to the Calculation Manager, which is the tool for managing allocations.

  1. Navigate to the Journals work area.

  2. Click the Tasks icon and select the Create Allocation Rules task. The task opens the Enterprise Performance Management workspace.

  3. From the Navigate menu, select Administer, Calculation Manager.

  4. Expand the Essbase application.

  5. Find the balances cube for the chart of accounts that's associated with the relevant ledger and expand it.

  6. Right-click the Rules node and select New from the menu. The New Rule window opens.

    Tip: Since the rule is going to allocate cost based on headcount, consider including headcount in the rule name.
  7. Accept the default values for the rest of the fields and click OK. The New Rule window closes and the Rule Designer opens in a new tab with the name of the rule you just entered.

Define the Point of View

Set the Point of View to default values that are fixed throughout the allocation rule. For example, if a chart of accounts has a future-use segment that's currently not used, you can use the Point of View to set a default value such as 000. Then you don't have to select a value for this segment when defining the rule.

  1. In the Rule Palette, select the Point of View object and place it between the beginning and ending components in the flow chart on the Designer area.

  2. To have users supply the accounting period when the allocation is run, use a variable. Runtime prompt variables make rules dynamic and reusable. Click in the Value field for the Accounting Period row.

  3. Click the Actions icon and select Variable. The Select Variable window opens.

  4. Select the Database category, which is the category for the specific cube. The Application category applies to all cubes.

  5. In this example, the accounting period is already defined as a variable, so select it and click OK.

  6. Click the Member Selector button. The Member Selector window opens. You can set the fixed dimensions namely, Ledger, Company, Line of Business, Product, and Intercompany segments from the Member Selector. You can also set the Currency and Currency type. You can expand the dimensions to find the values or you can search for them. Alternatively, instead of using the Member Selector, you can enter the values manually.

  7. Select Ledger from the Dimensions drop down value.

  8. Expand All Ledgers.

  9. Select the appropriate ledger.

  10. Click the Select icon to move the ledger to the Selections panel.

  11. From the Dimensions list, select the Company, the Line of Business, the Product, the Intercompany, and the Currency dimensions, and set them.

  12. Select Currency Type from the Dimensions list.

  13. Expand the Currency Type node and select Total. This selection indicates that the allocation is going to use balances in the ledger currency, including the equivalent ledger currency balances of foreign currency journals.

    Note: If you select Entered, the allocation would only use amounts where the entered currency is the currency that was selected for the Currency dimension.
  14. Click OK. The Member Selector window closes.

Fixed values have now been set for all of the segments, except the Account and Cost Center segments.

Define the Allocation Component

  1. From the Rule Palette, select the Allocation object and place it between the point of view member components in the flow chart on the Designer Area. The Allocate Wizard window opens and the Point of View tab opens.

    This Point of View is specific to the Allocation component, so if you have a rule with multiple Allocation components, you can specify a Point of View for each of them. Since this rule has only one Allocation component, and you have already defined a Point of View, skip this step.

  2. Click Next. The Source tab opens.

    The source is the revenue pool to be distributed or allocated. A source can be a referenced account balance or a user-defined amount. For this rule, the source is the communication cost. To retrieve the cost, you must provide the account combination. You already specified values for the Company, Line of Business, Product, and Intercompany segments in the Point of View, so the only source segments to specify here are Account and Cost Center.

  3. Click the Member Selector button. The Member Selector window opens.

    1. On the Dimensions list, select Account.

    2. Click the Search tab and search for the communications cost account.

    3. Select the account and click the Select icon to move the account to the Selections section.

    4. On the Dimensions list, select Cost Center.

    5. Click the Search tab and search for the cost center.

    6. Select the cost center and click the Select icon to move the cost center to the Selections section.

    7. Click OK. The Member Selector window closes.

  4. The remaining dimensions, Scenario, Balance Amount, and Amount Type, specify what balance to retrieve from the source account. On the Allocate Wizard window, the default value for the Scenario dimension is Total for Allocations, which is the sum of the actual and allocated amounts. Since the source for this rule only involves actual balances, you must change the value. Click the Member Selector button. The Member Selector window opens.

    1. On the Dimensions list, select Scenario.

    2. Expand Scenario in the Members tab.

    3. Select Actual and click the Select button to move it to the Selections section.

      Note: If you have two rules with the second rule using the allocations resulting from the first rule, use the Allocated scenario for the second rule.
    4. On the Dimensions list, select Balance Amount.

    5. Expand Balance Amount in the Members tab.

    6. Since the rule is going to allocate communications cost for the period, select Period Activity. Click the Select icon to move it to the Selections section.

    7. Click OK. The Member Selector window closes.

  5. Accept the default value for the Amount Type dimension as Period to Date.

  6. Click Next. The Allocation Range tab opens. The range is the spread of values that the source is distributed against. In this rule, the cost is allocated across cost centers.

  7. Click in the Select Value field in the Cost Center row.

  8. Click the Actions icon and select Member. The Select Member window opens.

    1. Select the appropriate parent value and click the Select icon to move it to the Selections section.

      Note: Always select a parent value because you have to allocate across a range of values.
    2. Click OK. The Member Selector window closes.

  9. Click Next. The Target tab opens.

  10. The target receives the allocated amount. Enter the account number within quotation marks in the Account row.

  11. Click Next. The Offset tab opens.

    The offset receives the offsetting debit or credit to balance the allocation that was generated. On the Offset tab, enter the account number in the Account row and the cost center in the Cost Center row, within quotation marks.

    Caution: The offset must be a child value. If you select a parent value, the allocation rule fails validation.
  12. Click Next. The Exclude tab opens.

    Note: Use the Exclude tab for partial allocations. Specifically where you want to allocate a percentage of the total source and the percentage itself can't be entered. Instead, the percentage has to be calculated based on all the members in the basis and then some members have to be excluded from the allocation target range.

    For example, a basis contains cost centers 100, 200, 300, and 400. You want to distribute the source evenly across each cost center, so each cost center should be allocated 25% of the source. But you have to exclude cost center 300 from the allocation range. In this example, you would specify cost center 300 in the Exclude tab. When the allocations are generated, 75% of the source is allocated, 25% each to cost centers 100, 200, and 400. The 25% for cost center 300 remains unallocated because cost center 300 is excluded.

  13. This particular allocation isn't excluding any values, so click Next. The Basis tab opens.

  14. On the Basis tab, for the Account dimension, enter the account number that has the headcount values.

    Note: The basis determines the ratio in which the source must be allocated to each member of the allocation range. The basis could be distributing the source evenly. Or you can select specific statistical or account balances for a particular period as the basis.

    For this allocation, the ratio is going to be calculated by dividing a cost center's headcount by the total headcount.

  15. Enter Period Activity in quotation marks for the Balance Account dimension because the total headcount for each cost center is included in one journal recorded in one period.

  16. Enter STAT in quotation marks in the Currency dimension. The values for the other dimensions are derived automatically based on the Point of View and range specified previously.

  17. Click Next. The Basis-Options tab opens.

  18. Accept the default settings and click Next. The Rounding tab opens.

  19. Specify the rounding options in case of rounding differences when the allocation is generated. Since the allocation is in US dollars, on the Rounding tab, enter 2 as the number of decimal places to use. Click Finish. The Allocate Wizard window closes.

Validate the Rule

Validation is an important and required step. Validation checks for consistency against the outline of the balances cube that it references. For example, validation checks that the offset is a child, not a parent value, and checks that entered values exist.

  1. Click the Validate icon on the toolbar. After the validation is completed, a message appears stating whether the validation was successful.

  2. Click OK.

  3. Click the Validate and Deploy icon to deploy the rule and make it available for generation in the general ledger.

  4. Click Yes to first save the rule.

  5. After the deployment is completed, a message appears stating whether the deployment was successful.

  6. Click OK.

Generate the Allocation Journal

Generate the allocation journal using the following steps:

  1. Navigate to the Journals work area.

  2. Click the Tasks icon.

  3. Select the Generate General Ledger Allocations task.

  4. In the Rule or Rule Set field, enter the name of the allocation rule. The Accounting Period prompt should appear.

  5. Select the accounting period.

  6. The Post Allocations option is selected by default.

  7. Click Submit. A confirmation message appears stating that the process was submitted.

  8. Click OK.

Review the Journal

  1. Navigate to the Journals work area

  2. Click the Tasks icon.

  3. Select the Manage Journals task.

  4. Enter the first part of the allocation rule name in the Journal field.

  5. Enter a value in the Accounting Period field.

  6. Select Allocations in the Source field.

  7. Click Search.

  8. Click the Journal link to open the journal. The cost that was allocated has a credit and the debits to the different cost centers are based on their headcount.

Now that the rule is defined, all that's needed for future accounting periods is to generate the journals.

Allocation Rule Sets

Overview of Allocation Rule Sets

You create an allocation rule set by combining allocation rules or allocation rule sets that can be generated sequentially. You add rules and rule sets to a rule set by dragging and dropping them into it.

After you create and save the rule set, you can validate and deploy it. Then you can generate it in Oracle General Ledger.

Note: Rule sets are supported in Essbase aggregate storage applications used in Oracle General Ledger in sequential mode only.

Create an Allocation Rule Set

You can create an allocation rule set from the System View. You can also create an allocation rule from the List, Custom, and Deployment views, and from within the Ruleset Designer.

Scenario

To create an allocation rule set:

  1. Navigator > General Accounting: Journals > Create Allocation Rules link.

  2. Navigate menu > Administer > Calculation Manager.

  3. Enter the rule set's name.

  4. Enter the application type: Essbase.

  5. Select an application name.

  6. Select a database.

    Note: From the System View, if you right-click RuleSets and select New, the New Ruleset dialog is populated with the application type, application, and database that you're working in.
  7. Click OK. The new rule set is displayed in the Ruleset Designer.

For information about using start and dates in rule sets, see the Data Effective Allocation Rules and Rule Sets topic in the Allocation Rules section.

Design an Allocation Rule Set

After you create a rule set in the New RuleSet dialog, the rule set is displayed in the Ruleset Designer.

Scenario

To create an allocation rule set:

  1. Navigate to the Journals work area and select Create Allocation Rules from the Tasks pane.

  2. From the Navigate menu, select Administration, then Calculation Manager.

  3. In the System View, expand the Essbase application type and the application.

  4. For Essbase: Right-click RuleSets and select New.

    Note: For Essbase applications, only one rule sets node for each application at the same level as the databases.
  5. In New RuleSet, do these tasks:

    1. Enter the rule set's name

    2. Select the Application Type as Essbase

    3. Select the Application Name.

    4. As you selected Essbase as the application type, select the Database.

    5. OK.

  6. In the Ruleset Designer, to create the rule set, from Ruleset Palette, drag existing rules and rule sets and drop them into the flow chart.

    Note: You can use the Move Up and Move Down icons on the Ruleset Designer pane to reorder the rules in the rule set. Rules in General Ledger applications are launched sequentially within a rule set, so the order of the rules is important.
  7. On Properties, enter properties for the rule set. In the Ruleset Designer, if you select a rule or rule set within the rule set you are creating; its properties are displayed on Properties instead of the new rule set's properties.

    Optionally, enter the following:

    1. The name by entering a new one of up to 50 characters. The name defaults from the New RuleSet dialog.

    2. A description of up to 255 characters for the rule set.

    3. Comments for the rule set. For example, you may want to enter a comment that describes what the allocation rule set does.

  8. On Usages tab, you view which allocation rules and rule sets use the rule, if any. You cannot edit any of the information about this tab. The following information is displayed for the allocation rules and rule sets using the allocation rule:

    1. Names

    2. Database

    3. Application Name

    4. Deployment Status

    5. Validation Status

    6. Description

    Note: By default, a rule set is used by no other rule sets when you create it.
  9. On Variables, select Merge Variables to merge all instances of the same variable used in the rules within this rule set so only the first instance of each variable is displayed when the rule is launched. If you do not select this check box, all instances of each variable are displayed.

    Note: If you select Merge Variables, the first value that the user enters for the runtime prompt is used for all subsequent occurrences of that runtime prompt during validation and launch.
  10. Select File, Save.

Create and Deploy an Allocation Rule Set

This example demonstrates how to create an allocation rule set.

You are the General Accountant for InFusion America Inc. You are tasked with creating an allocation rule set.

You create rule sets by combining two or more related rules (or rule sets) so you can launch the rules or rule sets sequentially.

Creating an Allocation Rule Set

  1. Click the Navigator.

  2. Click the Journals link for the General Accounting work area to access the Journals work area.

  3. Click the Create Allocation Rules link.

  4. In the Enterprise Performance Management System Workspace, click the Navigate menu.

  5. Select Administer and then Calculation Manager.

  6. On the System View tab of Calculation Manager, expand the Essbase tree.

  7. Expand the VF_USA_Accounting_Flexfield tree item.

  8. Right-click the Rules tree node and select New.

  9. In the New Rule Set dialog box, enter EMEA Overhead Distribution, and click OK.

  10. Expand the VF_USA_Accounting_Flexfie tree in the Rule Set Palette, then expand the db tree node and then the Rules tree node.

  11. Drag EMEA Overhead Distribution from the Rule Set Palette to the Ruleset Designer panel.

  12. Drag EMEA - Allocation of Indirect Costs from the Rule Set Palette to the Ruleset Designer panel.

  13. Click EMEA Overhead Distribution Rule Set in the Ruleset Designer.

  14. Click the Variables tab in the lower panel of the work area.

  15. Select Merge Variables.

    If a rule set has the same variable used across rules in a rule set, you can merge the rules. Then at generation time, the input is taken from that variable as the runtime prompt.

  16. Click Save and then OK.

    Before you deploy rule sets, you validate them to ensure that there are no syntax errors. Validation ensures that all of the following criteria are met:

    • All members of all dimensions in the application are valid.

    • All functions exist, have the correct number of parameters, and are valid for the application type.

    • All variable references that are used in rules are valid. Replacement variables are replaced with the correct strings and then validated.

    • The generated script contains no syntax errors.

    You can deploy rules and rule sets to Oracle Fusion General Ledger. You execute a partial deployment by deploying one or more (but not all) rules and rule sets. You execute a full deployment by deploying all rules and rule sets in the current application.

    Rules and rule sets that are deployed can be generated from the Allocation Generation page.

    • To deploy multiple rules and rule sets but not all, in the Deployment View, select the rules and rule sets that you want to deploy.

    • To deploy only one rule or rule set in the current application, in the Deployment View, select the one rule or rule set option.

Add an Allocation Rule to an Allocation Rule Set

You can add an allocation rule to an allocation rule set that belongs to the same application type. The rules in the rule set can be launched sequentially or simultaneously.

Scenario

To add an allocation rule to an allocation rule set:

  1. In the System View, expand the Essbase Application Type and the Application.

  2. Expand RuleSets, right-click the rule set you want to open, and select Open.

    Note: Only one rule set node exists for each application at the same level as the plan types and databases.
  3. In the Ruleset Designer, in Existing Objects, expand the application and the plan type or calculation type that contains the rule you want to add.

  4. To add the rule, drag and drop it into the Ruleset Designer.

  5. Repeat step 4 for each rule you want to add to the rule set.

  6. Select File, Save.

Edit an Allocation Rule Set

You can edit the following properties of an allocation rule set:

  • Allocation rule components

  • Allocation rule name

  • Allocation rule description

  • Allocation rule comments

Scenario

To edit an allocation rule set:

  1. Navigator > General Accounting > Journals > Create Allocation Rules task.

  2. Navigate menu > Administration > Calculation Manager.

  3. In the System View tab, expand the General Ledger balances cube and then expand the Rule Sets node.

  4. Right-click the rule set you want to edit and select Open.

    Note: Only one rule set node exists for each application at the same level as the plan types and databases.
  5. In the Ruleset Designer pane, add, copy, delete, and change the order of new rules and rule sets:

    1. To delete a rule or rule set, select it, right-click, and select Remove.

    2. To add a rule or rule set, drag them from the Existing Objects pane and drop them into the Ruleset Designer.

      Note: The rules and rule sets you add to the rule set must belong to the same application type as the rule set you're editing.
    3. To open a rule or rule set, select it, right-click, and select Open.

    4. To reorder the rules and rule sets within the rule set, right-click them in the Ruleset Designer pane and select Move Up or Move Down.

  6. On the Properties tab, edit properties of the rule set. (In the Ruleset Designer, if you select a rule that you added to this rule set, the properties are displayed on the Properties tab.)

  7. Optional: Edit the name by entering a new one of up to 50 characters. The name defaults from the New Rule Set dialog.

  8. Optional: Edit the description by entering a new one of up to 255 characters.

  9. Edit the comments.

  10. On the Usages tab, view which allocation rules and rule sets use the rule, if any. You can't edit any of the information that appears on this tab. The following information displays for the allocation rules and rule sets that use the rule:

    1. Names

    2. Calculation or Plan Type

    3. Application Name

    4. Deployment Status

    5. Validation Status

    6. Description

  11. Select File, Save.

Copy an Allocation Rule Set to Another Application

From the System View, you can copy an allocation rule set to another application of the same application type (Essbase) or database.

Note: Allocation rule sets are not supported in Essbase Aggregate Storage or Block Storage applications, other than Aggregate Storage applications used in Oracle General Ledger.

Scenario

Use the following steps to copy a rule set to another application:

  1. In the System View, expand the Essbase Application Type and the Application.

  2. Expand RuleSets.

    Note: Only one rule set node exists for each application at the same level as the plan types and databases.
  3. Right-click the allocation rule set you want to copy, and select Copy To.

    Note: You can also copy an allocation rule set when you are working with it in the Ruleset Designer, and paste it into another allocation rule set or allocation rule.
  4. Select the rule set name, select Edit, Copy, open the rule or rule set into which you want to copy it, and select Edit, Paste.

  5. In Save As, enter a new name for the allocation rule set, or accept the default name, and select an application and calculation or plan type. Click OK.

    Note: You cannot copy the allocation rule set to more than one application and calculation or plan type.

The new allocation rule set is added to the application and calculation or plan type you selected. To see it in the System View, you must refresh the application list. To refresh the application list, click the Refresh icon on the toolbar.

Save an Allocation Rule Set

You must save an allocation rule set after you create or edit it. When you save the allocation rule set, it is saved to the application and application type for which you created it. After you save it, you can deploy, validate, and generate it. You can deploy and validate it in Calculation Manager; you can generate it from Oracle General Ledger.

Scenario

To save an allocation rule set after you create or edit it, select File, Save, or click the Save icon.

Note: To see the allocation rule set within the System View after you save it, you must refresh the application list. To do this, right-click the application type, the application, the database (Essbase), and select Refresh. You can also click the Refresh icon on the toolbar to refresh the application list in the System View.

Save an Allocation Rule Set with a Different Name

You can save an allocation rule set with a different name using Save As. Saving it with a different name creates a copy of the rule set.

Scenario

  1. In the System View, expand the Essbase Application Type and the Application.

  2. Expand RuleSets.

    Note: For Essbase applications, only one rule set node exists for each application at the same level as the plan types and databases.
  3. Right-click the rule set you want to save with a different name, and select Open.

  4. In the Ruleset Designer, select File, Save As.

  5. In Save As, enter the rule set's new name, and select an application. Click OK.

    Note: You cannot change the application type of a rule set you save with a different name. The new rule set must have the same application type as the rule set from which the rule set is created.

    The new rule set is added to the application list in the System View.

Delete an Allocation Rule Set

You delete an allocation rule set from the System View. You can delete an allocation rule set only if it is not being used by other allocation rule sets. To see if it is being used by other rule sets, you can show its usages. If it is being used, you must remove it from the allocation rule sets that are using it, or make copies of it for the allocation rule sets that are using it, before you delete it.

Scenario

  1. In the System View, expand the Essbase Application Type and the Application.

  2. Expand RuleSets.

  3. To make sure the rule set is not being used by another rule set, right-click it, and select Show Usages.

  4. Right-click the rule set you want to delete, and select Delete.

  5. Click OK to confirm deletion of the rule set.

Refresh Allocation Rules or Rule Sets

In the System View, you can refresh any level of the application list. You can refresh:

  • Application Type

  • Application

  • Database

  • One or Multiple Rule Sets or Rules

By default, when you refresh an application, application type, or database, all of the rules, rule sets, components, and templates belonging to it are refreshed.

However, refreshing the rule sets or rules within an application does not refresh higher levels in the application list or rule sets or rules that belong to other applications.

Note: You can also click the Refresh icon on the toolbar to refresh the entire application list in the System View.

Scenario

  1. In the System View, expand the Essbase Application Type and the Application.

  2. To refresh rule sets, right-click RuleSets, and select Refresh or to refresh rules, expand the database, right-click Rules, and select Refresh.

    Note: You can also right-click the application type, the application, or database that contains the allocation rules you want to refresh, and select Refresh.

Show Usage of an Allocation Rule or Rule Set

You can display the allocation rules and rule sets that are using a rule or allocation rule set. Viewing the usages of rules or rule sets is useful when deleting rules or rule sets and you must know what objects are using it.

Scenario

  1. In the System View, expand the Essbase Application Type and the Application.

  2. To show the usages of a rule set, expand RuleSets.

  3. Right-click the rule set whose usages you want to see.

  4. Select Show Usages or to show the usages of a rule, expand the database, and Rules.

  5. Right-click the rule whose usages you want to see, and select Show Usages.

  6. You can view this information about the rule or allocation rule set:

    1. Names

    2. Database

    3. Application Name

    4. Deployment Status

    5. Validation Status

    6. Description

      Note: You can also view a rule or rule set's usages from within the Rule or Ruleset Designer on the Usages tab.
  7. After you review the information, click OK.

Change Owner of an Allocation Rule or Rule Set

You can change the owner of an object such as a rule, rule set, or formula in the System View. The application to which it belongs must be deployed. By default, an object's owner is the user that creates it, unless the user changes the ownership. Users can edit only objects they own, with the exception of administrators who can edit any objects.

Scenario

  1. In the System View, expand the Essbase Application Type and the Application.

  2. To change the ownership of a rule set, expand RuleSets or to change the ownership of a rule, expand the database, and then expand Rules.

  3. Right-click the object, and select Change Ownership.

  4. In Change Owner, select the owner to whom you want to transfer ownership of the object.

  5. Click OK.

    Note: The user you assigned ownership to can edit the object.

Allocation Components

Overview of Point of View Components

Every data value in a report is derived from the intersection of a member from each dimension in the Essbase database connection. Financial Reporting enables a designer to place these dimensions on the report grid or user point of view. Report viewers can change the member selected for dimensions on the user point of view. This enables report viewers to configure the reports to fit their needs. The user point of view can also be used in books.

You create and edit point of view components from within a rule to set members, variables, and functions that contain the global range of the point of view component. You can nest a point of view component within another point of view component.

Allocation components contain calculations for distributing data from members at one level in the database outline to other members in the outline. Formula components contain calculation statements that you design using members, functions, and variables.

Create a Point of View Component

You create a Point of View component from within a rule to set members, variables, and functions that contain the global range of that Point of View component.

You can also define or edit the caption that displays in the flow chart and the comments that are entered for the values selected for each of the dimensions in the Point of View.

Scenario

To create a Point of View component:

  1. Navigator > General Accounting: Journals > Create Allocation Rules link.

  2. Navigate menu > Administration > Calculation Manager.

  3. In the System View, select File menu, New, Rule. Expand the Essbase Application Type, the Application, and the Calculation Type, Plan Type, or Database and Rules.

  4. Right-click rules you want to open, and select Open. The rule is displayed in the Rule Designer.

  5. After you determine where in the rule's flow chart you want to create the Point of View component, from the New Objects Palette, drag the Point of View component and drop it into that location in the flow chart.

  6. On the Point of View tab, enter a caption to identify the Point of View component. The caption is displayed in the flow chart of any rule that uses it.

  7. Optional: Perform one of these tasks to define the Point of View global range:

    1. Click Variable Selector to select or create variables to define the Point of View. If you select a variable, you can select Link Variable Dynamically to ensure the variable is updated dynamically when changes are made to it.

    2. Click Member Selector to select members to define the Point of View.

    3. Click in the row of a dimension in the Value column to type the names of members that define the Point of View.

    4. Click in the row of a dimension, click the Actions icon, and select one of these options to enter members:

      • Members

      • Variables: You can use a variable to fill the Point of View component. The variable must be defined at the database level and must be of the Member Range type.

      • Functions: The functions you enter should return level 0 members only and should include the at sign @ before the function name. You can enter these functions:

        • @Level0Descendant

        • @Sibling

        • @UDA

        • @Attribute

          Note: The Level0Descendant and Sibling functions require a member name as a parameter.
    Note: If a global range is defined for the rule for which you are creating the Point of View component, the Point of View tab displays the rule's member selections by default. To see if a global range is defined for the rule, select the Begin or End tab in the flow chart. Then click the Global Range tab to see if any members, functions, or variables are defined.
  8. To enter a comment for the members you select for a dimension, click Comment.

  9. Click Reset Grid to clear any entries you made to the grid.

  10. Select File, Save.

Edit a Point of View Component

You can edit the members, variables, and functions that contain the global range of the Point of View component. You can also edit the caption that displays in a flow chart and the comments that are entered for the values selected for each of the dimensions in the Point of View.

Scenario

To edit a Point of View component:

  1. Navigator > General Accounting: Journals > Create Allocation Rules link.

  2. Navigate menu > Administration > Calculation Manager.

  3. In the System View, select File menu, New, Rule. Expand the Essbase Application Type, the Application, and the Calculation Type, Plan Type, or Database.

  4. Right-click the rule, and select Open.

  5. In the Rule Designer, select the Point of View component you want to edit in the flow chart to display its properties. You can edit any of these properties of a Point of View component.

    1. The caption displays in the rule's flow chart.

    2. The members, variables, and functions that define the Point of View.

    3. Whether any variables used in the Point of View component are updated dynamically when changes are made to the variables.

    4. Whether comments are entered for the dimensions and members that define the global range of the Point of View.

    5. Whether the values of the members in the Point of View component are calculated when the rule to which it belongs is validated or launched.

  6. Select File, Save.

Create an Allocation Component

You create an allocation component from within a rule; it exists only in that rule and can't be shared among allocation rules.

Scenario

To create an allocation component:

  1. Navigator > General Accounting: Journals > Create Allocation Rules link.

  2. Navigate menu > Administration > Calculation Manager.

  3. In the System View, select File menu, New, Rule. Expand the Essbase Application Type, the Application, and the Calculation Type, Plan Type, or Database.

  4. Right-click the rule you want to open, and select Open. The rule is displayed in the Rule Designer.

  5. After you determine where in the rule's flow chart you want to create the allocation component, from the New Objects Palette, drag the Allocation component and drop it into that location in the flow chart.

  6. In the Calculation Manager, on the Point of View tab, for each dimension listed that you don't want to vary during the allocation, do one of these tasks, and then click Next.

    1. Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values.

    2. Click the Member Selector icon to select members and variables for each of the dimensions listed. Make sure that all members you select are valid level 0 members.

    3. Select a dimension in the list, and click Actions to select a member or variable.

      Note: If you drop a Point of View component within another Point of View component, the second Point of View inherits the members, variables, and functions from the first Point of View.

      In the Member Selector, the dimensions listed in the current step are available for selection from Dimension. This enables you to select members and functions for any of the dimensions listed in the current step.

  7. In the Calculation Manager, on the Source for each dimension listed, select a member whose data you want to allocate by doing one of these tasks. You must select a member for each dimension listed. The source members can be members that aren't level 0.

    1. Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values. If the predefined selection doesn't enter a value for each dimension listed, you must enter a value for any dimensions that are empty.

    2. Click the Member Selector icon to select a member for each of the dimensions listed.

    3. Select a dimension in the list, and click Actions to select a member or variable. You can't use functions in this step of the Allocation component.

    4. Optional, to allocate a specific value, enter an amount to be allocated instead of the selecting members.

  8. If the source amount you want to allocate is zero, select one of these options from the drop-down list.

    1. Select the next pool record.

    2. Stop processing the allocation.

  9. Click Next.

  10. On Allocation Range, enter the parent member for the dimensions you want to use for the allocation. To enter the parent member, do one of these tasks, and then click Next.

    1. Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values.

    2. Click the Member Selector icon to select the parent member for the dimension to which to allocate the data.

    3. Enter a parent member, or select a dimension in the list. Click the Actions icon to select the parent member (of the main dimension) to which to allocate the data. The data is allocated to the level 0 member (the lowest member in the outline).

  11. On Target, for the remaining dimensions, select a level 0 member to which to allocate the data. Perform one of these tasks and click Next.

    1. Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values.

    2. Click the Member Selector icon to select members for each of the dimensions listed.

    3. Select a dimension in the list, and click the Actions icon to select a member or variable.

  12. On Offset, perform one of these tasks and click Next:

    1. Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values.

    2. Click the Member Selector icon to select members for each of the dimensions listed.

    3. Select a dimension in the list, and click the Actions icon to select a member or variable.

      Note: You must specify members for the offset; you can't leave it empty.
  13. Optional: On Exclude, select any members you want to exclude from the allocation. Perform one of these tasks and click Next.

    Note: Use the Exclude tab for partial allocations. Specifically where you want to allocate a percentage of the total source and the percentage itself can't be entered. Instead, the percentage has to be calculated based on all the members in the basis and then some members have to be excluded from the allocation target range.

    For example, a basis contains cost centers 100, 200, 300, and 400. You want to distribute the source evenly across each cost center, so each cost center should be allocated 25% of the source. But you have to exclude cost center 300 from the allocation range. In this example, you would specify cost center 300 in the Exclude tab. When the allocations are generated, 75% of the source is allocated, 25% each to cost centers 100, 200, and 400. The 25% for cost center 300 remains unallocated because cost center 300 is excluded.

    1. Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values.

    2. Click the Member Selector icon to select members for each of the dimensions listed.

    3. Select a dimension in the list, and click the Actions icon to select a member or variable.

  14. On Basis perform these tasks:

    1. Select an allocation method to specify how the data should be allocated.

      1. Select Allocate evenly to allocate data values in the allocation range evenly. Then on Basis Options for evenly method, specify what you want to be done if the basis is negative, zero, has missing values, or if all members are excluded.

      2. Select Allocate using a basis to calculate a percentage to be applied to each member in the allocation range. Then on Basis Options, specify what you want to be done if the basis is negative or equal to zero.

    2. Any dimension members you don't specify are inherited from the Point of View you defined previously, but you can override those Point of View selections by doing one of these tasks:

      1. Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values.

      2. Click the Member Selector icon to select a member for each of the dimensions listed.

      3. Select a dimension in the list, and click the Actions icon to select a member or variable.

  15. Click Next.

  16. On Rounding, complete these steps. The members you select in this step must be a part of the allocation range.

    1. Enter the number of decimal places to use for this allocation, or click the Actions icon to select a member or variable that represents this value.

    2. Select where to place the rounding difference.

      1. Select Define location to specify a member or members on which to place the rounding difference. Perform the following steps.

        1. Select a predefined selection from Use Predefined Selection to populate the dimensions listed with values.

        2. Click the Member Selector icon to select a member for each of the dimensions listed.

        3. Select a dimension in the list, and click the Actions icon to select a member or variable.

      2. Select Use biggest value to round data values to their largest values.

      3. Select Use smallest value to round data values to their smallest values.

      4. Select Discard rounding error to use allocated data values as is.

  17. Click Finish.

Edit an Allocation Component

You can edit an allocation component by opening the rule to which it belongs. When the rule is displayed in the Rule Designer, you can view the allocation component's properties by selecting it in the rule's flow chart.

Scenario

To edit an allocation component:

  1. Navigator > General Accounting: Journals > Create Allocation Rules link.

  2. Navigate menu > Administration > Calculation Manager.

  3. In the System View, select File menu, New, Rule. Expand the Essbase Application Type, the Application, and the Calculation Type, Plan Type, or Database and Rules.

  4. Select the rule that contains the allocation component you want to edit.

  5. Right-click the rule, and select Open.

  6. In the Rule Designer, select the allocation component you want to edit in the flow chart to display its properties. You can edit any of these properties of an allocation component.

    1. The member whose data you want to allocate.

    2. The level 0 members to which you want to allocate data.

    3. The data and the amount of the data you want to allocate.

    4. How you want the data processed:

      • The total amount of the data allocated written to an offset member.

      • The data allocated evenly or in different amounts using a driver.

      • The allocated data rounded, and if so, how it should be rounded.

  7. Select File, Save.

Remove Members and Functions from an Allocation Component

You can remove members from formula, script, condition, and member and data range components. Similarly, you can remove functions from formula, script, and condition components.

When you remove members and functions from a component, they are not deleted from the database. To remove members and functions from a shared component, you must first ensure that the component is not shared.

Remove Members or Functions from a Component

To remove members or functions from a component:

  1. In the System View, expand the application type, the application, the calculation type or the database (Essbase).

  2. Expand Rules or Templates, depending on whether the component is in a rule or template.

  3. Right-click the rule or template that contains the component you want to add a member to, and select Open.

  4. When the rule or template opens, in its flow chart, select the component that contains the member or function you want to remove.

  5. Click the Actions icon, and select Member.

  6. From Dimensions > Member Selector, select the dimension that contains the member or function you want to remove.

  7. Click the Deselect icon to move the member or function from the Selections panel to the Members or Functions panel.

  8. To remove members from multiple dimensions, click Next, and repeat steps 5 and 6.

  9. Click OK.

  10. Select File > Save.

Create a Formula Component

You can create a formula component from the System View or from within the Rule Designer. A formula component exists as an independent object in the database and can be shared among the allocation rules.

Scenario

To create a formula component for an Essbase application:

  1. In the System View, expand the Essbase Application Type, the Application, and Database.

  2. Right-click Formulas, and select New.

  3. Enter the formula name.

  4. Enter the Application Type (Essbase).

  5. Select an Application Name. The application name must be a valid Essbase application.

  6. Select the Essbase Database.

  7. Click OK. The formula is displayed in the Component Designer.

  8. In the Component Designer, select Properties, and complete the following steps:

    • Optional: By default a formula is shared when you create it, you cannot select or clear the Shared check box.

      Note: To create a formula that is not shared, open an allocation rule, and then drag a new formula component into the allocation rules flow chart. The shared check box is not selected. If you want to make the formula shared, select the Shared check box.
    • Optional: Edit the formula's name by entering a new one of up to 50 characters. (The name defaults from the New Formula dialog).

      Note: Names of members in Essbase aggregate storage applications need not be unique. If there is a name that is not unique, it is flagged when the object in which the member is used is validated. If this occurs, you must enter the full path for the member. The full path syntax is [Dimension name]. [Parent name]. [Member name.]
    • Optional: Enter a description of up to 255 characters for the formula.

    • Optional: Enter a caption for the formula. The caption is displayed in the Rule Designer flow chart.

      Note: If you do not enter a caption, the component's name is displayed in the flow chart.
    • Optional: Enter comments for the formula. For example, you may want to tell users how the formula component should be used.

  9. On Formula, enter a caption for the formula.

  10. Optional: From Offset Member, if you want the total amount of all of the formulas in the formula component to be written to an offset member, or a cross dimension member, click the Ellipsis icon to select a member.

    Note: You can define an offset member manually within the formulas you create. The offset defined in the formula component is calculated as the sum of all calculated amounts.
  11. To create a formula statement, click in the first formula statement row before the equal sign. Then enter a member or cross dimension member selection, or click Actions to select a:

    • Variable

    • Member

  12. To complete the formula statement, click in the row after the equal sign. Then enter a member or cross dimension member selection, or click Actions to select a:

    • Variable

    • Member

  13. Optional: For each formula statement row, click the Comments icon to enter comments about the formula statement. Click OK.

  14. On the Usages tab, you can view the rules that use the formula component.

    Note: The formation on this tab cannot be edited.
  15. Select File and Save.

Open a Formula Component

You can open a formula component from System View or from within the Rule Designer flow chart of a rule that uses the formula component.

Scenario

To open a formula component:

  1. In the System View, expand the Essbase Application Type, the Essbase Application, and Database.

  2. Expand Formulas and do one of the following tasks:

    • Right-click the formula you want to open, and select Open.

    • Double-click the formula you want to open.

      Note: Open a rule with formula component from within the rule's flow chart by right-clicking the formula component and selecting Open, or by double-clicking the component.

Copy and Paste a Formula Component

You can copy a formula component from a rule and paste it into the same or a different rule. You can also copy the contents of the grid within a formula component and paste the contents into the same or a different formula component. You cannot copy a formula component and paste it into another formula component or another component type.

Scenario

To copy and paste a formula component:

  1. In the System View, expand the Essbase Application Type, the Essbase Application, Database, and Rules.

  2. Right-click the rule that contains the formula component you want to copy, and select Open.

  3. In the Rule Designer flow chart, right-click the formula component you want to copy, and select Copy.

    Note: If the component you want to copy is shared, you can use Edit and Copy Reference to copy the reference to the shared component instead of copying the component itself. (See "Copying and Pasting the Reference to a rule Formula or Script Component").
  4. Do one of the following tasks:

    • If you want to paste the formula component into the same rule flow chart, right-click in the location of the flow chart, and select Paste.

    • If you want to paste the formula component into a different rule flow chart, open the rule into which you want to paste the component, right-click in the location, and select Paste.

  5. Select File and Save.

Delete a Formula Component

You can delete a formula component only if it is not used in any allocation rules. Use the show the formula component's usages to see if any allocation rules are using the formula component,

Scenario

Select one of the following:

  • If a formula component is used by a rule and you no longer need the formula component in that rule, then:

    • Remove it from the rule.

    • Delete the formula component.

  • If the formula component is used in a rule, and you no longer need the rule, then you can delete the rule.

  • If no allocation rules use the formula component, you can delete the component.

To delete a formula component:

  1. In the System View, expand the Essbase Application Type, the Essbase Application, Database, and Formulas.

  2. Right-click the formula you want to delete, and select Show Usages to make sure no allocation rules are using the formula component.

  3. Remove the formula component from any allocation rules that are using it.

  4. In the System View, right-click the formula you want to delete, and select Delete.

  5. Confirm to delete the formula.

Edit a Formula Component

You can edit the formula statements that contain a formula component and the formula component's comments, caption, name, and description.

Scenario

To edit a formula component:

  1. In the System View, expand the Essbase Application Type, the Essbase Application, Database, and Formulas.

  2. Select the formula component you want to edit.

  3. Right-click the formula component, and select Open.

  4. In the Component Designer, you can edit any of the following properties of a formula component:

    • The caption

    • The formula statements

    • The name

    • The description

    • The comments

  5. Select File and Save.

Searching for Members

You can search for members within the Member Selector.

Searching for Members

To search for members:

  1. In the System View tab, expand the Essbase application type.

  2. Expand the application, the calculation type (Financial Management), the plan type (Planning), or the database (Essbase).

  3. Expand Rules or Templates, depending on whether the component is in a rule or template.

  4. Right-click the rule or template that contains the component for which you want to search for members, and select Open.

  5. When the rule or template opens, in its flow chart, select the component for which you want to search for members.

  6. Click the Actions icon, and select Member

  7. In Member Selector window, select the dimension that contains the member for which you want to search.

  8. Optional: From the Menu icon you can change the display of members in the Member Selector window by performing these tasks:

    • Select or clear the options in Show to display or hide the member's name, alias, description, and count. (By default, the name and alias of the member is displayed.)

    • Select Collapse All to hide the members in the dimension you selected. (By default, the outline is collapsed when you select a dimension.)

  9. Select the Search tab.

    1. From the Find field, select a type of member to search for, a member name or its description.

    2. Enter the name of the member, or its description, to search for, or to display all members in the dimension, accept the default wildcard.

    3. Click Search.

      If the member is found, the member is selected in the Results section. If more than one member matches your search criteria, locate the appropriate members from the list.

    4. Optional: Click Advanced Search to search for the member by name, alias, or one of its properties.

    5. Select the member or members, and click the Select icon to move them to the Selections panel.

  10. Click OK.

Search for Members by Name, Alias, or Property

You can use Advanced Search within the Member Selector to search for a member by name, alias, or one of its properties.

Searching for Members by Name, Alias, or Property

To search for a member by name, alias, or property:

  1. From the Member Selector, select the Search tab, and click Advanced Search.

  2. In Find Members > Search By, select one of these options:

    • Name: To search for the member by its name. Then move to step 4.

    • Alias: To search for the member by its alias. Then move to step 4.

    • Property: To search for the member by one of its properties. Then move to step 3.

  3. If you selected Property, enter or select a Property Name.

  4. Enter a value for the name, alias, or property.

  5. Click OK. If the alias, name or property is found, the field is selected in the outline on Members.

    When you search for members by alias, all members that have aliases matching the search criteria are highlighted in the outline, even members with aliases in other languages are highlighted. However, only aliases for members in the language being used are displayed in the Member Selector.

  6. Optional: If more than one member matches your search criteria, locate the appropriate members from the list.

Work with Allocation Formula Components

An allocation formula component is composed of formula calculation statements. These examples show performing the following actions on formula components:

  • Creating

  • Opening

  • Editing

  • Deleting

  • Copying and pasting

  • Showing usages

Creating Formula Components

To create the calculation statements of a formula, you enter or select members and variables. As you create the formula, each of its calculation statements is listed in a row within a grid in the Component Designer. You can create a formula component from the System View or from within the Rule Designer. A formula component exists as an independent object in the database, so it can be shared among allocation rules.

  1. From the System View, expand the Essbase Application Type, the Aggregate Storage Application, and the Database.

  2. Right-click Formulas, and select New.

  3. Enter the formula's Name.

  4. Enter the Application Type (Essbase).

  5. Select an Application Name such as Vision Chart of Accounts. The application name must be a valid Essbase aggregate storage application.

  6. Select the Essbase Database.

    Note: Right-click Formulas, and select New to create a new formula, the New Formula dialog. The dialog is populated with the application type, the application, and the database you are working in within the System View.
  7. Click OK. The formula is displayed in the Component Designer.

  8. In the Component Designer, on Properties tab, optionally complete these steps:

    1. Verify that the Shared check box is selected by default.

      Note: You cannot select or clear the Shared check box. To create a formula that is not shared, open an allocation rule, and then drag a new formula component into the allocation rule's flow chart. The shared check box is not selected. If you decide to make the formula shared, select the Shared check box.
    2. Edit the formula's name by entering a new one of up to 50 characters. The name defaults from the New Formula dialog.

      Note: Names of members in Essbase aggregate storage applications can be the same. If there is a name that is not unique, the name is marked when the object is validated. If this occurs, you must enter the full path for the member. The full path syntax is [Dimension name]. [Parent name]. [Member name.]
    3. Enter a description of up to 255 characters for the formula.

    4. Enter a caption for the formula. The caption is displayed in the Rule Designer flow chart. If you do not enter a caption, the component's name is displayed in the flow chart.

    5. Enter comments for the formula. For example, you may want to tell users how the formula component should be used.

  9. On Formula, enter a caption for the formula.

  10. The Offset Member is the total amount of all of the formulas in the formula component. Click the Ellipsis icon to select a member.

    Note: You can define an offset member manually within the formulas that you create. The offset defined in the formula component is calculated as the sum of all calculated amounts.
  11. To create a formula statement, click in the first formula statement row before the equal sign. Then enter a member or cross dimension member selection, or click Actions to select:

    • A variable

    • One or more members

  12. To complete the formula statement, click in the row after the equal sign. Then enter a member or cross dimension member selection, or click Actions to select a variable or member.

  13. For each formula statement row, click the Comments icon to enter optional comments about the formula statement.

  14. On Usages, you can view the rules that use the formula component.

  15. Select File > Save.

Opening Formula Components

You can open a formula component from the System View or within the Rule Designer flow chart of a rule that uses the formula component.

  1. From the System View, expand the Essbase Application Type, the Aggregate Storage Application, and the Database.

  2. Expand Formulas.

    • Right-click the formula you want to open, and select Open.

    • Double-click the formula you want to open.

    Note: The formula component opens in the Component Designer. To open a formula component within a rule, open it from within the rule's flow chart by right-clicking the formula component. Select Open or double-click the component.

Editing Formula Components

You can edit the formula statements that contain a formula component and the formula component's comments, caption, name, and description.

  1. From the System View, expand the Essbase Application Type, the Aggregate Storage Application, and the Database and the Formulas.

  2. Select the formula component you want to edit.

  3. Right-click the formula component, and select Open.

  4. In the Component Designer, you can edit any of these properties of a formula component:

    • Caption

    • Formula statements

    • Name

    • Description

    • Comments

  5. Select File, Save.

Deleting Formula Components

You can delete a formula component only if the component is not being used in any allocation rules. To see if any allocation rules are using the formula component, you can show the formula component's usages.

If the formula component is being used by a rule, and you don't want the formula component, remove it from the rule, then delete it. If the formula component is being used in a rule, and you no longer need the rule, you can delete the rule. If no allocation rules use the formula component, you can delete the component.

To delete a formula component:

  1. In the System View, expand the Essbase application type, the Essbase aggregate storage application, the database, and Formulas.

  2. Right-click the formula you want to delete, and select Show Usages to make sure no allocation rules are using the formula component.

  3. Remove the formula component from any allocation rules that are using it.

  4. In the System View, right-click the formula you want to delete, and select Delete.

  5. Confirm deletion of the formula.

Copying and Pasting Formula Components

You can copy a formula component from a rule and paste it into the same, or a different, rule. You can also copy the contents of the grid within a formula component and paste the contents into the same, or a different, formula component. You cannot copy a formula component and paste it into another formula component or another component type.

To copy and paste a formula component:

  1. In the System View, expand the Essbase application type, the Essbase aggregate storage application, the database, and Rules.

  2. Right-click the rule that contains the formula component you want to copy, and select Open.

  3. In the Rule Designer flow chart, right-click the formula component you want to copy, and select Copy.

  4. Do one of these tasks:

    • To paste the formula component into the same rule flow chart, right-click in the location of the flow chart, and select Paste.

    • To paste the formula component into a different rule flow chart, open the rule where you want to paste the component. Then right-click in the location, and select Paste.

  5. Select File, Save.

Showing a Formula Component's Usages

You can see which allocation rules are using a formula component, and other information, by displaying the formula component's usages from the System View.

To show a formula component's usages:

  1. In the System View, expand the Essbase application type, the Essbase aggregate storage application, the database, and Formulas.

  2. Right-click the formula whose usages you want to see, and select Show Usages.

  3. You can view this information about the formula component:

    • The names of the allocation rules that are using the formula component.

    • The application names of the allocation rules that are using the formula component.

    • The database names of the allocation rules that are using the formula component.

    • The owner of the formula component.

    • Whether the allocation rules that are using the formula component are deployed.

    • Whether the allocation rules that are using the formula component are validated.

    • A description of the allocation rules that are using the formula component.

Note: You can also view a formula component's usages from within the Component Designer on the Usages tab.

Allocation Variables

Overview of Allocation Variables

Variables assume values that you define for them. You can use them in components while designing allocation rules and templates.

You can create variables from the System View and from within the Component Designer by starting the Variable Designer. When you create a variable within the Component Designer, the variable is associated with the rule that contains the component. You can also create variables from the System View, and associate them with allocation rules, calculation or plan types, databases, or applications that you select.

Two types of variables exist.

  • Execution: When the rule is started, the calculation defined for the variable is performed. You can use execution variables in formula, condition, or loop components.

    Note: Execution variables are not supported in Essbase aggregate storage applications, including those used in Oracle General Ledger.
  • Replacement: When you are designing or creating the rule, the variable is substituted with a calculation. You can use replacement variables in formula components.

    You can create several types of execution and replacement variables.

    Note: The variables you can create differ depending on what application type you are working in and whether you are creating an execution or replacement variable.

You can create variables that prompt users to enter information when they start a rule. These runtime prompt variables prompt users for information regarding members, text, dates, or numbers. The prompts indicate the type of data that is expected.

Up to four database objects with which you can associate a variable exist, depending on which application type you are creating a variable for. A variable can exist in multiple objects simultaneously and can have the same name in each object.

  • For all user use Application. If you select application, the variable can be used within the application with which you are working when you create the variable.

  • For Essbase users use Database. If you select database, the variable can be used within the database you are working when you create the variable.

  • For Essbase users use Rule: If you select rule, the variable can be used within the rule with which you are working when you create the variable.

Create a Variable from the System View

You can create a variable from the System View or from within the Component Designer by running the Variable Designer.

Creating a Variable from the System View

You can create a variable from the System View or from within the Component Designer by running the Variable Designer.

To create a variable from the System View:

  1. In the System View, select Tools > Variables.

  2. In the Variable Navigator, expand the Essbase application type.

  3. Essbase users: Right-click an application, and select New to create a variable that can be used in that application only.

  4. Enter a description for the variable.

  5. If you include this variable in a group, enter the group name.

  6. If the variable is a runtime prompt variable, select Use Last Entered Value. The prompt the user last entered is displayed as the default value the next time the prompt occurs.

    This option can be selected only if the variable has runtime prompts.

  7. In the Value table, enter values for the variable. The values you enter change depending on the selected variable type.

    Repeat these steps for each variable you want to create.

  8. Select File, Save.

Enter Variable Values for a Numeric Variable

A numeric variable can be Essbase replacement variable.

Entering Values for a Planning or Essbase Numeric Variable

To enter values for an Essbase numeric variable:

  1. In the System View, select Tools, Variables.

  2. In the Variable Navigator, expand the Essbase application type.

  3. Do one of these tasks:

    • Right-click an application, and select New to create a variable that can be used in that application only.

    • Right-click a database, and select New to create a variable that can be used in that database only.

    • Right-click a rule, and select New to create a variable that can be used in that rule only.

  4. From Type, select Numeric.

  5. Enter a default value for the variable.

  6. Select File, Save.

Enter Variable Values for a String Variable

A string variable can be an Essbase replacement variable. A string variable must be alphanumeric and not more than 255 characters. It can contain a null value, but cannot contain a leading ampersand character in the value.

Enter Values for a Planning or Essbase Replacement String Variable

To enter values for an Essbase replacement string variable:

  1. In the System View, select Tools , Variables.

  2. In the Variable Navigator, expand the Essbase application type.

  3. Do one of these tasks:

    • Right-click an application, and select New to create a variable that can be used in that application only.

    • Right-click a database, and select New to create a variable that can be used in that database only.

    • Right-click a rule, and select New to create a variable that can be used in that rule only.

  4. From Type, select String.

  5. In the Value table, enter a value for the variable.

  6. By default, RTP is selected. If you do not want to create a run time prompt for this variable, clear RTP.

    If you do not select RTP, you must enter a value for the variable.

  7. If you selected RTP, enter the run time prompt text you want to display for users.

  8. Select File, Save.

Enter Values for an Array Variable

An array variable can be an Essbase execution variable. Arrays contain a list of values that can be multidimensional.

Typically, arrays are used to store variables as part of a member formula. The size of the array variable is determined by the number of members in the corresponding dimension. For example, if the Scenario dimension has four members, the following command creates an array called Discount with four entries. You can use more than one array at a time.

Array Discount

To enter values for an array variable:

  1. In the System View, select Tools, Variables.

  2. In the Variable Navigator, expand the Essbase application type.

  3. Do one of these tasks:

    • Right-click an application, and select New to create a variable that can be used in that application only.

    • Right-click a database, and select New to create a variable that can be used in that database only.

    • Right-click a rule, and select New to create a variable that can be used in that rule only.

  4. From Type, select Array.

  5. In the Value field, enter a value for the variable.

  6. Select File, Save.

Enter Values for a Member Range Variable

A member range variable can be an Essbase replacement variable. The member range variable should contain a range of members inclusive of, and between, two specified members.

Entering Values for a Member Range Variable

To enter values for a member range variable:

  1. In the System View, select Tools, Variables.

  2. In the Variable Navigator, expand the Essbase application type.

  3. Do one of these tasks:

    • Right-click an application, and select New to create a variable that can be used in that application only.

    • Right-click a database, and select New to create a variable that can be used in that database only.

    • Right-click a rule, and select New to create a variable that can be used in that rule only.

  4. In the Variable Navigator, expand the Essbase application type.

  5. From Type, select Member Range.

  6. In the Value table, do the following: is you are creating a member range for Essbase.

    1. If you are creating a member range variable for Essbase:

      1. For each dimension for which you want to define a member range, enter or use the Member Selector to select limits for the member range. (The dimensions that display are the dimensions that belong to the application for which you are creating the variable.)

        Note:
      2. Enter or use the Member Selector to select values for the member range. You can select multiple members and functions for each dimension listed.

  7. Select File, Save.

Enter Variable Values for a Cross Dimension Variable

A cross dimension variable is an Essbase replacement variable. It contains a range of members from multiple dimensions that enable you to run allocation rules across dimensions.

Entering Values for a Cross Dimension Variable

To enter values for a cross dimension variable:

  1. In the System View, select Tools, Variables.

  2. In the Variable Navigator, expand the Essbase application type.

  3. Do one of these tasks:

    • Right-click an application, and select New to create a variable that can be used in that application only.

    • Right-click a database, and select New to create a variable that can be used in that database only.

    • Right-click a rule, and select New to create a variable that can be used in that rule only.

  4. From Type, select Cross Dimension.

  5. For each dimension listed, in the Value table, enter or use the Member Selector to select limits for the variable.

    You must select RTP before you enter text in the Limits field.

  6. Enter or use the Member Selector to select a value for the variable. You can select a member or a function.

  7. Repeat step 5 through step 6 to select values for the all of the dimensions.

  8. Select File, Save.

Enter Variable Values for a Dimension Variable

A dimension variable is an Essbase replacement variable. This variable contains a dimension that you select.

Enter Values for a Dimension Variable

To enter values for a dimension variable:

  1. In the System View, select Tools, Variables.

  2. In the Variable Navigator, expand the Essbase application type.

  3. Do one of these tasks:

    • Right-click an application, and select New to create a variable that can be used in that application only.

    • Right-click a database, and select New to create a variable that can be used in that database only.

    • Right-click a rule, and select New to create a variable that can be used in that rule only.

  4. From Type, select Dimension.

  5. In the Value table, select a dimension. The dimensions displayed belong to the application for which you are creating the variable.

  6. Select File, Save.

Enter Variable Values for Members Variable

The member and member variables are Essbase replacement variables. These variables contain a member or multiple members from a dimension that you select.

Enter Values for a Member or Member Variable

To enter values for a member or members variable:

  1. In the System View, select Tools, Variables.

  2. In the Variable Navigator, expand the Essbase application type.

  3. Do one of these tasks:

    • Right-click an application, and select New to create a variable that can be used in that application only.

    • Right-click a database, and select New to create a variable that can be used in that database only.

    • Right-click a rule, and select New to create a variable that can be used in that rule only.

  4. From Type, select Member or Members.

  5. In the Value table, select a dimension. The dimensions that display are the dimensions that belong to the application for which you are creating the variable.

  6. Enter or use the Member Selector to select limits for the variable. You can select members only from the dimension you select in step 3. You can also select functions.

  7. Enter or use the Member Selector to select a value for the variable. You can select one member or function for a member variable and multiple members and functions members variables.

  8. Select File, Save.

Enter Variable Values for Percent Variables

The percent variable is an Essbase replacement or execution variable. This variable contains a percentage that you specify.

Entering Values for a Percent Variable

To enter values for a percent variable:

  1. In the System View, select Tools, Variables.

  2. In the Variable Navigator, expand the Essbase application type.

  3. Do one of these tasks:

    • Right-click an application, and select New to create a variable that can be used in that application only.

    • Right-click a database, and select New to create a variable that can be used in that database only.

    • Right-click a rule, and select New to create a variable that can be used in that rule only.

  4. From Type, select Percent.

  5. In the Value table, click in Limits to define minimum and maximum values for the variable.

  6. Enter a numeric value for the variable.

  7. Select whether missing data values can be allowed.

  8. Select File,Save.

Display the Uses of a Variable

You can display the allocation rules and templates that use variables. When you show the uses of a variable, the following information is displayed:

  • Names of the allocation rules and templates that are using the variable.

  • Application names of the allocation rules and templates that are using the variable.

  • Calculation types, plan types, or databases of the allocation rules and templates that are using the variable.

  • Owners of the allocation rules and templates that are using the variable.

  • Whether the allocation rules and templates that are using the variable are deployed.

  • Whether the allocation rules and templates that are using the variable are validated.

  • Description of the allocation rules and templates that are using the variable.

Displaying the Uses of a Variable

To display the use of a variable:

  1. In the System View, select Tools, Variables.

  2. In the Variable Navigator, select the database object that contains the variable whose usages you want to view. The variables defined for that object are displayed on the tabs in the Variable Designer.

  3. Right-click the variable whose usages you want to view, and select Show Usages.

  4. After you review the information, click OK.

Copy a Variable

You can copy a variable with the same name into the same or a different application using the copy and paste option. You can also copy a variable with a different name into the same or a different application using the Save As option.

Copy a Variable with a Different Name using the Save As Option

To copy a variable with a different name using the Save As option:

  1. In the System View, select Tools, Variables

  2. In the Variable Navigator, do one of the following tasks:

    • Expand Essbase, and select the application, database, or rule associated with the variable you want to copy.

      The variables associated with the object you select are displayed on the Replacement, or Execution tab, or both.

  3. Right-click the variable you want to copy, and select Save As.

  4. Enter a new name for the variable, then select the application, and the calculation type, plan type, or database, or accept the defaults.

    By default, the variable is copied to the same application and calculation type, or database in which the variable is created.

Refresh Variables

You can refresh the list of variables in the Variable Navigator to see the updated list after you add, delete, or make changes to variables.

Refreshing Variables

To refresh the list of variables in the Variable Navigator:

  1. In the System View, select Tools,Variables

  2. In the Variable Navigator, create, edit, or delete a variable.

  3. On the Replacement or Execution tab, right-click, and select Refresh.

Overview of Editing a Variable

You can edit any property of a variable from the Variable Designer. When you update a variable that was previously validated, any component that uses the variable is no longer validated. You must validate each component again.

Delete a Variable

You can delete a variable or variables from the Variable Designer if they are not used in any components or member formulas. If a variable is used in a component, you must remove the variable from the component before you delete it.

Deleting a Variable

To delete a variable:

  1. In the System View, select Tools, Variables.

  2. In the Variable Navigator, expand the Essbase application type and the application.

  3. Do one of the following tasks:

    • If the variable is a database variable, select the database with which the variable is associated.

    • If the variable is a rule variable, select the rule with which the variable is associated.

    • If the variable is an application variable, select the application with which the variable is associated.

    Any variables associated with the application type, the application, the calculation type, or database, and the rule are displayed on the Replacement or Execution tab.

  4. On the Replacement or Execution tab, right-click the variable you want to delete, and click Delete.

  5. In the Delete Confirmation dialog box, click Yes to confirm deletion of the variable.

Select a Variable

You can select a variable from various locations. You can select variables:

  • When you create components from within the Component Designer

  • When you create design time prompts from within the Template Designer

  • From other locations

Selecting a Variable

To select a variable:

  1. In the System View, expand Essbase application type.

  2. Expand the application, the calculation type, or the database (Essbase).

  3. Expand Rules or Templates, depending on whether the component is in a rule or template.

  4. Right-click the template or rule that contains the component you want to add a variable to, and select Open.

  5. When the rule or template opens, in its flow chart, select the component for which you want to insert a variable.

  6. In the tabs, do one of the following tasks:

    • For member range, data range, and fixed loop components, in the Variable field, select the Variable icon.

    • For formula components, click the Actions icon, and select Variable.

    • For script components, click the Insert a Variable icon.

    • For condition components, start the Condition Builder, select Actions> Variable.

  7. In Select Variable then, do one of these tasks:

    • Click Create to access the Variable Designer to create a new variable.

    • Select an existing variable from Category and select the object to associate with the variable. By default, the variable is associated with the application for which you create it.

  8. On Replacement or Execution, select one or more variables to insert into the component. Use Ctrl + Click or Shift + Click to select multiple variables.

  9. Click OK. The variables are inserted into the component.

  10. Select File, Save.

FAQs for Allocations and Periodic Entries

How can I access the Calculation Manager?

Login into the Oracle Fusion General Ledger application and navigate to the Journals work area. From the Journals work area select the Create Allocation Rules link and automatically log into the Calculation Manager in Workspace to create new allocation rules or rule sets.

Note: The application or the balances cube that is currently selected in the General Ledger Data Access Set is automatically selected in the Calculation Manager.

How can I create a folder in the Custom View?

In the Custom View, create folders that contain only the allocation rules, allocation rule sets, and formulas you want to view and work with.

To create a folder in the Custom View:

  1. In the System View, select View, Custom View.

  2. In the Custom View, right-click the Essbase application type, and select New Folder.

  3. In New Folder, enter a name for the folder.

  4. Click OK.

Tip: You can create nested folders by right-clicking the folder you want to create a folder in and selecting New Folder.

How can I rename a folder in the Custom View?

Rename the folders you create in the Custom View.

To rename a folder in the Custom View:

  1. In the System View, select View, Custom View.

  2. In the Custom View, expand the Essbase application type.

  3. Right-click the folder you want to rename, and select Rename.

  4. In the Rename Folder, enter a new name for the folder.

  5. Click OK.

How can I open an allocation rule?

You open an allocation rule from the System View that is displayed by default when you open Calculation Manager. You can also open a rule using File, Open from within the tab of another rule, rule set, component, or template.

To open an allocation rule:

  1. Navigator > General Accounting: Journals > Create Allocation Rules link.

  2. Navigate menu > Administration > Calculation Manager.

  3. In the System View, expand the Essbase Application Type, the Application, or Database, and Rules.

  4. Do one of these tasks:

    • Right-click the rule you want to open, and select Open.

    • Select the rule you want to open, and select File, Open.

How can I save an allocation rule?

You must save an allocation rule after you create or edit it. When you save the allocation rule, it is saved to the application and application type for which you created it. After you save it, you can validate and deploy it in Calculation Manager. You can generate it in Oracle Fusion General Ledger.

To save an allocation rule after you create or edit it, select File, Save.

Note: To see the allocation rule in the System View after you save it, you may refresh the application list. To do this, right-click the application type, the application, or the database (for Essbase), and select Refresh.

How can I save an allocation rule with a different name?

You can save an allocation rule with a different name using Save As. You can also copy a rule from one rule set to another within the same rule set type using Save As. Save As creates a copy of the original rule with a different name to distinguish it from the original.

To save an allocation rule with a different name:

  1. In the System View, expand the Essbase Application Type, the Application, or Database, and Rules.

  2. Right-click the rule you want to save with a different name, and select Open.

  3. In the Rule Designer, select File, Save As.

  4. In Save As, enter the rule's new name, and select the Application Name.

  5. Select the Database.

    Note: You cannot change the database of a rule you save with a different name.
  6. Click OK. The new rule is added to the application list in the System View.

How can I delete an allocation rule?

You delete an allocation rule from the System View. You can delete an allocation rule only if it is not used by other rules or rule sets. If the rule is being used, you must remove the allocation rule from the rules and rule sets using it, or make copies of it for the rules and rule sets using it, before you delete it. To see if a rule is used by other rules and rule sets, you can show the usages of the rule.

To delete an allocation rule:

  1. In the System View, expand the Essbase Application Type, the Application, or Database, and Rules.

  2. Make sure the rule you want to delete is not being used by another rule set or rule.

  3. Right-click the rule you want to delete, and select Delete.

  4. Click OK to confirm deletion of the rule.

How can I open an allocation rule set?

You open an allocation rule set from within the System View. You can also open a rule set from within the Ruleset Designer, by selecting File, then Open.

To open an allocation rule set:

  1. In the System View, expand the Essbase application type and the application.

  2. For Essbase: Expand RuleSets, right-click the rule set you want to open, and select Open.

    Note: For Essbase applications, there is only one rule set node for each application at the same level as the databases.

How can I open an allocation rule within an allocation rule set?

You can open an allocation rule from within an allocation rule set from the System View or from the Ruleset Designer.

To open an allocation rule within an allocation rule set:

  1. In the System View, expand the Essbase Application Type and the Application.

  2. Expand your rule set that contains the rule you want to open.

    Note: For Essbase applications, only one rule set node exists for each application at the same level as the databases.
  3. Right-click the rule you want to open, and select Open.

    Note: You can also open a rule that belongs to an allocation rule set from within the Ruleset Designer. To do this, in the Ruleset Designer, right-click the rule, and select Open.

How can I remove an allocation rule from an allocation rule set?

When you remove a rule from an allocation rule set, the rule is not deleted. The rule exists independently of the rule set in the database.

To remove an allocation rule from an allocation rule set:

  1. In the System View, expand the Essbase Application Type and the Application.

  2. Expand RuleSets, right-click the rule set you want to open, and select Open.

    Note: Only one rule sets node exists for each application at the same level as the plan types and databases.
  3. In Ruleset Designer, right-click the rule you want to remove, and select Remove.

Select File, Save.

How can I open a point of view or allocation component?

You open a point of view or allocation component from within the flow chart of the rule to which it belongs.

Note: You cannot open the allocation component from the System View.

To open a point of view or an allocation component:

  1. In the System View, expand the Essbase Application Type, the Application, Database, and Rules.

  2. Right-click the rule that contains the component you want to open, and select Open. The rule is displayed in the Rule Designer.

  3. When the rule opens, click the point of view component or double-click the allocation component in the rules flow chart to open the component.

How can I save a point of view or allocation component ?

You save a point of view or an allocation component when you save the rule to which it belongs in the Rule Designer. Unlike the formula components, point of view and allocation components cannot exist independently for the rule to which they belong.

To save a point of view or allocation component:

  • Select File and Save, or click the Save icon, once you finish designing a point of view or an allocation component.

How can I copy and paste a point of view or allocation component?

You can copy a point of view or allocation component from within the rule in which it is used, and you can paste the component into the same or a different rule.

To copy and paste a point of view or allocation component in a rule flow chart:

  1. In the System View, expand the Essbase Application Type, the Application, Database, and Rules.

  2. Right-click the rule that contains the point of view or allocation component you want to copy and paste, and select Open. The rule is displayed in the Rule Designer.

  3. In the Rule Designer, right-click the point of view or allocation component you want to copy in the rules flow chart, and select Copy to copy only the component or Copy Group to copy the component and the associated components within it.

  4. Do one of the following tasks:

    • To paste the component into the same rule, right-click the location in the flow chart where you want to paste the component, and select Paste.

    • To paste the component into a different rule, open the rule, right-click the location in the flow chart where you want to paste the component, and select Paste.

    Note: You can also select Edit and Paste.
  5. Select File and Save.

How can I delete a point of view or allocation component?

You delete a point of view or an allocation component from the System View. Since point of view or allocation components can be used in only one rule, you can delete these components by removing them from the rule to which they belong.

To delete a point of view or an allocation component:

  1. In the System View, expand the Essbase Application Type, the Application, or Database, and Rules.

  2. Right-click the rule that contains the point of view or allocation component you want to delete, and select Open. The rule is displayed in the Rule Designer.

  3. In the Rule Designer, select the point of view or allocation component you want to delete in the flow chart.

  4. Right-click the point of view or allocation component.

  5. Select Remove to confirm the removal of the component.

    Note: If the allocation component is within the point of view component, then removing the point of view component removes the allocation component.
  6. Select File and Save.

You can export your allocation rules from a source environment and import them to a target environment using a implementation projects. In the Setup and Maintenance work area, create an implementation project that includes only the Manage Allocations and Periodic Entries task. Then use the Manage Configuration Packages task to export and import the allocation rules.