Create Project in Microstrategy - Part - I

Published on
4,636 Points
2 Endorsements
Last Modified:
Vikas Garg
Myself vikas garg , I am a BI developer and working with the BI technology like SSIS, SSAS and SSRS since 2008.

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

  • First we have to add Metadata to the Source Database which stores the information which acts as bridge between source Database and Microstrategy.
  • 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.
  • Click on New in the above screen and MSTR Connectivity Wizard will open for new DSN Creation.
  • From the Select we will select Microsoft SQL Server for this article however you can select any of the listed ODBC Drivers.
  • 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.

  • Click on Next and Data Source will be Configured.
  • The next step would be to configure Intelligence Server.
  • Select the Above created DSN and in the Table Prefix enter the same prefix entered in the above step for metadata tables.
  • 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.

  • Click Next and then on finish to finish the configuration for Intelligence Server

  • 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.
Author:Vikas Garg

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Join & Write a Comment

Watch the video to learn how one can deal with PST file corruption issue with an outstanding Kernel for Outlook PST Repair Tool easily. Using this tool, non-technical users can swiftly perform the repair process to restore their essential data witho…
In the video, one can understand the process of resizing images in single or bulk. Kernel Bulk Image Resizer is an easy to use tool for resizing large number of images. One can add and resize multiple images with this tool in single go. The video sh…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month