Cube Dimension - Return Material Line

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.

ATTRIBUTES

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.

USED BY CUBE

Cube Name
SALES

ETL Information

BI Access View BI Component Recommended
Source Type
FACT_RETURN_MATERIAL_LINE_BI ORDEFT On Line

Please refer to FACT_RETURN_MATERIAL_LINE