Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm trying to understand cubes so thought I would create a simple datamart to represent my filesystem.

So my question is, if I wanted to create a simple datamart to represent my filesystem, how would it look?

I'm just thinking one fact for the files, and a few dimensions for file extension, maybe a date dimension and few others.

eg factFiles dimExtensions

Some guidance/suggestions would be appreciated.

share|improve this question

1 Answer 1

Personally when i got started out with SSAS the best thing i found to do was run through the examples using Adventureworks. The tutorials are here: http://msdn.microsoft.com/en-us/library/ms170208(v=sql.110).aspx You may need to use the dropdown to select the version of sql server you intend to use.

The pre-reqs take you through getting sample data installed. They're actually very good tutorials to follow along with. I went through them when 2005 was the latest version so can't necessarily vouch for the more recent editions but i'm sure they're of equal quality.

Thanks,

Simon

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.