To properly copy a table, just use the mouse to select an area, and then using the keyboard shortcut Ctrl+C, copy the data to the clipboard. The selected area is highlighted in a different color to make sure what exactly is being copied.
Example:
After copying, just do the keyboard shortcut Ctrl+V or right mouse button + paste.
Instead of using the mouse, you can also select the entire table with the keyboard shortcut Ctrl+A.
In a situation where a specific dimension contains multiple sub-dimensions in the table, for example,
the Year dimension contains multiple documents from the Document Number dimension,
The Copy function will split the Year dimension into each document number from the table (the column with year is not merged):
In a situation where dimensions are presented differently in the table, as in the case below:
- Year dimension is expanded
- Document Number dimension is expanded for one document only
- Product Code dimension is only expanded for one document that is expanded in the Document Number dimension
the table will look as follows after pasting the data:
As shown in the above screenshot, when there is no product expanded for other dimensions, the corresponding column is copied from the previous dimension (in this case, these are the red document numbers framed in red).
As far as the format of copied data is concerned, the data is always pasted in numerical format after copying. Example:
Comarch BI Point
- Measure “Sales Value” in thousands format
- Measure “Sales Quantity” in Scientific notation format
Microsoft Excel
