Analysis Commands

Table 15-16 Analysis Commands

Command What it Does Criteria Sample Prompts
Run Trace Runs a trace analysis for a selected point of view, cube, and data form or saved data query to show how calculation data flows through a model.
  • Data Form (required): Data form to trace when not using a saved data query. The data form is matched independently of the cube.
  • Point of View (required): Point of view to trace. If not specified, the current or default point of view is used.
  • Saved Data Query (optional): Saved data query term configured in AI Configure. It supplies the data form and any configured member selections.
  • Cube (optional): Cube to use for the trace. Defaults to PCM_CLC.
  • Selection Overrides (optional): Dimension member selections to use instead of the data form selections. Members may be provided with a dimension, as dimension.member, or without a dimension. Run Trace resolves the dimension for member‑only selections. A data‑form POV dimension accepts one member.

Run Trace Product Cost

Run Trace data form Trace Product Costs for pov FY24, Jan, Actual, and Working cube PCM_CLC member Product: P100 and P200

Run Trace form 'Trace - Product Costs' with selection override 'member1'
Calculation Analytics Reviews calculation activity and explains performance results in simple terms. It can summarize calculation jobs, compare rule timings, inspect model or POV execution metrics, and highlight diagnostics for slow or failed runs.
  • Calculation Analytics (required): Request analysis of calculation performance.
  • Job Identifier (optional): Specify a particular calculation job to analyze.
  • Model (optional): Limit the analytics to a specific model.
  • Point of View(optional): :Limit the analytics to a specific point of view.
  • Details (optional): Request rule timing, performance details, or diagnostics.

analyze calculation job 12345 and explain top failures

show rule timing for job 12345

analyze calculation performance for job 12345
Calculation Performance Summary Summarizes one calculation job, including runtime, model, point of view, and top rules.
  • Job Identifier (required): ID of the calculation job to analyze. .
  • Question (optional): Include additional details requested by the user.

summarize calculation job 12345

show performance summary for job 12345
Calculation Dimension Design Reviews dynamic hierarchy and dimension design best practices for calculation performance.
  • Dimension Design (required): Describes the dimension hierarchy or dynamic hierarchy design.
  • Job Identifier (optional): The calculation job if the review should be tied to a specific run.
  • Question (optional): Any additional dimension design criteria.

evaluate the dimensions design dataset

review dynamic hierarchy best practices
Calculation System Settings Reviews calculation optimization settings such as non‑empty tuple, scratch cells, and skip scripts.
  • Job Identifier (required): Review settings for one calculation job.
  • Question (optional): Include the specific settings requested.

review calculation optimization settings for job 12345

review calculation optimization settings for job 12345
Calculation Top Rules Ranks calculation rules by runtime, cells updated, scripts, potential sources, destinations, segments, or subrules. Show top rules for one calculation jobn (required).

show top 10 time consuming rules in job 12345

show slowest rules for job 12345

show the top 4 rules by cells updated for job 12345
Calculation Compare Historical Jobs Compares one calculation job with similar historical jobs. Job Identifier (required): Compare one job with historical jobs.

compare job 12345 with historical jobs

show historical comparison for job 12345
Calculation Rule Best Practices Evaluates selected calculation rules for performance and design best practices.
  • Job Identifier (requireed): Evaluate rules from one calculation job or run identifier.
  • Selected Rules (required): Include at least one rule name (with rule type if available).
  • Question (optional): Include additional best‑practice criteria.

evaluate rule Customer Spend Allocation in job 1010

review rule best practices for job 1010
Calculation Benchmark Job Benchmarks one calculation job against another job from the same model.
  • Job Identifier (required): Benchmark the primary calculation job.
  • Question (required): Include the comparison job identifier from the same model.

benchmark job 1051 against job 1050

compare job 2428 against job 2340 using job statistics

Calculation Slow Job Diagnosis Explains why a calculation job is slow and reviews its calculation threads, captured parallel version, and clear type.
  • Job Identifier (optional): Analyze a specific job or use the current calculation‑job context.
  • Question (optional): Request calculation threads, parallel version, or clear type individually.

why is job 46 slow

review calculation thread setting for job 46

review clear type for job 46
Calculation Slow Job Comparison Compares why one calculation job is slow against another job from the same model.
  • Primary Job Identifier (required): Analyze the slower calculation job.
  • Comparison Job Identifier (required): Compare against a calculation job from the same model.

why is job 13 slow compared to job 12
Calculation Rule Comparison Compares two rules in one calculation job or the same rule across two jobs from the same model.
  • Rule Names (required): Two rules to compare (within one job or across jobs).
  • Job Identifiers (required): One job for a within‑job comparison or two jobs from the same model for an across‑job comparison.

compare rules Activity Costing Assignment, Utilities Expenses in job 43

compare rule Utilities Expenses in job 43 against job 42
Calculation Generate Summary Report Generates the full calculation analytics summary report.
  • Job Identifier (optional): Generate a report for one calculation job when supplied.
  • Question (optional): Include the report scope requested by the user.

generate analytics summary report for job 12345

generate the full calculation analytics summary report