MicroStrategy | About Schema Objects

Before getting to know about Schema Objects, lets talk about how MicroStrategy Metadata database plays here. The MicroStrategy metadata contains all the information needed for a MicroStrategy project to function, including data warehouse connection information, project settings, and MicroStrategy object definitions. However, the most fundamental objects stored in the metadata are schema objects. Schema objects are logical objects that relate application objects to data warehouse content. They are the bridge between your reporting environment and your data warehouse. As such, you have to create the basic schema objects a project requires before you can complete any other tasks, such as creating templates, filters, reports, or documents.

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 )

Tables
      Logical objects that correspond to physical tables stored in the data warehouse that you want to use in a MicroStrategy project

Facts
      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.

Attributes
     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.

Hierarchies
     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!!