}bedrock.hier.consol.flat.create

Description

This process will add consolidated element pTgtConsol in the dimension hierarchy.

Use Case: Intended for Development but could be used in production too.

1. Create a new hierarchy for testing.
2. Create a new hierarchy to reflect new business needs.

Note:
If source parent element (pSrcConsol) is defined then all its leaf elements will be copied to target parent element consolidation. Otherwise all leaf elements in the dimension hierarchy will be added into target parent element consolidation.
Valid source dimension name (pDim), hierarchy (pHier) and taget parent element (pTgtConsol)
are mandatory otherwise the process will abort.
Weight of all added elements into target parent consolidation will be assigned accoring to pWeight parameter value.

⚠️Caution: If the target pConsol exists in the hierarchy, then it will be overwritten.

Process Parameters

Parameter	Data Type	Default	Prompt Text
pLogOutput	Numeric	0	OPTIONAL: Write parameters and action summary to server message log (Boolean True = 1)
pDim	String		REQUIRED: Dimension
pHier	String		OPTIONAL: Hierarchy (will default to dimension name if blank)
pSrcConsol	String		OPTIONAL: Source consolidated element name
pTgtConsol	String		REQUIRED: Target consolidated element name
pWeight	Numeric	1	OPTIONAL: Component Weight

Full Process Dependencies

Process	ExecuteProcess	RunProcess
}bedrock.hier.unwind	Y	N