No real hard limit, but I'd caution about building too many measures into a cube as the more measures are included, the larger the cube gets. Typically, I wouldn't suggest over 50 measures as this presents too many options for the end users.
If your users have to sift through too much information, they won't use your cubes. I attempt to focus the purpose of cubes and keep the measures under 12.
Not to mention that each additional measure must be aggregated up to each partition level, so if you have more than just the 0 partition your cube is going to get big, fat, and slow in a hurry.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.