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? Man...
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