Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is there a limit on the number of measures in a cube?

Status
Not open for further replies.

devcog

Programmer
Jul 7, 2004
78
GB
Hi,
Is there a limit on the number of measures defined in PowerPlay cube?

Regards,
 
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.

Pain is stress leaving the body.

DoubleD [bigcheeks]
 
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.

John
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top