Forum Discussion

Gaurav's avatar
Gaurav
New Contributor III
2 years ago

Deleting unused Dimension from Cube

Hello, 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 al...
Cubes
Metadata
Methodology
JackLacava's avatar
JackLacava
Honored Contributor
2 years ago

If there is data, there is data...

What you could do is this:

  1. extract your base data for scenarios of the type that uses that UD dimension
  2. reset those scenarios, clearing all data
  3. change dimension assignments
  4. reload the data and reconsolidate as necessary.

Alternative:

  1. create a new scenario with a different Scenario Type, using the new dimension. Remember you have the custom ScenarioType1-8, if you don't like the default names.
  2. copy data from the old scenario to the new, with a rule or via export/modify/import
  3. reset the old scenario and then delete it.