Calculation and Processing Commands

Calculation and processing commands include:

Calculate Model

Table 14-13 Calculate Model

Command What it Does Criteria Sample Prompts See Also
Calculate Model Calculates a model and one or more points of view
  • Model: (required if no saved job): Model to calculate; defaults to the current Designer model.
  • Point of View (required): POV to calculate; can be a single POV, the current POV, or a generated range
  • Saved Job (optional): Use a saved calculation job; model and POV can be taken from that job
  • Rule Range (optional): Limit calculation to all rules, a specific rule, a start or stop rule, a ruleset sequence range, or a single rule
  • Ruleset Sequence Range (optional): Start and end sequence numbers for a subset of rulesets
  • Rule Name (optional): Name of the rule when using single‑rule or start/stop options
  • Clear Calculated Data (optional): clear existing calculated data before running; default is "true"
  • Execute Calculation (optional): Run the calculation steps; default is "true"
  • Capture Diagnostic Data (optional): Capture diagnostics if requested; default is "false"
  • Capture Debug Scripts (optional): Capture Essbase debug scripts if requested; default is "false"
  • Optimize for Reporting (optional): optimize reporting data after calculation; default is "true"
  • Comment (optional): Add additional context or notes
  • Save Job (optional): Save this calculation setup as a reusable job name

calculate model

calculate model 10 Actuals Allocation Process

calculate model 10 Actuals Allocation Process for POV FY24::Jan::Actual::Working

calculate model for POV range FY24 Jan to FY24 Mar

calculate only custom rules

calculate rule Activity Costing Assignments

calculate model and clear calculated values first

calculate model and save as job Calculate FY24 Jan

run calculation job Calculate FY24 Jan

 Using PCM Agent to Calculate a Model

POV Commands

Table 14-14 POV Commands

Command What it Does Criteria Sample Prompts See Also
Create POV Creates one or more POVs from selected dimension members, checking for existing POVs

Create Point of View (required)

Years (required)

Periods (required)

Scenarios (required)

Versions (required)

Creation Scope (required)

Delimiter (optional)

create pov

create POV FY24::Jan::Actual::Working

create POV range FY24 Jan to FY24 Mar

create POVs Jan,Feb,Mar

create POVs for years FY26 and FY27, periods Jan and Feb, scenarios Actual and Plan, versions Working and What If 1

 Using PCM Agent to Create a Point of View
List POV Finds and reviews POVs. You can list, search, count, and inspect POVs by name, status, calculation state, model, and more
  • List Points of View (required)
  • Name Filter (optional)
  • Status (optional)
  • Calculation State (optional)
  • Model (optional)
  • Current Point of View (optional)
  • Sort and Limit (optional)

list povs

show all povs

pov count

  
Clear POV Clears data (input, allocated, or adjustment) from POVs while keeping definitions

Point of View (required)

Clear Options (required)

Delimiter (optional)

Cube (optional)

Save Job (optional)

Saved Job (optional)

clear POV FY24::Jan::Actual::Working

clear current POV

clear input data for POV FY24::Jan::Actual::Working

clear POV range FY24 Jan to FY24 Mar

clear POV for cube PCM_REP

clear POV and save as job Clear FY24 Jan

 Using PCM Agent to Clear a Point of View
Copy POV Copies data from source POVs to destination POVs, with options for saved jobs, overrides, and cube selection
  • Source Point of View (required)
  • Destination (required)
  • Destination Year (optional)
  • Destination Period (optional)
  • Destination Scenario (optional)
  • Destination Version (optional)
  • Source Cube (optional)
  • Destination Cube (optional)
  • Delimiter (optional)
  • Comment (optional)
  • Save Job (optional)
  • Saved Job (optional)

copy POV FY24::Jan::Actual::Working to FY24::Feb::Actual::Working

copy input data from FY24 Jan to FY24 Feb

copy POV range FY24 Jan to FY24 Mar into FY25 Jan to FY25 Mar

copy POV for cube PCM_REP

copy POV and save as job Copy FY24 Jan

 Using PCM Agent to Copy a Point of View
Delete POV Deletes POV definitions that are no longer needed

Point of View (required)

Delimiter (optional)

Save Job (optional)

Saved Job (optional)

Delete current pov

delete POV FY24::Jan::Actual::Working

delete POV range FY24 Jan to FY24 Mar

delete POV and save as job Delete FY24 Jan

 Using PCM Agent to Delete a Point of View

Job Commands

Table 14-15 Job Commands

Command What it Does Criteria Sample Prompts
Create Job Creates a saved job definition that can be reused later
  • Job Name (required): Name for the saved job
  • Job Type (required): Type of job to create (calculate model, copy point of view, clear point of view, or delete point of view)
  • Command Details (required): Parameters required by the selected job type
  • Related Instructions (required): Use the instruction set for the selected job type to collect needed details

create job "Job1" for Copy pov

create job "Job1" for Copy POV using same as source

Delete Job Deletes saved job definitions or selected jobs after checking the target Job Name (required): Name of the saved job to delete

delete saved job Monthly Calculation

remove saved job Monthly Calculation

Delete job 'job10'
List Jobs Lists recently-run jobs and helps find executed jobs by type, status, name, or related calculation operation
  • List Job (required): Ask to list recent executed jobs
  • Limit (optional): Number of recent run jobs to return (default 5)
  • Job Type (optional): Filter recent jobs to a selected job type
  • Status (optional): Filter recent jobs by status
  • Name (optional): Filter recent jobs by job name text

list jobs

show jobs

show recent jobs

show job configurations

List Saved Jobs Lists saved job configurations and helps find reusable job definitions by type or name
  • List Saved Jobs (required): Ask to list saved job configurations
  • Job Type (optional): Filter saved job configurations to a selected job type.
  • Name (optional): Filter saved job configurations by job name text

list saved jobs

show saved jobs
Run Saved Job Runs an existing saved job configuration after resolving the saved job name
  • Run Saved Job (required): Ask to run, execute, start, launch, or trigger a saved job configuration
  • Job Name (required): Name of the saved job configuration to run

run saved job

run saved job Monthly Calculation

execute saved job "Monthly Calculation"

Job Details Shows detailed information for a selected job, including status, parameters, logs, errors, and execution details
  • Job Details (required): Ask for details for one or more jobs.
  • Job Identifier (required): One or more job identifiers to inspect
  • Details (optional): Include parameters, logs, errors, and saved job information when available

show job details for job 123

show job status for job 456

show job logs for job id 789