Create Project in Microstrategy - Part - I

Vikas GargData Architect
CERTIFIED EXPERT
I am a Data Architect having 14+ Years of experience with the BI technologies like Azure, SSIS, SSAS, Power BI ,SQL Server and SSRS and DW.
Published:
Updated:
Hi,

In my previous Article I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR).

Now it's time to get our hands dirty with Development..
So let's move on....

After installation we need to create Report / Dashboard which is our basic requirement for Analyzing the Data.

From the Start Menu Click on Configuration Wizard and the below screen will appear

Configuration-1.jpg
  • First we have to add Metadata to the Source Database which stores the information which acts as bridge between source Database and Microstrategy.
Configuration-2.jpg
  • Check in Metadata which will create Metadata tables to the Source system. You have to define the Source for which DSN needs to be configured if not configured.
Configuration-3.jpg
  • Click on New in the above screen and MSTR Connectivity Wizard will open for new DSN Creation.
Configuration-4.jpg
  • From the Select we will select Microsoft SQL Server for this article however you can select any of the listed ODBC Drivers.
Configuration-5.jpg
  • Enter the SourceName , Servername and Database name which will be source for MSTR Report. I have checked Windows Authentication click on Test and Click on Finish and New Data Source Will be created and it will appear in the DSN DropDown list. Now enter any prefix which will be added to the tables of metadata so that you can easily identify source and Metadata Tables.



Configuration-7.jpg
  • Click on Next and Data Source will be Configured.
Configuration-8.jpg
  • The next step would be to configure Intelligence Server.
Configuration-9.jpg
  • Select the Above created DSN and in the Table Prefix enter the same prefix entered in the above step for metadata tables.
Configuration-10.jpg
  • Click Next and the Microstrategy default user which was created at the time of installation will appear which will be used to access the metadata repository of MSTR.

Configuration-11.jpg
  • Click Next and then on finish to finish the configuration for Intelligence Server

Configuration-15.jpg
  • With this Configuration is done so you can click on Exit since Project source Creation will be done in Microstrategy Developer which is discussed in Next Article.
So this is how we can configure Microstrategy before making any project for new Data Source. It includes Metadata and Data Source Creation.
 
2
2,551 Views
Vikas GargData Architect
CERTIFIED EXPERT
I am a Data Architect having 14+ Years of experience with the BI technologies like Azure, SSIS, SSAS, Power BI ,SQL Server and SSRS and DW.

Comments (0)

Have a question about something in this article? You can receive help directly from the article author. Sign up for a free trial to get started.