Compound attributes - Microstrategy

A compound attribute is defined as an attribute with more than one column specified as the ID column. This implies, of course, that more than one ID column is needed to uniquelyidentify the elements of that attribute. Generally, you build a compound attribute when your logical model reflects that a compound key relationship is present.

For example, a retail project has two attributes, Class and Item. Class is the parent of Item and has a one-to-many relationship with it. The values in the Item_ID column do not uniquely identify an item. The item shirt has an Item_ID of 1. However, there are different shirts, depending on theclass—men’s, women’s, and children’s. Therefore, to uniquely identify a man’s shirt, Item_ID and Class_ID must be grouped together, creating a compound attribute.

All of the ID forms of the compound attribute should be grouped together. They should also use the same lookup table.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Microstrategy Topics