MicroStrategy ONE
Products hierarchy
The products hierarchy contains attributes such as Category, Brand, Catalog, and Supplier.
The Products hierarchy contains the following attributes.
Attribute |
Description |
Example |
Brand |
The manufacturer or artist for a particular product. |
Ayn Rand, 3Com, Sony. |
Catalog |
The medium used to sell products. |
Spring 2006, Fall 2007. |
Category |
Products are organized into categories at the highest level. |
Electronics, Music. |
Discontinued Code |
0 = discontinued product, 1 = non-discontinued product. |
0, 1. |
Item |
The individual product sold. |
The Great Gatsby, Sony Discman. |
Subcategory |
Used to further differentiate a subset of products within a category. |
Business, Cameras, Drama. |
Supplier |
The distributor for a set of brands. |
McGraw Hill, Disney Studios. |
Warranty |
The time period in months during which a manufacturer repairs a broken item (specific to Narrowcast Server). |
3, 5. |
The attributes listed in the table above are some of the most commonly used attributes that are included in the logical definition of the Products hierarchy. Refer to the following image for a complete understanding of the logical relationships of all attributes for the Products hierarchy.