In Data mode, the cube dataset is displayed as a flat table by default. This table can show a huge number of rows very quickly since it does not have to take any reporting and formatting capabilities into consideration.
The first column of the table contains the row’s number in the table.
In the Build Side Panel → Data tab → Feeding sub-tab, you may define what column(s) to display and in which order.
If you are connected through HTTPS or if you are using the Web Intelligence Rich Client, you can copy lines and columns from Dataset View tables or facets and paste them into the Operating System’s clipboard
With the mouse, select an area or multiple rows and columns in a table or a facet. It is not possible to select and copy disjointed cells, rows, or columns. You can use the following shortcuts:
- [Ctrl] + [A]: To select a full table or a full facet.
- Right-click + [Shift]: To select an area.
- Right-click + [Ctrl]: To toggle a selected area.
Right-click this selection (rows headers, lines headers, selected area) and select the Copy command in the context menu (you may also use the [Ctrl] + [C] shortcut). Both the selected cells and their headers are copied into the clipboard, but the copy cannot exceed 25,000 cells.
If you paste this selection into another tool that supports Rich Text, then the table is added with its formatting and borders. If you paste it into a simpler text editor like Notepad, a plain text version is used. Its format (column separators, text qualifiers, charset) is defined in the options set in the Export to dialog box when exporting to CSV and saved in the user settings.