Data Management Best Practices – Part 4

Oleg Shilovitsky
Oleg Shilovitsky
26 July, 2021 | 4 min for reading
Data Management Best Practices – Part 4

Today, I’ll be continuing a series of articles about OpenBOM data management best practices. If you missed the first 3 parts, please check this link for Part 1, Part 2, Part 3

In my previous articles, we discussed fundamental data objects (properties, catalogs, and product structure/BOM/). Today I’d like to talk about “Views”. Before continuing with this chapter, I recommend you read the following articles from OpenBOM training

Data vs. View 

To understand views, you need to get through this simple, but fundamental data management paradigm, which is called view. In all data management systems, the properties define the actual data, while views are built on top of the data and provides you with a lens to look through the data. An important thing to remember – if you have no data, the view will show you nothing. 

So, this is how it works in OpenBOM. The data is represented in data objects. (eg. Catalog, BOMs, etc.) Let’s say you have an Item with the following four properties (Part Number, Description, Manufacturer, Supplier). I can define a view that will include only three properties (Part Number, Description, Manufacturer) and exclude the Supplier from that view. However, if I define a view with the property “Cost” and try to apply it to the catalog, I won’t see a property “Cost” in the view, because the property “Cost” is not defined in the real catalog properties.How to Plan Data and Views  

Our recommendation is to follow this process to plan data and views and make it easy to manage. You can apply this 3 step process to manage data and views. 

STEP 1: Define data properties, catalogs, and BOMs 

Follow your plan to define the data first. Decide about catalogs, what properties you need for each catalog, and also what properties you need to define in BOMs. 

If you work with CAD add-in, I recommend exporting the data to get samples of the information from your CAD design in OpenBOM. It will help you with data management planning. Use the “View is OFF” switch in OpenBOM when you do this planning and never switch it to any views (even if you have one). It will allow you to see the data you define.

STEP 2: Plan what user-defined views you need and create views 

Once you have all your data properties, BOMs, and catalogs defined, you can plan user-defined views. The easiest way to define a view is to navigate through the BOM (or catalog), add a new View (or choose the existing view), and click on the Edit icon. Use “Get Property from BOM” or “Get Property from Catalog” commands to get the full list of properties. Then delete the properties you don’t need and add filters. 

You can edit properties and add/remove properties later in this view from the list of all properties (for example if you need to create a view that contains properties from multiple catalogs or BOMs). Use the Administration View option. 

STEP 3: Plan role-based access using Team Views

This feature is only available for Team or Company subscriptions and it allows you to set up view access levels for different members of your team.Video 

This is a short video demonstrating best practices of how to create a user-defined view and not make mistakes. 

Conclusion 

Views are a fundamental mechanism in OpenBOM to customize data appearance and also to manage role-based access to the information. 

It is important to remember that views are dependent on the data and if you don’t see the data you expect to see in the view, then in 99% of the situation, it is because the data property is not defined (absent) or misdefined (used different property, different name, different type, etc.). 

Views is a powerful mechanism that allows you to tune the way you access information and makes OpenBOM a flexible tool to access the right data by your team, contractors, and suppliers. 

If you haven’t done so already REGISTER FOR FREE to learn what OpenBOM can do for you. 

Best, Oleg

Related Posts

Also on OpenBOM

4 6
3 July, 2025

Walk into any engineering office today, and you’ll see it immediately: Excel open on someone’s screen. Spreadsheets have been the...

2 July, 2025

Engineers rarely build entirely new products from scratch. Whether designing machinery, electronics, or high-tech projects, most products are evolutions of...

1 July, 2025

At OpenBOM, our vision has always been clear – to create an open and flexible information model, built using modern...

30 June, 2025

At OpenBOM, we know that managing changes is one of the most critical – and often challenging – aspects of...

27 June, 2025

At OpenBOM, we talk to manufacturing companies of all sizes – startups, mid-sized innovators, and established enterprises, and most of...

26 June, 2025

Products are becoming increasingly complex and teams are distributed across geographies. It brings up a question about how to improve...

25 June, 2025

At OpenBOM, we make engineering data accessible to business functions—procurement planning, supply chain management, cost estimation, and more.But to make...

24 June, 2025

If you work in engineering or manufacturing, you probably spend a lot of time trying to keep your data organized—BOMs,...

20 June, 2025

We are at a time when companies are looking for a new way to engineer and manufacture products – one...

To the top