Create & Publish a Data Cube for SQL Server Analysis Server

This video shows how to use Business Intelligence Development Studio (BIDS) to create an data cube for SQL Server Analysis Server 2008
This demo shows how to:

Use BIDS to create a data model project
Create Data Sources, Data Views, Dimensions, & Cubes
Deploy the project to SSAS 2008

Category:

Science & Technology

Tags:

• BIDS
• create
• data
• cube
• SQL server
• analysis
• 2008
• model
• project
• data cube
• data source
• data view
• dimensions
• SSAS
• SQL server analysis
• visual studio

[cootology]

excellent stuff! thanks!

[happpymedy]

Excellent! Straight to the point and you covered what I needed to know

[zuruprem]

Lol it is excellent and straight forward.

[evelyn11100]

lol you gotto learn Cube creation urself before educating someone...

[hasanthedude]

very helpful, thanks for sharing

[markmd9]

the truth is out there

[DrBillRoe]

@mcai9mh3 Use Excel 2007 or an in-house developed VisualStudio solution. Excel 2007 is the preferable solution - it is so simple to connect to an Analysis Services database (cube).

[mcai9mh3]

Very helpful thanks. But how do the Business users view the cube?

Is the only reason to create a cube so you can query it in Management Studio or is there some kind of front end?

[6akama]

really helpfull

[6akama]

can you please load other videos of devolping BI dolution like calculation sales amount