Skip to content

}bedrock.hier.consol.delete

lotsaram edited this page Apr 18, 2019 · 5 revisions

Description

This process will delete a specified C-Level item or ALL consolidations in the dimension hierarchy.

Use Case: Could be used during development or in production.

  1. Delete a specific or all C-Level items in a hierarchy.

Note:
Valid dimension name (pDim) is mandatory otherwise the process will abort. Control dimensions are excluded.
The hierarchy (pHier) will default to pDim if not specified, otherwise it must be valid else the process will abort.
ALL consoldidated items in hierarchy will be deleted if consolidated item (pEle) is NOT specified, otherwise it needs to contain valid c-level item(s) else it will abort.

⚠️Caution: Target hierarchy (pHier) cannot be Leaves.

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 name
pHier String Optional: hierarchy name (if blank then same named hierarchy as dimension is assumed)
pEle String Optional: filter on elements (element list separated by delimiter, accepts wildcards (if * then all the consolidation elements get deleted))
pDelim String & Optional: delimiter character for element list (required if pEle parameter is used)
pTemp Numeric 1 Optional: Use temporary objects? (Boolean 1=True)

Full Process Dependencies

}bedrock.hier.sub.create.bymdx
}bedrock.hier.sub.delete

test sidebar

Clone this wiki locally