Profile selections on query based SCV hierarchies

A table can be created to specify query-based SCV hierarchies which is used to apply profile selections. SCV Prepare Profile program uses the specified profile table name and the hierarchy-table link between that table and the current hierarchy to apply the hierarchy selections:

• Prepare Hierarchy program populates <TABLE>_H table with IDs of the records in <TABLE> and the corresponding base level value in the current hierarchy.
• Prepare Hierarchy program populates the <TABLE>_P table with IDs of the records in <TABLE> that satisfy the profile selections defined the <TABLE>.
• Prepare Hierarchy program joins <TABLE>_H table and <TABLE>_P table to determine which base level values in the current hierarchy satisfy the profile selections and populates the SC_HIERARCHY_P table accordingly.

When the base level of the SCV hierarchy is sourced from a table:

• The Profile Table Name in the base level of the hierarchy is mandatory. If not specified, no records are available for the current hierarchy in SC_V_HIERARCHY.
• Hierarchy-Table Link between the specified Profile Table Name and the current hierarchy is mandatory. If not specified, no records are available for the current hierarchy in SC_V_HIERARCHY.

When the base level of the SCV hierarchy is sourced from a query:

• The Profile Table Name in the base level of the hierarchy is optional. If not specified, all records are available for the current hierarchy in SC_V_HIERARCHY without applying a profile selections.
• If Profile Table Name is specified, Hierarchy-Table Link between the specified Profile Table Name and the current hierarchy is mandatory. If hierarchy-table link is not specified, no records are available for the current hierarchy in SC_V_HIERARCHY.