Copy items to spreadsheet

You can copy items from an analysis output table and paste them to a model of the Spreadsheet type.

Prerequisite

A table view is created for the query or the ad-hoc analysis.

Procedure

  1. Start the query or the ad-hoc analysis.
  2. Click Output Output if the table is hidden.
  3. Activate the Data tab bar.
  4. Copy the required cells (Ctrl + C).
  5. Paste the cells to the model of the Spreadsheet type (Ctrl + P).

You have added contents to your spreadsheet.

If the copied cells conntained formulas, such as =ANALYSIS_ITEM_LOCKED_BY_USER(<CELL_REFERENCE>) or =QUERY_LOCKED_BY_USER(<CELL_REFERENCE>), the formulas are converted to =ARIS_ITEM_LOCKED_BY_USER(<CELL_REFERENCE>).