Export data slice
export_data_sliceExports a slice of numbers from any cube of the connected application. It reads the cube's dimensions first, puts the account dimension on rows and the period dimension on columns, maps scenario, year and entity to the cube's matching dimensions whatever they are called (Entity or Subsidiary, Year or Fiscal Year), and gives every other dimension its top member unless pov names a member for it, for example pov: { Version: "NSP_Base", Currency: "USD" }. Returns the rows as a table and as structured data, cut to the policy's cell limit with a note when that happens, and reports which member was used for each dimension. Scenario, Version and Currency usually need a leaf member (Actual, Base, USD) because their top members hold no data, and in many applications the top member of a custom dimension holds no total either. When a slice comes back empty, the result names the dimensions left at their top member with their first children; pass members for them, or browse a dimension with list_dimension_members when it is available. Use it to read actuals, plan or forecast numbers for analysis or commentary.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| pov | No | Members for any other dimension, for example { Version: "NSP_Base", Currency: "USD" }; dimensions you leave out use their top member | |
| rows | No | Dimension names to put on rows, e.g. ["Account", "Department"]. Defaults to the account dimension. | |
| year | No | Year member, e.g. FY26 or FY24 | |
| fresh | No | Set true to ignore the scenario, year, entity, cube and pov remembered from the user's previous request, start from scratch and read Oracle again even inside the policy's cache window. | |
| entity | No | Entity member, e.g. North America. Goes to the cube's entity-like dimension (Entity, Subsidiary, Company). | |
| period | No | Period member or comma-separated list, e.g. Jan, Q1 or TP1,TP2,TP3. Member functions such as ILvl0Descendants(YearTotal) work. Defaults to level 0 members under YearTotal. | |
| account | No | Account member or comma-separated list, e.g. Revenue or Descendants(Net Income). Defaults to all level 0 accounts. | |
| appName | No | Application name. Defaults to the connection's application. | |
| columns | No | Dimension names to put on columns, e.g. ["Period"] or ["Period", "Scenario"]. Defaults to the period dimension. | |
| planType | No | Cube (plan type) to export from, e.g. Plan1 or NSP_NFS. When the application has one cube it is used; with several, pass one. Otherwise Plan1. | |
| scenario | No | Scenario member, e.g. Actual, Plan, NSP_Actual | |
| connection | No | Connection id or label from list_connections. Defaults to the user's default connection. | |
| planningData | No | Set true to read through the application's form engine (Smart List labels, form-level security) instead of the plain cube export. The cube export is the default because the form engine returns nothing when a parent member is in the point of view. |