A typical OLAP cube looks like this:
As I can see, this cube can work with 2 or 3 dimensions, but what if I have 4 dimensions to produce facts?
Should I use star schema instead when having more than 3 dims?
Data Science Stack Exchange is a question and answer site for Data science professionals, Machine Learning specialists, and those interested in learning more about the field. It only takes a minute to sign up.
Sign up to join this communityA typical OLAP cube looks like this:
As I can see, this cube can work with 2 or 3 dimensions, but what if I have 4 dimensions to produce facts?
Should I use star schema instead when having more than 3 dims?
Your example is a star schema, it's just a star with three points (dimensions).
It's OK to have star schemas with more dimensions. Some large OLAP schemas can have tens of dimensions.
The star schema holds the underlying data. The cube is a convenient set of pre-aggregated values that make our run-time faster. The "cube" name is a handy visual and linguistic analogy but not a fundamental part of it's definition. Specifically, it is not limited to 3D. As in maths were a hypercube can be reasoned about in many dimension so an OLAP cube can be defined over many star schema dimensions. It just gets harder to draw in marketing literature, is all.