Question: What are the general considerations when dealing with large dimension sizes (i.e., 100K members)?

In general, dimension sizes of this nature should be avoided
and would tend to indicate transactional level members. In this case,
the following alternatives should be considered:
• Can the additional detail be captured via stage attributes, which can then be
reported on using relational blending??
• Would the additional detail be more properly suited for use in one of our
MarketPlace Solutions (e.g., Thing Planning), which can also be reported
against with Relational blending?

Source: Office Hours  2019-07-11