What is attribute in MicroStrategy?

Asked By: Elijah Oursel | Last Updated: 26th February, 2020
Category: technology and computing databases
4.3/5 (236 Views . 24 Votes)
Attributes are defined by these properties: Form contains an identifier or descriptor of an attribute, such as an abbreviation or URL. Expression maps a MicroStrategy attribute form to one or more columns in the warehouse. Relationship allows interaction of data and shows how data is related within a project.

Click to see full answer


In respect to this, what is attribute role in MicroStrategy?

Attribute roles allow you to use the same data to define and support two separate attributes. Suppose you define two attributes that have the same data definition but play different roles in your business model.

Likewise, what is fact in MicroStrategy? Facts generally represent the answers to the business questions on which users want to report. In the MicroStrategy environment, facts are schema objects created by and shared between MicroStrategy users. The facts you create in MicroStrategy allow users to access data stored in the data warehouse.

Regarding this, what is attribute form in MicroStrategy?

Attribute form expressions. Attributes act like holders of information and provide context for fact data. For example, the Customer attribute holds information about the customer such as Name and Address. These information units are called attribute forms. You can also create a form expression using Apply functions.

What are objects in MicroStrategy?

The objects you can create in MicroStrategy fall into one of three groups: schema objects, application objects, and reports and documents. Schema objects: Schema objects are generally created by a project designer and include such things as facts, attributes, hierarchies, and transformations.

11 Related Question Answers Found

How do you resolve attribute Roles in MicroStrategy?

The recommended way to model attribute roles in MicroStrategy 10 is using explicit table aliases. This approach gives project architects direct control over the specific attributes to be treated as different roles, as well as their mappings to logical tables. This level of control can ensure consistent Engine behavior.

How do you create a derived attribute in Microstrategy?

Create a derived attribute and reserve it for future use in a visualization. In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. Create a derived attribute and immediately add it to a visualization. Select the visualization you want to add the derived attribute to.

How do you create a fact?

Follow these steps to create a fact sheet.
  1. Step 1: Create a diverse working group. Fact sheets can be powerful, but they also can represent some groups in a negative light.
  2. Step 2: Decide on a focus.
  3. Step 3: Brainstorm facts and sources.
  4. Step 4: Narrow the facts.
  5. Step 5: Design the fact sheet.
  6. Resources for finding facts.

What are metrics and facts?

Facts form the basis for metrics, which are used in the majority of analyses and reports that you can create with MicroStrategy. Facts do not describe data, instead, they are the actual data values stored at a specific fact level. Facts have two common characteristics: they are numeric and aggregatable.

What is compound attribute in MicroStrategy?


A compound attribute is an attribute with multiple columns specified as the ID column. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present.

What is transformation in MicroStrategy?

Transformation is a shortcut function, available for various features in MicroStrategy Web, that allows you to easily define transformations for the final metric expression. Transformations allow you to apply an attribute-element based offset to compare metric data.

What is schema in Microstrategy?

A schema is a logical and physical definition of warehouse data elements, physical characteristics, and relationships, derived from the logical data model. The logical data model provides a picture of all the pieces of information necessary to understand your data and how it relates to your business.