<

Create Project in Microstrategy - Part - I

Published on
4,677 Points
1,477 Views
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.
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
Comment
Author:Vikas Garg
0 Comments

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

Join & Write a Comment

Key to your CPU's ability to stay cool is to use the right amount of thermal paste and apply it correctly. In other words you want as much thermal conductivity between CPU and the cooling block. Use a quality thermal paste and apply it in a manner…
Overview of OneDrive and collaboration.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month