Model: Procurement - Specifications for Dimension Table: CAT ASSORTMENT NODE

On this page you will find the specifications regarding the Model: Procurement and Dimension Table: CAT ASSORTMENT NODE.

This model dimension represents Category Assortment Node and is based on the IFS Cloud dimension DIM_PROC_CAT_ASSORTMNT_NODE. All models that refer to this dimension will have the attributes and hierarchies as described below.

Attributes

Attribute Description (where applicable)
Assortment CodeRepresents the Code of the Assortment
DescriptionRepresents the Description of the Assortment Node
Node CodeRepresents the Code of the Assortment Node
L1Represents Level 1 in the Assortment Structure. Shown as Node Code - Description of the level.
L10Represents Level 10 in the Assortment Structure. Shown as Node Code - Description of the level.
L2Represents Level 2 in the Assortment Structure. Shown as Node Code - Description of the level.
L3Represents Level 3 in the Assortment Structure. Shown as Node Code - Description of the level.
L4Represents Level 4 in the Assortment Structure. Shown as Node Code - Description of the level.
L5Represents Level 5 in the Assortment Structure. Shown as Node Code - Description of the level.
L6Represents Level 6 in the Assortment Structure. Shown as Node Code - Description of the level.
L7Represents Level 7 in the Assortment Structure. Shown as Node Code - Description of the level.
L8Represents Level 8 in the Assortment Structure. Shown as Node Code - Description of the level.
L9Represents Level 9 in the Assortment Structure. Shown as Node Code - Description of the level.

Hierarchies

Hierarchy Level
CatAssortHy
Assortment Code
L1
L2
L3
L4
L5
L6
L7
L8
L9
L10

USED BY MODEL(S)

Model Name

Data source Information

The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.

Additional information can be found in the online documentation of Information Sources.

Model Table BI Access View Referenced Information Source Recommended Access Type
CAT ASSORTMENT NODEDIM_PROC_CAT_ASSORTMNT_NODE_BIDIM_PROC_CAT_ASSORTMNT_NODEOn Line