Budget Data Import Using Business Rules

To import budget data using a business rule, you need to define and run the business rule successfully in your Planning and Budgeting.

To define and run a business rule:

In your Planning and Budgeting environment, click the Navigator icon . Then, under Create and Manage, click Rules.
On the System View tab, go to the cube in which you want to create the business rule, and click the Rules folder.
Click the New Object icon .
In the New Object popup window, do the following:
1. From the Object Type list, select Rule.
2. In the Name field, enter a unique name for this rule.
3. Click OK.
4. At the prompt to open the rule directly for editing, click OK.
Switch from the Designer mode to the Edit Script mode.
Enter a script that should have a format similar to the following:
```
                SET DATAEXPORTOPTIONS
{
DATAEXPORTLEVEL LEVEL0;
DATAEXPORTDIMHEADER ON;
DATAEXPORTDYNAMICCALC OFF;
DATAEXPORTNONEXISTINGBLOCKS OFF;
DATAEXPORTOVERWRITEFILE ON;

};

FIX ( @RELATIVE ("Account",0),
@RELATIVE("Class",0),
@RELATIVE("Subsidiary",0),
@RELATIVE("Location",0),
@RELATIVE("Department",0),
@RELATIVE("Item",0),
@RELATIVE("Relationship",0),
@RELATIVE("Department",0)
@RELATIVE( "YearTotal",0)
)

DATAEXPORT "File" "," &BudgetFilePathName "NA" ;
ENDFIX 

              
```
Read the following guidelines on configuring the entered script:
- Add or remove columns as required.
- Replace the &BudgetFilePathName variable with a path to the CSV file that the business rule should generate and store in Inbox/Outbox Explorer.
  
  For example: "/u03/lcm/nspbcsBudgetBr.csv"
  - Make sure you enclose the file path in quotation marks ("").
  - The file path is relative to your environment configuration.
  - The file name included in the file path must match exactly the file name defined in the plug-in to be used for budget data processing.
  - If you want to use the predefined NSPB - Import Budget Data Using BR post-processing plug-in, the file path must include the following file name:
    
    nspbcsBudgetBr.csv
    
    The file name must match exactly, including upper and lower case.
  - You can create a substitution variable as a placeholder for the file path. To create the substitution variable, proceed to the optional step 10.
Click the Validate and Save icon . If validated successfully, click OK.
Click the Validate and Deploy icon . If deployed successfully, click OK.
Click the Launch icon to run the business rule. If ran successfully, click OK.

This generates a CSV file containing budget data and stores it in Inbox/Outbox Explorer. To access the CSV file, go to Application > Overview > Actions > Inbox/Outbox Explorer.
(Optional) To create a substitution variable as a placeholder for the path to the CSV file to be stored in Inbox/Outbox Explorer, do the following:
1. In your Planning and Budgeting environment, click the Navigator icon . Then, under Tools, click Variables.
2. Click the Substitution Variables tab.
3. Click the Add icon .
4. In the Name column, enter a unique name for the substitution variable.
  
  For example: BudgetFilePathName
5. In the Value column, enter the path to the CSV file that the business rule should generate and store in Inbox/Outbox Explorer.
  
  For example: "/u03/lcm/nspbcsBudgetBr.csv"
  - Make sure you enclose the file path in quotation marks ("").
  - The file path is relative to your environment configuration.
  - The file name included in the file path must match exactly the file name defined in the plug-in to be used for budget data processing.
  - If you want to use the predefined NSPB - Import Budget Data Using BR post-processing plug-in, the file path must include the following file name:
    
    nspbcsBudgetBr.csv
    
    The file name must match exactly, including upper and lower case.
6. Click Save. Then, click OK to complete the action.

For general information and additional setup, see the Oracle Help Center topics Designing Business Rules and Launching Planning Business Rules and Viewing Logs from the Rule Designer.

To define and run a business rule:

Related Topics