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.