Fields on Datasets Created from Plans

When you send a plan to Analytics, a dataset is created or updated. This dataset contains all the dimensions and measures that were mapped in the output data source. The API names and labels of the dimensions and measures are determined by the mappings. For more information, see Dimension and Measure Mapping Rules. In addition, every dataset created from a plan contains the fields listed in the Fields Available on a Dataset Created from a Plan table.

Each row of the dataset represents a plan cell. If the plan contains multiple measures, the measure with a value other than zero represents the value of the plan cell.

Fields Available on a Dataset Created from a Plan

Type	Label	API Name	Description
Dimension	Calculated	IsCalculated	This is set to true if the cell value was calculated using a formula in Extended Planning and Analysis. Otherwise, this is set to false.
	Dataset Row ID	DatasetRowId	For system use. The ID of the dataset row. Used when updating the dataset.
	Plan ID	PlanId	The ID of the plan that the cell belongs to.
	Plan Name	PlanName	The name of the plan that the cell belongs to.
	Plan Scenario ID	PlanScenarioId	The ID of the scenario that the cell belongs to.
	Plan Scenario	PlanScenarioName	The name of the scenario that the cell belongs to.
	Planning Unit Code	PlanningUnitCode	The code of the Planning unit applied to the cell. If a unit is not applied, this is null.
	Subtotal	IsSubtotal	This is set to true if the cell value belongs to a subtotal row in a tree view plan. This means that it belongs to a group row in the tree. Otherwise, this is set to false. Note: When creating a new plan from a dataset that was originally created by sending a plan to Analytics, any dataset rows with the Subtotal dimension set to true are automatically excluded from the plan.