Copying and Pasting Elements in Dimensions


As of Jedox 7.0 SR1 the Modeler supports copying elements of a dimension and pasting them into another dimension in Modeler or pasting them in a spreadsheet.

For these actions, the shortcuts Ctrl + C and Ctrl + V must be used. There are also context menu commands for both actions, but due to browser restrictions, these items will just display a popup message referring to the required keyboard shortcut.

If full row(s) are selected, the copy has PCWAT format (content: Parent, Child, Weight, Attribute(s), and Type) and the attributes will be inserted in the target dimension provided the correspondent columns exist. Attributes will only be inserted if the existing attribute name is completely identical with the attribute column name of the clipboard content (case-sensitive).

If you paste a copy into a dimension with existing elements, then the elements from the clipboard are added to the existing elements and all resulting elements will be sorted in the order that exists before the insertion.

If you copy one or more consolidated elements, an internal insertion into dimension of the same modeler will include also the direct child elements.
If you paste such a selection externally (into a spreadsheet or into a dimension of another modeler), child elements are not included. For an external insertion, all elements must be copied explicitly.

If you only select the element name(s) (not the whole row(s)), then the copy has PCW format (Parent, Child, and Weight – Attributes are not included).

If the copy is made from a spreadsheet, and has three columns, then the format must be PCW and a header row is not required. If content has more than three columns (e.g. 4, 5, 6), a header row is required (:parent, :child, :weight, [<attribute1,…>], :nodetype). Attribute column headers must match 100% the existing attribute names (case-sensitive) of the dimension, otherwise attributes will not be inserted.

Was this post helpful?
NoYes (-1 rating, 1 votes)