importValidIntersections

Imports valid intersection groups from a ZIP file that contains one Excel file with valid intersection definitions into the business process. Before running this command, use the uploadFile command to upload the import file to the environment.

Your import ZIP file should contain an Excel file with two worksheets (Rules and Sub Rules) for successfully importing valid intersections. The first sheet, Rules, should define the intersection group, dimensions included, and properties such as Unspecified Valid, Additional Dims Required. The second sheet, Sub Rules, should provide member selections and exclusions. For more information, see these topics in Administering Planning.

• Anchor and Nonanchor Dimensions
• Valid Intersection Examples

The best method to get the import file format template is to export valid intersections from the application. A sample format is presented in the following illustrations.

Applies To

Planning, Planning Modules, FreeForm, Financial Consolidation and Close, Tax Reporting, Enterprise Profitability and Cost Management, Sales Planning, and Strategic Workforce Planning.

Required Roles

Service Administrator

Usage

epmautomate importValidIntersections FILE_NAME.zip [ErrorFile=ERROR_FILE_NAME.txt] where:

• FILE_NAME is the name of the ZIP file that contains the valid intersection definition Excel file.

• ErrorFile, optionally, identifies the name of the text file to which error records will be written. If this parameter value is not specified, EPM Automate automatically generates an error file; you can view its name in the Job Console.

Example

epmautomate importValidIntersections VI_Import_File.zip ErrorFile=VI_Import_Log.txt