Creating the first project. Right click on the project Source that we have already created. Select Create project Wizard. Give the project name and Db instance. Then Select tables to be included in the project. All the dimension and fact tables must be selected.
Select all the measures in Create Fact section.
Physical table and Logical Table
When we add a physical table to microstrategy project, It will create a corresponding table in the project metadata with the same name. Logical tables stores information about the physical table like name, columns data types etc. The engine uses logical table to create SQL to generate reports.