}bedrock.cube.dimension.replace - cubewise-code/bedrock GitHub Wiki
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.
- 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 |