Cut, Paste, and Skip Rules

The cut, paste, and skip actions you perform for each column follow pre-configured rules.

  • When you skip a column, it moves to the Skip section of the table. You can only paste a column as a sibling of the Skip header, or as a sibling of any skipped column.
  • Any columns that are pasted as a Measure follow the rule of the paste command. Measure hierarchies are allowed, but the designation type doesn’t change.
  • Paste as Child action for Dimension columns:
    • When a column is pasted as a child of the Dimensions header, the cut column is pasted as a Dimension.
    • When a column is pasted as a child of the Dimension column:
      • The cut column is pasted as a Generation.
      • If the Dimension column already has a Generation child, the existing Generation (and its children) becomes the children of the new Generation column.
    • When a column is pasted as a child of the Generation column:
      • The cut column is pasted as a child of the Generation if the cut column is an Alias, Attribute, or UDA.
      • The cut column is pasted as a Generation if the cut column isn’t an Alias, Attribute, or UDA.
    • Paste as Child for any Dimension column isn't allowed if the target is an Alias, Attribute, or UDA.
  • Paste as Sibling action for Dimension columns:
    • When a column is pasted as a sibling of a Dimension column, it's pasted as a Dimension.
    • When a column is pasted as a sibling of an Attribute, Alias, or UDA and it isn’t an Alias, Attribute, or UDA, the column is pasted as an Attribute.
    • Paste as Sibling for any Dimension column isn't allowed if the target is a Generation.