Maximum measure in a measure group

Question

Hi,

Is there a limit on maximum number of measure that can be present in a measure group.

Currently my business needs 700 measures to be present in a same measure group, that they want to connect from excel and process.What is the best solution in this case?

Regards,

Raguvind

Answer 1

AFAIK, there is no limit to number of calculations one can introduce in a Fact table. But having all in one measure group will not be aesthetic and end user friendly.

---

Please vote as helpful or mark as answer, if it helps
Cheers, Raunak | t: @raunakjhawar | My Blog

Answer 2

Hi Yogish,

Please refer to the following table:

Object	Maximum sizes/numbers
Measure   groups in a cube	2^31-1   = 2,147,483,647
Measures   in a measure group	2^31-1   = 2,147,483,647

For more information, please look into the following MSDN article about Maximum Capacity Specifications:
http://technet.microsoft.com/en-us/library/ms365363.aspx

TechNet Subscriber Support
If you are TechNet Subscriptionuser and have any feedback on our support quality, please send your feedback here.

Regards,

---

Bin Long

TechNet Community Support

请访问：多产品结合与应用场景论坛