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


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: