If there are already values in your cube, you can use the copy command to read out values of a cube cell and copy them (including distribution) directly into another one.
Copying cell values will not yield the same results as splashing them. Splashing splits the value among the subsequent base elements; for example, if you enter #11587765 in cell C10, this value will be divided evenly among the 19 base elements that make up the dimension “Europe”, so that each base element has a Budget 2016 of 609,882. Copying, however, maintains the source values of the elements being copied. In this case, Germany gets the copy of Actual:2015. This is 1,255,385.
- The copy command is not case sensitive. You can write copy, Copy, or COPY.
- The sequence of the arguments in the formula is irrelevant.
- If an element name is used in more than one dimension, you have to prefix it with the name of the dimension you want to use, followed by a colon (for example: copy Years:2015).
- Element names or dimension names with a blank space, semi-colon, colon or quotation mark must be enclosed in quotation marks, e.g.: copy “Desktop L”. Quotation marks in element or dimension names must then also be prefixed by another quotation mark.
- The process can fail if there are different dimensions in the cube with elements of the same name. In this case, you also have to enter the name of the element’s dimension. The combination of dimension name and element name is unique. Use a colon as a separator; for example: Copy Versions:Actual; 2015
The following example uses data from the Demo database to illustrate the copy command.
Create the following view:
- For row titles, use Years, and via “Select Elements…” choose 2014 to 2017.
- For column titles, use Versions, and via “Select Elements…” choose Budget and Actual.
We will splash the values from 2016 to 0 in order to calculate, as an example, these values from previous years.
Your view should look like this:
Copy the Actual figures of 2015 to the Budget of 2016. Go to cell C10 and enter
Copy Actual;2015 or alternatively Copy Versions:Actual;2015
You will get the following result: