Open EPM ← Back to openepm.dev

Data import and export

Open Data in the disposable Operating Data Cube with a grant for the required import or export function. The CSV header must include every active axis for the target model. Use stable member IDs.

axis.Account,axis.Entity,axis.Year,axis.Period,axis.View,axis.Value,axis.Scenario,axis.DataType,axis.Custom01,literalType,value,sourceRef
InputA,PointA,Y2027,P01,Input,Raw,Actual,InputData,ItemA,AmountLiteral,12.50000000,walkthrough-input

Import one cell

  1. Under Load governed CSV data, paste the sample into UTF-8 CSV text and choose Prepare pasted CSV. Choose Merge supplied cells for Target handling.
  2. In Exact scope, enter Account=InputA; Entity=PointA; Year=Y2027; Period=P01; View=Input; Value=Raw; Scenario=Actual; DataType=InputData; Custom01=ItemA. Check I reviewed the exact input and target scope and choose Stage and validate CSV.
  3. Choose Preview exact changes. From the starting sample of 10.00000000, expect one row, one set, zero clears, zero errors and zero warnings. Check I reviewed the exact set and clear counts and choose Start durable publication.
  4. Keep the batch and import request IDs. Choose Refresh until the status is Completed. Use Inspect exact receipt to confirm the batch ID and committed revision. Read the same cell and verify 12.50000000.

If validation finds errors, correct the input and stage it again. To proceed with warnings, inspect the diagnostics, choose Permit reviewed warnings and generate a fresh preview.

Export the committed cell

  1. Under Export a governed snapshot, enter the same Exact scope and select the availability period. Review the scope and availability, then choose Start snapshot export. The request pins the current committed revision.
  2. Choose Refresh status until the artifact is available, then choose Download complete JSON bundle. Retain the request ID, artifact ID and bundle together.
  3. To validate the bundle before re-import, select it with Choose CSV or governed export bundle. The browser checks the manifest and payload digests before showing Prepared. Preserve numeric zero, empty text and absence as separate cases.

For an interrupted submission, follow the recovery procedure.

Discussion

Discussing Data import and export

The discussion service requires JavaScript and a connection to Firebase.