Project Creation – Hello World


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.

Advertisements

Comment please...

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s