Forum Discussion

Wei's avatar
Wei
New Contributor III
3 years ago

Delete Cube Views in Bulk

Hello Experts,

We are trying to do some tidying up and would like to delete cube views (and DM jobs etc) in Bulk. Is there an easier way to handle this rather than delete one by one manually?

Many thanks

Wei

Methodology
  • NidhiMangtani's avatar
    NidhiMangtani
    Contributor III
    3 years ago

    Hi Wei,

    Pull out XML having cube views you want to delete.

    Modify the XML manually by adding the action as "delete" in the cubeviewitem tag

    <cubeViewItem name="***" description="***" isVisibleInProfiles="true" isShortcut="false" shortcutCubeViewName="" action="delete">

    Try loading this modified XML.

    Same for data management steps/sequences.

    This approach works for removing metadata relationships/members in bulk. Let me know this works for other components as well.

    Hope this helps.

    • Wei's avatar
      Wei
      New Contributor III
      3 years ago

      Hi Bharti,

      Many thanks - I tried that already - the xml went through without the error but the cube view is still in the system, not being deleted.

      Thanks

      Wei