CMDBuild Forum

Card relations

Old Versions
#1

Hi,

I would like to build a product's bill of material (BOM) list in CMDBuild. As a product is combined by several assemblies, there would be many relations between different classes and cards. The following is the way I am doing now. Please advise if there is any suggestion.

 

1. Create a super-class as a top level of this product.

2. Create a class under a super-class to store all related materials. (Master List)

3. Create a class under a super-class to record relevant materials, which are taken from the master list by setting a domain between two classes and using a "reference" attribute, in each assembly, sub-assembly, sub-sub-assembly. (around 4 levels)

 

My major difficulty is that I cannot generate a full list of product (level 0) with assembly (level 1), sub-assembly (level 2), sub-sub-assembly (level 3), and parts of sub-sub-assembly (level 4). When I filter the master list in Super-class, it seems work, but it is difficult to view which sub-sub-assembly (level 3) is under which sub-assembly (level 2). Is the only view to make clearer to create a attribute in each class to identify which assembly belongs to, and to filter a list by this attribute?

 

Thanks!

#2

Creating superclasses and subclasses implements the relation of specialization, which does not seem to be directly related to your problem.

Perhaps you could create a hierarchy with "product" (level 0), "assembly" (level 1 with an attribute "reference" to "product"), "sub-assembly" (level 2, with two attributes "reference "to" product "and" assembly "filtered through CQL), sub-sub-assembly (level 3, with three attributes" reference "to" product "," assembly "and" sub-assembly "filtered through CQL), and parts of sub-sub-assembly (level 4, with four attributes "reference" filtered through CQL).

You can find a similar example in the openMAINT online demo (http://www.openmaint.org/it/documentation/demo-online), where a "Site" consists of several "Buildings", a "Building" of several "floors" and "Floor" of several "Rooms". On the "Site" card you can see the relationships with "Building", "Floors" and "Rooms".

But a "sub-assembly" can belong to one or more than one "assembly"? If more than one, it would be a N:M relation and you can not create reference fields.

CMDBuild Team