-
Notifications
You must be signed in to change notification settings - Fork 76
}bedrock.hier.create.fromrollup
lotsaram edited this page Apr 18, 2019
·
3 revisions
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.
- Create a new hierarchy for testing.
- 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.
Leaves
.
- If the target Hierarchy already exists, then it will be overwritten.
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) |
test sidebar