Represents a cube specific dimension based on the IFS Applications fact FACT_RETURN_MATERIAL_LINE. All cubes that refers to this dimension will have the attributes and hierarchies as described below.
Attribute | Hierarchy | Description |
Return Material Line | NO | Key, cast(cast(rma_no_key as int) as nvarchar) + ' - ' + cast(cast(rma_line_no_key as int) as nvarchar) as RETURN_MATERIAL_LINE. |
Return Material Line No | NO | Referred as rma_line_no_key in fact. |
Return Material Line State | NO | Referred as state in fact. |
Return Material Line State Descr | NO | Represents the Return Material Line State Description. |
Return Material No | NO | Referred as RMA_NO_KEY in fact. |
Cube Name |
SALES |
BI Access View | BI Component | Recommended Source Type |
FACT_RETURN_MATERIAL_LINE_BI | ORDEFT | On Line |
Please refer to FACT_RETURN_MATERIAL_LINE