Star-Schema Leveling Column Fields

The “SSLeveled” property enabled generates new columns in corresponding Star-Schema Dimension Tables. BiBlend will ONLY aggregate the ultimate base members of an extended dimension.  Loading a member that becomes a parent as a result of dimension inheritance will result in NO aggregation for the extend parent.

• IsBIBlendBase: Reflects the hierarchy status of where the actual data records exist. Restricts the creation of leveling only on members that contain data in the data table. Designates the member as a base (1) or parent member (0) by the usage in the BI-Blend data table.

• Level x: Zero-based to maximum descendent depth only on member where BI Blend data exists.

NOTE: The BI Blend leveled hierarchy is only available for star schema-enabled workflows.