Home > Uncategorized > MS BI Workshop #17 – Steps to create an SSAS database

MS BI Workshop #17 – Steps to create an SSAS database

Here are the steps you can take to create an SSAS database using BIDS.

  • 1. Create an SSAS project in BIDS.
  • 2. Create a data source (DS)  that connects to your data warehouse in star schema.
  • 3. Create a data source view (DSV) to act as a layer between your data source and the data warehouse and to protect you from changes.
  • 4. Run the Cue Wizard to create the first cube and dimension.
  • 5. Finally, modify the cube and dimensions to scale better and be properly formatted.
Categories: Uncategorized
  1. July 10, 2011 at 2:57 pm

    And make sure “no impersonate in date source” otherwise building passes but deployment fails

    Like

  1. No trackbacks yet.

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 )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: