The first step in the project design process is to design the logical data model. Before getting to know how to design a logical data model, lets understand the basic concepts of logical data model & how it plays a role in MicroStrategy project (ie) the components that come into picture in this project design process.
A logical data model is a diagram that shows the information you want to analyze in a project and how that information is related. It typically depicts the flow of data in an organization, and it should make sense to even the most basic of end users. It does not show the physical structure of how the information is stored in the data warehouse.
The logical data model should include any information users want to see on reports that you can obtain from relevant source data. Logical data models can be simple or complex, depending on the nature of your reporting requirements and the structure of available source data.
The simple logical data model :
This logical data model shows the relationships within customer, time, geography, and product data and how these types of data are related to each other through a series of facts.
In MicroStrategy, the schema objects map the information in your logical data model to physical tables and columns in the DWH.
The Quarter and Month attributes and the Revenue fact relate the logical objects from the data model to the appropriate physical tables and columns in the data warehouse. You can then build a MicroStrategy report using these objects that displays revenue by quarter and month. You can use the Quarter and Month attributes directly on the report. You can create a Revenue metric based on the Revenue fact and use this metric on the report. When users run the report, the MicroStrategy Engine generates SQL to obtain the result set based on how you defined the underlying schema objects.
Hope it helps to know about what logical data model is & how it is related to MicroStrategy!!
Have a Good Day!!