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, with 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. The matching between element name and dimension is handled by the system. For example, the following entries would perform the same task:
20000000 like 2018;Actual
like 20000000 2018;Actual
- If an element name is used in more than one dimension, you have to prefix it with the name of the dimension to be considered, followed by a colon (for example: like Years:2018).
- Element names or dimension names with a blank space, semicolon, 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.
Example: ‘-12000000 like “Gross Profit”;2018
- 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;2018
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 2021 according to the shares of Actual in the year 2018.
Entry: 20000000 like Actual;2018 in C14: