}bedrock.hier.create.fromrollup - cubewise-code/bedrock GitHub Wiki

Description

This process will make an aternative hierarchy from a consolidated element and its children in default 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:
Valid source dimension name (pSrcDim) and source subset (pSubset) are mandatory, otherwise the process will abort.
If a source hierarchy name (pSrcHier) is specified, it needs to be valid, otherwise the process will abort.

:warning:Caution:

• Target hierarchy cannot be Leaves.
• If the target Hierarchy already exists, 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)
pSrcDim	String		REQUIRED: Source Dimension
pSrcHier	String		OPTIONAL: Source Hierarchy (blank = same name as source dimension)
pConsol	String		REQUIRED: Cons element in source dim to create root element in target
pTgtDim	String		OPTIONAL: Target Dimension (blank = same name as source dimension)
pTgtHier	String		OPTIONAL: Target Hierarchy (blank = same name as target dimension)
pAttr	Numeric	1	OPTIONAL: Include Attributes? (Boolean 1=True)
pUnwind	Numeric	2	OPTIONAL: 0 = Delete all Elements, 1 = Unwind Existing Elements, 2 = Do not change Existing Elements
pRemove	Numeric	0	OPTIONAL: Remove cons elements from source? (1 = Yes, 0 = No)

Full Process Dependencies

Process	ExecuteProcess	RunProcess
}bedrock.hier.sub.create	Y	N
}bedrock.hier.create.fromsubset	Y	N
}bedrock.hier.unwind	Y	N
}bedrock.hier.emptyconsols.delete	Y	N
}bedrock.hier.sub.exclude	Y	N
}bedrock.cube.data.copy	Y	N
}bedrock.hier.sub.create.bymdx	Y	N
}bedrock.cube.data.clear	Y	N
}bedrock.cube.view.create	Y	N
}bedrock.cube.data.export	Y	N