The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Gaurav's avatar
Gaurav
New Contributor III
3 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
Icon for OneStream Employee rankOneStream Employee
3 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.