Back

How to delete the complete hierarchy and suggest it again

Master Data in Hierarchies
Video 6/8
Play
Close
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
An advanced video is for the experts, and it requires detailed knowledge about the specific area of Business Central. Advanced Watch "the details", if you need detailed knowledge about a specific topic. These videos are only relevant for particular users. The Details This video includes functionality from the app "Master Data Information" which is available at Microsoft AppSource. Click to visit AppSource. Master Data Information

Playlists  Manage

Log in to create a playlist or see your existing playlists.

Open Playlist
Presenter: Sune Lohse, Chief Strategy Officer

If you have changed a lot in master data or re-imported many items or recreated many master data, you want to recreate a full hierarchy if you want to do that.

I’ll show you how it’s possible to do in here.

But of course you need to be aware of the data structure and what you’re deleting because this is a complex data set up beneath it.

In this example, I have some fixed records in here, as you can see, and I have some automatically created master data information.

Um, and of course I have all my master data and I cannot just delete on a specific level.

So if I’m trying to delete my Citi bike here with data beneath it and I’m removing specification from the hierarchy, you can only delete from the bottom of the hierarchy.

Likewise, if I’m going into my master data relation, trying to remove whatever in, in a specific level in here and I want to delete it, I would expect to have some kind of error as well, saying that you can only remove from the bottom of the hierarchy.

So it could be a very complex thing to handle all of it.

If you want to remove or delete everything, this is the way to do it.

First of all, you enter the fixed master data relations.

You need to delete all of those, and you have to remember to clear the filter so you see all of them.

I have only three of my example here.

I’ll delete those manually.

Then you need to delete your master data item relations in here, master data item relations, all of them, because otherwise it’s not possible to delete the master data relations with the specifications on it like this.

Then we have left.

If we refresh the hierarchy, now we can see that we only have the hierarchy lift, so we need to remove, or it’s an advantages to remove empty master data relation because this is basically all of it except for the two top level, and now we have removed everything.

If I’m going back into my master data relations, now I can delete the two top records in here and then I’m back where I started.

It’s possible now for me to re suggest master data relations in here to recalculate my master data item relation, and then in here to remove the empty master data relations.

So this is a way of doing it.

Let me just show you the full hierarchy here.

So if I refresh it now, it has no items.

If I update my item relations like this and I refresh the hierarchy, it has all the items.

If I scroll down, I’ll find it somewhere down here, my records that actually contains items in here.

And again, if I remove all the empty master data relations, I have a nice hierarchy only with the structure that actually contains data.

And the only thing I’m losing in this example is that I’m losing my fixed relations, so I have
to recreate those manually.

939465377-LWsO7VV-4nM-ENG24032856