Ravendra's Blog

May 11, 2010

How to Create Analysis Database

Filed under: MSAS, Microsoft Analysis Services, OLAP, MDX, Cube, SSIS — Ravendra Mishra @ 4:58 pm

Open business intelligence studio and create new analysis server project.

Create new data source. This is the source of data based on which olap database will be created. This may be the SQL database where your tables are stored.

Create new data source view.

Create new cube. Select the data source, select measure and dimension tables.

This is what it gives when you click Next button


Next you need to select dimension tables


Rebuild the database to check if everything is ok. Once build is successful try to deploy it.

Right click on the project and change properties to specify the server name where you want to deploy this database. Deployment progress is displayed on separate window


Create a free website or blog at WordPress.com.