What is an attribute element

Introduction to attributes

Attributes are the business concepts that are reflected in your data. Attributes provide a context in which to report or analyze business facts or calculations. An attribute in a Dossier serves as a label for a group of metrics.

Your company's sales figures should serve as an example. The knowledge that your company has generated sales of 100,000 euros is not very informative in and of itself. In order for this paragraph number to be meaningful, you need additional background details, such as:

  • a time frame for the sales
  • which and how many employees contributed to total sales
  • which products were sold in which departments
  • the area in which the turnover was generated, for example in the whole of Germany, in a certain federal state, in a city or in a branch

Attributes such as “month”, “year”, “department” or “region” can provide the analytical depth necessary to understand your company's sales figures. Use the day, month, quarter, or year attribute to view sales data summarized at the daily, monthly, quarterly, and annual levels.

Attribute creation

MicroStrategy Web automatically creates attributes when you import data. Attributes are indicated with the attribute symbol in the "Data sets" and "Editor" sections.

While viewing a dossier, you can also create new attributes based on existing attributes in your data set.

You can create a derived attribute “year” from a “date” attribute in the format MMDDYYYY.

Attribute elements

Attributes are made up of attribute elements. An attribute element is a value of an attribute.

The “City” attribute contains the “New York” and “Dallas” attribute elements. January, February and March are elements of the month attribute.

Attribute fields

Attribute fields are additional descriptive information about a business attribute. Most attributes only have the fields "ID" and "Description". However, an attribute can have many different fields.

The attribute "customer" contains the fields "first name", "last name", "address" and "email address".

Derived elements

You can group data from multiple attribute values ​​into a single element. This is called a derived element. You can combine attribute values ​​selected from a list or visualization into a single derived element. You can also combine data from attribute values ​​and derived elements in a calculation that defines a single derived element.

other topics

Introduction to attributes, metrics and groups

Introduction to derived attributes

Create a derived attribute by changing the data type of an attribute

Linking data shared across multiple data sets

Select which attribute fields should be displayed in a visualization