Consolidation Strings

The following sections list the consolidation strings that can be used in consolidation rule-sets and rules. Consolidation strings provide logical references and can be selected from the dimension member selector.

To include consolidation strings:

  1. Create a rule or rule-set.

    See Creating Consolidation Rule-sets and Creating Consolidation Rules.

  2. From the bottom of the Member Selector dialog box, select Members.

  3. From the drop-down options, select Consolidation Strings, then select a string.

  • #Legal Company#

    The Legal Company string determines whether the current Entity or Intercompany member represents a Legal Company. All base entities are Legal Companies.

    You can use the Legal Company string for the Entity or Intercompany dimensions in a rule condition or in the Source POV.

  • #Any ICP that is a descendant of the current parent#

    This string can be used in the Intercompany dimension Source POV and restricts the in-scope data-set to those data-points that have an Intercompany dimension entry that represents a descendant of the parent entity of the Entity currently being processed.

  • #Source POV Entity#

    This string can be used in the Intercompany dimension redirection. The Intercompany member used to write the data will be the Intercompany equivalent to the Entity in the Source POV ("ICP_<Source POV Entity>").

    If the Source POV Entity has not been designated as a valid Intercompany member (and the "ICP_<Source POV Entity>" member does not exist), then the redirection will be ignored and the data will be written to the Source POV Intercompany member. If the Source POV Intercompany member is a parent member, then the rule and consolidation process will fail.