Let us use the Menu items sold by categories cube in this example.
Now, it is possible to change the dimensions of this object, such as fact, actual dimensions, horizontal, vertical, and outer dimensions. When dragging and dropping an object, the dimensions change automatically.
To use the Self-Cost as a parameter for a formula of any new fact, you should first turn the Self-Cost into a fact. |
Once the calculatable fact is created (for example, Self-Cost Amount), in the fact properties, set Calculate Formula as a calculation type. Indicate the calculation formula, for example [Quantity]*[Self-Cost]. Check the Before grouping box.
Please, pay attention to the System name property. Later, it will be used when editing the layout for a new report. |