Is it possible to remove user defined dimension association from cube (Application>Cubes>Cube Dimensions)?
We've an unused dimension initially created but now we'd like to remove it, as all data is loaded at None member.
But when we try to change that UD7 dimension setting to default (RootUD7Dim), it throws below error:
"Error updating cube. Unable to modify cube 'CUBENAMEXXXX' dimensions because the cube has data."
I know that error is because we've loaded data already but just wondering if there's a way to get rid of this dimension from cube.
If there is data, there is data...
What you could do is this: