Plan documents for SSAS

Question

Post reply

Plan documents for SSAS

Anamika

SSCertifiable

Points: 6202
More actions
September 24, 2008 at 2:57 am

#191404

Hi,
Can anyone help me in planning a new SSAS project? Something like a work flow where to start and how to end?
Or links(articles) to the above will do a lot for me.
Thanks
Regards
Viji

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Chandra Sekhara Vyas Dhara SSChampion Points: 10207 More actions · Answer 1

check following links

http://www.microsoft.com/sql/technologies/analysis/overview.mspx

http://searchsqlserver.techtarget.com/generic/0,295582,sid87_gci1262093,00.html#

denglishbi SSCrazy Eights Points: 8831 More actions · Answer 2

There is lots of content all over the Internet in regards to SSAS tutorials and overviews. Here are a few for you to checkout - http://www.accelebrate.com/sql_training/ssas_tutorial.htm or you might like videos then http://channel9.msdn.com/wiki/sqlserver/[/url] or if you like hands-on labs then http://go.microsoft.com/?linkid=5981304 (all of the technet and msdn virtual labs are located here - http://www.microsoft.com/events/vlabs/default.mspx).

Enjoy!

----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com

Anamika SSCertifiable Points: 6202 More actions · Answer 3

Thanks for your reply & links. they are highly useful.

i'm expecting kind of 'plan' documents how to approach SSAS project. what are the things you should make ready like summary tables, things to be considered before creating a SSAS project.

and would be fine if somebody helps how to call a cube from .Net

Thanks

Regards

Viji

A-442845 Grasshopper Points: 18 More actions · Answer 4

Hi,

You can consider the following things before starting a SSAS project:

-- Thorough understanding of the database and the relations between them

-- Identifying dimensions and facts based on the business requirements. Here you can also create a matrix with facts in the row and possible dimensions in the column. This will give a clear idea on which fact is using which dimension.

-- Identifying attributes in the dimension and the relations between them. This is a very important step as this will define how your data is aggregated.

-- Identifying hierarchies for each dimension.

-- Identifying Base measures and calculated measures

-- Currency conversion, if any

-- Time related calculated measures

-- You can identify if your cube needs to be updated with the latest data using proactive caching and how this will be implemented.

-- Security to be implemented on the cube

-- Method for storing historical data in cube like Partitions

You can document the above in the Conceptual Data Model Document

Hope this helps you.

REgards

Archana

denglishbi SSCrazy Eights Points: 8831 More actions · Answer 5

I would recommend checking out all of the content on the Kimball Group's site and also their book The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft Business Intelligence Toolset. There is lots of excellent content in regards to designing a data warehouse solution and creating a dimensional model to be used for SSAS. You will definitely need to understand what the purpose is of the solution and what the business is trying to accomplish. Getting all of the requirements as to how the business wants to view the data, where the data resides, how clean the data is (profiling the data), business calculations, etc. will all lead to a successful project.

----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com