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

DevinDevin
I've poured enough drinks to know that people don't always want advice—they just want to talk.
Chat with Devin
RossRoss
Every question is just a happy little opportunity.
Chat with Ross
EzraEzra
Faith is not about having all the answers, but learning to ask the right questions.
Chat with Ezra

Add your answer:

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