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.