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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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: 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.



share|improve this answer

Your Answer


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.