Question
Can you always convert a consolidation to a custom group and vice versa?
Answer
You can always convert a consolidation to a custom group, but you can only convert a custom group to a consolidation when the custom group filters are from the same table or very similar tables.
Is there any performance issue occur when defined the elements from different dimensions on consolidation? example: {Account=1 and Customer=A and product=P1} + {Account=2 and Customer=B and product=P2} … so on