Note: | A cube to which a measure belongs is called the local cube of the measure, and the measure is called a local measure of the cube |
A cube variable, specified by a measure name, represents a cell location in a cube
If a cell variable defines a measure in a local cube, you need not qualify the measure with the cube name.
In the following example, "Beginning Inventory Units" and "Ending Inventory Units" are local measures; therefore, you need not qualify them by the cube name.
"Beginning Inventory Units" = "Ending Inventory Units"[previous(Manufacturing)]
In the following measure definition, the local cube is Supply; therefore, you must qualify the required measure from the Schedule cube.
"Schedule Required"[level(Week)] = Schedule.required
The following cell variable represented by "Dependent Demand Units" represents a cell located at a specific part for a specific time period. Cell variable source.Required represents the cell location for the same time period. You must qualify Required with source; otherwise, it is interpreted as a cell located at the current part and the same time period.
"Dependent Demand Units" =
"Dependent Demand Units" + source.Required * bomScaleFactor(source.Required)
A row source variable represents a column from a row source.
In the following example, ComponentMetrics.standardCost is a row source variable, where ComponentMetrics is a row source name and standardCost is a column in that row source.
"Scrap Cost" = ComponentMetrics.standardCost * "Scrap Units"
To use a row source variable in a formula, you must map the row source to the cube. In the following example, the component column is mapped to a member in the component dimension. ComponentMetrics is a time-varying row source. Each record in the row source has an effective time, which is implicitly mapped to the time dimension in the cube. Using this row source mapping, from a cell location, you can find zero or one record from the row source. If the cell location is mapped to one record, the value of standardCost is the value of the row source variable. If there is no record to which the cell location is mapped, the variable has a null value.
<rm:RowSourceMapping
keyGeneratorClassName="com.interlacesystems.manufacturing.model.ComponentKeyGenerator”>
<rm:RowSource name="ComponentMetrics"/>
<rm:TargetDimension name="Component" memberColumn="component"
namespace="Component”>
<namespace="Component>
</rm:TargetDimension>
</rm:RowSourceMapping>