Using Paste Elements


In a new spreadsheet, make sure that the cursor is placed in the cell in which you want to paste elements. Then select Paste Elements to open the following dialog:

You can select a connection at the top left corner and a dimension below. The dialog loads only elements for the dimension level that is currently displayed, rather than retrieving full dimension content, which allows it to display the results more quickly. You can only handle elements of one dimension at a time.

Note that if the dialog has to load a flat, large list of elements (e.g., a large list of direct children for an expanded parent) or when using the Expand All button on a highly complex dimension, the results can still take some time.

If you have selected one single element, you can click the Paste button. The element will be inserted with the function PALO.ESELECT in the spreadsheet cell.

Double-click on that cell to open a new dialog window, which allows you to select another element from the same dimension. Use “+” and “-” to open and close one level. “Expand all” and “Collapse all” refers to the entire element tree.

With more than one selected element, you can build column titles (Paste vertically) or row titles (Paste horizontally). Open the whole dimension with the “++” button:

With the option “More” on the bottom right, you can show more selection tools. In the screenshot above, the “South” is selected and its sub-elements are selected  by clicking the “Select branch” icon. When pasted vertically, the following list appears in the spreadsheet:

As you can see in the formula bar of the screenshot above, such row titles are displayed as text, not as a function.