Open EPM ← Back to openepm.dev

Inspect supporting detail

Replace the placeholders with values from your own authorized scope before copying this prompt into an MCP client.

Inputs

  • {{workspace_id}} Stable workspace ID.
  • {{application_id}} Stable application ID.
  • {{coordinate}} Full stable-ID coordinate of the cell.

Prompt

In {{workspace_id}} / {{application_id}}, use read_v2_program with facts.export.page using members {{coordinate}} and limit 1.
If value.type is LineDetailLiteral, report each item description and exact decimal, then sum with decimal arithmetic.
Use facts.cube.scan with the same members, limit 1, and the returned snapshotRevision. Compare its amount to the sum and report its numericChangeId. Check that snapshotRevision, metadataRevision and securityRevision agree.
Report an empty result or scalar literal as returned. Stop on a mismatched total, stale revision or access failure.
End after the read.

Example inputs

For separate, authorized setup in the disposable Operating Data Cube, verify the P02 coordinate below is empty. Then use the preview and submit procedure with this program and a fresh request key. Wait for the detail job to publish before using the read-only prompt. The two detail lines total 1.00000001.

{
  "languageVersion": 2,
  "function": "facts.line-detail.replace",
  "arguments": {
    "coordinate": {
      "Account": "InputA",
      "Entity": "PointA",
      "Year": "Y2027",
      "Period": "P02",
      "View": "Input",
      "Value": "Raw",
      "Custom01": "ItemA",
      "Scenario": "Actual",
      "DataType": "InputData"
    },
    "items": [
      {
        "description": "Travel",
        "amount": "1.25000001"
      },
      {
        "description": "Credit",
        "amount": "-0.25000000"
      }
    ],
    "expectedCellChangeId": "",
    "expectedDetailChangeId": ""
  }
}

Tools used include read_v2_program. The separate setup uses preview_v2_program and submit_v2_program. See the module guidelines and tool index.

Discussion

Discussing Inspect supporting detail

The discussion service requires JavaScript and a connection to Firebase.