}bedrock.cube.dimension.replace

Description

This TI deletes a dimension and adds another one to an existing cube with the ability to preserve data.

Use Case: Intended for development/prototyping.

1. Rebuild existing cube after removal of one dimension and adding anothr one without losing all the data.

Note:
Naturally, a valid cube name (pCube) is mandatory otherwise the process will abort.
Also, valid dimension names (pSrcDim & pTgtDim) are mandatory otherwise the process will abort.
When data needs to be kept (using pIncludeData) a valid element (pEle) in new dimension must be specified where to store the data. Data is summed from original dimension.
Rule can be kept as backup file only or reloaded back.

Process Parameters

Parameter	Data Type	Default	Prompt Text
pLogOutput	Numeric	0	OPTIONAL: Write parameters and action summary to server message log (Boolean True = 1)
pCube	String		REQUIRED: Cube
pSrcDim	String		REQUIRED: Dimension to be replaced
pTgtDim	String		REQUIRED: Replacement Dimension
pIncludeData	Numeric	0	REQUIRED: If 1 then data is kept (copied through clone cube)
pEle	String		REQUIRED: If pIncludeData =1: Element in target dimension to load data to
pIncludeRules	Numeric	0	REQUIRED: Unload and reload the rule (0 = do not keep the rule, 1 = unload the rule, 2 = unload the rule and reload on new cube)
pCtrlObj	Numeric	0	REQUIRED: Allow overwrite control cubes
pTemp	Numeric	1	REQUIRED: Delete the clone cube (1 = delete, 0 = not delete)

Full Process Dependencies

Process	ExecuteProcess	RunProcess
}bedrock.cube.rule.manage	Y	N
}bedrock.cube.clone	Y	N
}bedrock.cube.create	Y	N
}bedrock.cube.data.copy.intercube	Y	N
}bedrock.cube.delete	Y	N
}bedrock.hier.sub.create.bymdx	Y	N
}bedrock.cube.view.create	Y	N
}bedrock.cube.data.clear	Y	N
}bedrock.cube.data.export	Y	N
}bedrock.hier.sub.create	Y	N
}bedrock.hier.sub.exclude	Y	N