answersLogoWhite

0

For a typical measure there are 3 to 8 dimensions. In a simple case, you may have Market, Product, Time. Telling where it was sold, what was sold, when it was sold. Or, you could have Geography, Channel, Customer, Product, Time In financial applications, you may have a few measure dimensions to select the data you want: scenario, version, account and then add a time dimension, an entity dimension The issue of dimensionality is discussed in detail in The Multidimensional Data Modeling Toolkit, you may want to take a look at that.

User Avatar

Wiki User

16y ago

Still curious? Ask our experts.

Chat with our AI personalities

FranFran
I've made my fair share of mistakes, and if I can help you avoid a few, I'd sure like to try.
Chat with Fran
ReneRene
Change my mind. I dare you.
Chat with Rene
MaxineMaxine
I respect you enough to keep it real.
Chat with Maxine

Add your answer:

Earn +20 pts
Q: How many dimensions in an OLAP cube?
Write your answer...
Submit
Still have questions?
magnify glass
imp