Creating schema objects is the primary task you perform in MicroStrategy Architect. The following basic schema objects form the foundation of a MicroStrategy project:
– Tables ( Initially you might need to include the tables for to create other schema objects )
– Facts ( The measures available in the fact tables )
– Attributes ( The descriptive data available in dimension tables )
– Hierarchies ( The drilling path for the project for eg: Year->Quarter->Month->Week->Date )
Logical objects that correspond to physical tables stored in the data warehouse that you want to use in a MicroStrategy project
Logical objects that relate aggregatable data stored in the data warehouse to the MicroStrategy reporting
environment. They are usually numeric, and you can aggregate them to different levels, depending on your reporting needs.
Logical objects that relate descriptive (non-fact) data stored in the data warehouse to the MicroStrategy reporting environment. They provide context for reporting on facts and define the level of detail at which you want to analyze facts.
Logical objects that enable you to group attributes to reflect their relationships or provide convenient browsing and drilling paths in the MicroStrategy reporting environment.
The basic schema objects are shown below;
Although you can create other types of schema objects in MicroStrategy Architect that you use for more advanced functions, these basic schema objects are essential to any MicroStrategy project.
In addition to creating new schema objects, MicroStrategy Architect also enables you to manage existing schema objects,so you can modify or remove objects as necessary.
Hope it helps for the day!!
Have a Good Day!!