Forum

Hi.

I have a mechanism working like Characteristics of Items (in Small Business - AdditionalAttributesAndInfo). I have object added in Charts of characteristic types and object added in Information registers metadata that saves records defining the type and value of a characteristic. Same as in Small Business dimensions - Object, Property; Resource - Value.

For example I have such 4 records:

Object - Property - Value
Characteristic 1 - Power - 100
Characteristic 1 - Color - Red
Characteristic 1 - Size - 10x10
Characteristic 1 - Pattern - White wall

The properties are not stable or predefined, it's defined while usage of user. So, is there any technical way (by using query and DCS) to get those records as 1(one) record:

Object - Power - Color - Size - Pattern
Characteristic 1 - 100 - Red - 10x10 - White wall

You can use Columns group. For example in Data composition settings wizard.