Skip to content

}bedrock.hier.create.fromattribute

lotsaram edited this page Apr 24, 2020 · 3 revisions

Description

This process will create a new dimension hierarchy from attribute values.

Note:
Valid dimension name (pDim) and attribute name (pAttr) are mandatory, otherwise the process will abort.

⚠️Caution: It is assumed each element exists only once within the hierarchy. This should hold true except in exceptional circumstances.

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
pSrcHier String OPTIONAL: Source Hierarchy, If not specified takes the default Hierarchy
pTgtHier String OPTIONAL: Target Hierarchy, If not specified, takes the same name as attribute.
pAttr String REQUIRED: Attribute
pTopNode String Total <pAttr> OPTIONAL: The name of the Target Hierarchy top element (will default to 'All ' attribute name )
pPrefix String OPTIONAL: Prefix before the attribute value
pSuffix String OPTIONAL: Suffix after the attribute value
pSkipBlank Numeric 0 OPTIONAL: To manage empty attribute: 0= Skip, 1=Send to unallocated node (by default blank attribute values are skipped)
pUnallocated String Undefined <pAttr> OPTIONAL: Naming convention for rollup if attribute is empty (eg. Unallocated , No , Undefined )

Full Process Dependencies

Process doesn't call any dependencies.

test sidebar

Clone this wiki locally