Delete Cube Views in Bulk

Wei
New Contributor III

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

2 REPLIES 2

NidhiMangtani
Contributor III

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.

Thanks,
Nidhi Mangtani

Wei
New Contributor III

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