Defining facts - Microstrategy

The tools to create facts are the Fact Creation Wizard and the Fact Editor. Both of these tools are found in MicroStrategy Architect, which can be accessed through MicroStrategy Desktop. The Fact Creation Wizard is a step-by-step interface that is typically used when you first create a project. It allows you to create facts in bulk; that is, many facts in one creation process. The Fact Editor is used to add advanced features to facts that already exist or to add new facts during the project evolution.

It is important to understand the concept of how to define facts because facts are the basis for almost all metrics. They also allow you to create advanced metrics containing data that is not stored in the warehouse but can only be derived by extending facts.

Example: fact definition

The following table lists fact definitions for simple facts.

Example: fact definition

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

Microstrategy Topics