}bedrock.cube.dimension.add

Description

This TI adds a dimension to a cube that has already been built with the ability to preserve data.

Use Case: Intended for development/prototyping.

1. Rebuild existing cube with extra dimension without losing data.

Note:
Naturally, a valid target cube name (pCube) is mandatory otherwise the process will abort.
Also, a valid new dimension name (pDim) is mandatory otherwise the process will abort.
When data needs to be kept (using pIncludeData) a valid element (pEle) must be specified where to store the data in new 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 name
pDim	String		REQUIRED: Dimension to be added
pDimIndex	Numeric	1	REQUIRED: Dimension number of the new dimension in the cube
pIncludeData	Numeric	0	OPTIONAL: If 1 then data is kept (copied through clone cube)
pEle	String		REQUIRED: if IncludeData flag =1: Element of new dimension where to store data
pIncludeRules	Numeric	2	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	OPTIONAL: Allow overwrite control cubes (default = 0)
pTemp	Numeric	1	OPTIONAL: 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