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 a view that uses Years for row titles. Use Select Elements to choose 2014 to 2017.
- Use Versions for column titles. Choose Budget and Actual by using the Select Elements option.
- 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:
Using Rule-Calculated Values
To use rule-calculated values in the copy command, add the
withrules keyword at the end, like in the example below:
copy Actual;2013 withrules
Once selected, you can opt out of using the rule-calculated values by adding the
norules keyword at the end of the copy command, like in the example below:
copy Budget;2014 norules