If there are already values in your cube, you can use the like command to read out an existing distribution under a consolidated cell and copy it using another value in another cell.
To use the like command, select the target cell and type in the new value and the command “like” (not case-sensitive). Then follow with a precise description of the source cell. You only need to type in those elements that differ between target and source.
- The like command is not case sensitive. You can write like, Like, or LIKE.
- The sequence of the arguments in the formula is irrelevant. It also works with the entry:
20000000 like 2015;Actual. The matching between element name and dimension is handled by the system.
- 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:
- Element names or dimension names with a blank space, semi-colon, colon or quotation mark must be enclosed in quotation marks, e.g.:
like "Desktop L". Quotation marks in element or dimension names must then also be prefixed by another quotation mark.
- When you enter a number with a sign, you have to put an apostrophe in front of the sign.
'-12000000 like "Gross Profit";2015
- 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:
like Versions:Actual; 2015
The following example uses data from the Demo database to illustrate the like command. We will split the new budget value 20,000,000 for 2017 according to the shares of Actual in the year 2015.
20000000 like Actual;2015 in C10: